Stat 6.3 - User Guide

When you are assigned a file object, Quest® Stat® places a copy of that object in one of your predefined working directories. These working directories are defined either by a system administrator in a maintenance table, or you can define them yourself in the User Default Directories tab of the Stat User Options window.

The User Default Directories tab displays a list of the active file types defined in Stat for Oracle® Applications environments. From here you can define your default working directory and a separate working file directory for each file type. Defining a working directory for a file type is optional. If a file type working directory is not defined, Stat places copies of the migrated file objects in your default working directory.


	NOTE: In the case of OAF file objects, Stat also copies files from any subdirectories in the assigned user's working directory. Be aware, however, that when migrating OAF objects into a working directory, the same subdirectories have to exist. Stat is not able to create them. This is also the case if the Copy to Working option is selected. See Associating Objects with CSRs (Oracle Applications) for more information.

To set up a default working directory:

Select User Options | Stat Options. Then open the User Default Directories tab of the Stat User Options window.

In the Module field, select Oracle Applications.

In the Default Working File Server field, select the server for the default working directory.

In the Default Working File Path field, enter the path of the default working file location starting after the file server’s root or home path.

Click Apply or OK.

To set up a file type working directory:

Select User Options | Stat Options. Then click the User Default Directories tab of the Stat User Options window.

In the Module field, select Oracle Applications.

In the File Type column, select the file type you want to have a working directory for.

This activates the text box in the corresponding Working File Server column.

In the Working File Server column, select the server that the working directory is on.

In the Working File Path column, enter the path of the working file location starting after the file server’s root or home path.

Click either Apply or OK.

Adding Objects from VCM

You can use the Add Objects to a CSR from VCM feature to add multiple file objects at once to your CSR from a VCM repository

To add objects from a VCM repository using Add Objects to a CSR from VCM:

On the Objects tab, click the Add Objects from VCM... button. The Add Objects to a CSR from VCM window will display. The window, by default, displays (in the right pane) all of the files from all of the existing directories and subdirectories in the VCM repository. The left pane displays all of the existing directories and subdirectories. To filter the files displayed, select the desired directory and subdirectories in the left pane. Once a directory/subdirectory is selected, only the files in that directory/subdirectory will be displayed.


User Controls	Description
Revision	(Optional) Allows you to specify the VCM repository’s revision/label from which to display any and all associated file objects. A revision/label can be manually entered along with the Retrieve button or to get a list of existing revisions/labels click the Retrieve button. The list of shown directories and file objects are filtered by the selected Revision.
Object Type	Allows you to assign a specific object type to the selected file objects in the file object list (the right pane). Select one or more file objects in the right pane and choose an object type in the list to associate those file objects with the object type.
Copy to Working	(Optional) If selected, the selected file objects (in the right pane) are copied from the VCM repository to your working directory as well as added to the CSR (upon clicking Add to CSR and saving the CSR).
Overwrite Existing Files	(Optional) Used in conjunction with Copy to Working, when selected any chosen file objects (in the right pane) of the same filename as any files in your working directory, will replace those files in your working directory. Otherwise, when unchecked, files of the same filename won’t be overwritten.
OA Base (Oracle Apps Only)	Allows to associate the correct Server Environment Variable with Generic and/or Custom OA file objects that are in the VCM repository. This allows Stat to associate the correct base directory with the Generic and/or Custom file objects.
Product (Oracle Apps Only)	Allows to associate the correct Product with Predefined, Custom with Prod, and/or Custom with Prod/Lang OA file objects that are in the VCM repository. This allows Stat to associate the correct Product and its directory settings with these files upon adding the file objects to the CSR.
Language (Oracle Apps Only)	Allows to associate the correct Language with Predefined and/or Custom with Prod/Lang OA file objects that are in the VCM repository. This allows Stat to associate the correct Language and its directory settings with these files upon adding the file objects to the CSR.
Set for All (Oracle Apps Only)	(Optional) When selected at the time of setting the value of OA Base, Product, and/or Language then the corresponding fields of each file is set accordingly all at once (in the right pane). When this option is not selected, then only the selected file objects (in the right pane) are assigned the chosen values of OA Base, Product, and/or Language.
Summary	Displays the total number of file objects (by Object Type) that have been selected (in the right pane); so that you can see how many total files of each Object Type and the total number of files in all will be added to the CSR. Note: Selected file objects that have not been associated with an Object Type are not counted in the Summary totals. Selected file objects must be associated with an Object Type before they can be added to the CSR (via Add to CSR).
Add to CSR	Closes the window and adds the selected files (in the right pane) to the CSR. Note: If and when a selected file or files are not associated to an Object Type, you will be prompted to associate the selected file or files with an Object Type. All selected files must be associated with an Object Type before they can be added to the CSR.
Cancel	Closes the window without adding any selected files to the CSR.

Search for and select the file objects (in the right pane) that you want to add from the VCM repository to the CSR.

Associate the desired/selected file objects with the appropriate Object Type. This can be done in few ways: You can select a file or multiple files and then choose a type in the Object Type list box. Upon selecting an Object Type, the selected files in the files pane will be associated with that Object Type. You can associate a file individually with an Object Type by clicking on the Object Type field in the files pane for that file. A list of available object types will display allowing you to select one.

Once all the desired file objects are associated with an Object Type and are selected, click Add to CSR. The Add Objects to a CSR from VCM window will close and the selected file objects will be added to the CSR

Associating Objects from Other CSRs

You can use the Read CSR Wizard to add objects that are associated with another CSR.

To run the Read CSR Wizard:

On the Objects tab, click Read CSR.... Stat opens the CSR Read Wizard.

Click the Lookup button.

Stat opens the Search CSR Engine, which locates specific CSRs in the database based on the selected search criteria, including CSR number, customer, open date, department, and tracking number. For more information, see Search Engines .

Locate the CSR you want in the Search CSR Engine. Then click OK.

Quest® Stat® closes the Search CSR Engine and displays all the objects associated with the CSR in the bottom portion of the Read CSR Wizard.

Select the objects you want. Use the <Shift> and <Ctrl> keys to make multiple selections, or click Select All to select all the objects.

Click OK.

Stat adds the selected objects to your CSR. If the objects happened to be locked on the other CSR for the same environments specified in your CSR’s migration path, Stat reserves them on your CSR.


	NOTE: The assigned developer and lock options specified on the Objects tab of the CSR are applied to any objects added to the CSR by way of the Read CSR Wizard.

Creating File Objects

With proper security rights, you can create a new file object, add it to a CSR, and move it to the assigned working directory of the developer. When creating a file object, you can use a file template, or base it on an existing object.

In Quest® Stat®, file templates are associated with particular file types. They help standardize development by defining in a reusable format the basic characteristics and structure of new file objects. This way, when you need to create a file object of a particular type, you can use an associated template as a starting point. This saves time and helps enforce adherence to development standards.

When new Oracle® file objects are created from an existing object, Stat remembers the new objects association with the source object. When the source object is identified during a patch impact analysis, Stat indicates the source object was used to create a new object. This alerts you that a patch may impact this custom object.

To create a file object:

On the Objects tab, select an environment and object type.

Click New Object.

Stat opens the New Object window, with the assigned developer and object type that you previously selected displayed as default values.

(Optional) In the Assigned To field select a different developer.

In the Source field, do one of the following:

•

Select Existing Object if you want to base the new file object on an existing object

•

Select Template if you want to base the new file object on a template

(Optional) In the File Type field select a different file type.

Do one of the following:

•

If basing the new file object on a template and your system administrator has defined more than one template for the selected file type, select the file template you want to use in the Template field. Then select the language and product you want to associate with the object in the New object Language and Product fields.

•

If basing the new file object on an existing object, select the active environment in which the object resides in the Environment field. At this point, if the object you are basing the new object on is a predefined (i.e. non-custom) Oracle file type, Stat prompts you to select the product and language the existing object is associated with. Select the product and language and click Fetch. Stat queries the environment and retrieves all the objects of the selected type, product, and language. Select the object you want and, if applicable, then select the language and product you want to associate with the new object in the New object Language and Product fields.]


	IMPORTANT: If the Oracle Agent is not running when you click Fetch, Stat is unable to process the request and displays a warning message. When this is the case, re-start the agent and click Fetch again. Also, if you are basing the new object on an existing, custom Oracle file type object, you are not prompted to specify a product or language for either the existing object or the new object. After you select an environment, Stat queries that environment and retrieves all the objects of the custom file type you selected.

In the New Object Name field, enter a name for the new object.

The appropriate file extension is automatically appended to the name based on the file type you selected.

Click Create.

Stat displays a series of warning messages telling you that the object does not exist in each environment in the migration path. For each environment, Stat asks you if you want to add the object to the CSR.

Click Yes for each instance of the object that you want to add to the CSR. Click No for each instance of the object that you do not want to add.

Stat adds each instance of the new object that you selected to the CSR. At this point, the file object exists only in the working directory of the assigned developer but is not yet archived. For more information on archiving, see Creating Archive Sets (Oracle Applications) .

製品を選択してください:

サービス向上のために、「Purpose of your Chat（チャットの目的）」を記入してください。

お客様の不具合に推奨されるソリューション

Stat 6.3 - User Guide

Defining Working Directories for File Objects

Adding Objects from VCM

Associating Objects from Other CSRs

Creating File Objects