Stat 6.1 - User Guide

Object Comments

Right-clicking on a selected object in the object list opens a pop-up menu with additional functions. Select Edit Comments from this pop-up menu. This opens the Object Comments window.

In this window you can edit or add comments to an object. You should use this space to document the changes made, why they were made, and any other pertinent information. You can also cut, copy, and paste into this window. You can add comments up to 2,000 characters in length.

For objects that have been added via the Read CSR Wizard, Stat automatically inserts a comment noting the source CSR, the date and time, and the user who performed the action.

Patch Management

The Oracle Apps Management Console

Quest® Stat® provides comprehensive patch support for Oracle® Applications. After downloading the patches you need from Metalink, the Oracle web support service, you can use the Stat Oracle Applications Management Console to manage and keep record of these patches, associate them with a CSR, and apply them to your Oracle Applications environments.

The Oracle Applications Management Console displays a record of each patch that has been uploaded into the Stat Repository. From here you can upload new patches, edit the Stat attributes associated with the patches, merge two or more patches into a single patch, and schedule the execution of particular maintenance steps before or after a patch is applied to an environment. To open the Oracle Applications Management Console, select Consoles | OraApps Patch Console.

The Patch Inventory tab displays information in a read-only format. To edit a patch, select it and click Edit. This opens the Edit Oracle App Patch window where you can deactivate the selected patch or modify its definition.

Table 5. Patch definition values
Value	Description
Active	Indicates if the patch is active in the Stat Repository. Only active patches can be associated with a CSR and applied to an environment or merged.
Patch Type	The type of patch.
Patch Name	The ID number that Oracle Support assigns the patch for tracking purposes.
Description	A user-defined description of the patch.
Tar/SR	The Internet service or technical assistance request number that Oracle Support assigns the issue.
In CSR	Indicates if the patch is associated with a CSR.
Merged	Indicates if the patch is a merged patch.
Merged Member	Indicates if the patch has been used to create a merged patch.
Product Family	The Oracle Applications application family targeted by the patch.
Product	The specific Oracle Applications application targeted by the patch.
Version	The Oracle Applications version number for the patch (11i is currently the only option).
Last Update	The date and time the patch record was updated in Stat
Update Userid	The ID of the user who last modified the patch record in Stat.
Member Patches	If the selected patch is a merged patch, this field displays the ID numbers of the merged member patches.
Associated CSRs	Displays the CSR numbers of the CSRs the patch is associated with, if any.

The Oracle Apps Management Console

Patch Management

Table 5. Patch definition values
Value	Description
Active	Indicates if the patch is active in the Stat Repository. Only active patches can be associated with a CSR and applied to an environment or merged.
Patch Type	The type of patch.
Patch Name	The ID number that Oracle Support assigns the patch for tracking purposes.
Description	A user-defined description of the patch.
Tar/SR	The Internet service or technical assistance request number that Oracle Support assigns the issue.
In CSR	Indicates if the patch is associated with a CSR.
Merged	Indicates if the patch is a merged patch.
Merged Member	Indicates if the patch has been used to create a merged patch.
Product Family	The Oracle Applications application family targeted by the patch.
Product	The specific Oracle Applications application targeted by the patch.
Version	The Oracle Applications version number for the patch (11i is currently the only option).
Last Update	The date and time the patch record was updated in Stat
Update Userid	The ID of the user who last modified the patch record in Stat.
Member Patches	If the selected patch is a merged patch, this field displays the ID numbers of the merged member patches.
Associated CSRs	Displays the CSR numbers of the CSRs the patch is associated with, if any.

Uploading Patches

Stat's patch import utility enables you to upload Oracle® Applications patches to the Quest® Stat® Repository. When you upload a patch, Stat automatically unzips the zip file downloaded from Metalink and reads the contents of the Readme file. From this point forward, the zip file is managed within Stat. The Readme file and other information within the zip file is used by Stat to populate several fields in the Patch Inventory tab with default values. You can complete the definition of the patch by specifying additional patch values as needed.


	TIP: You can download patch files that have been uploaded to the Stat Repository. For more information, see the next section, Downloading Patches .

To upload a patch:

Click New.

Stat opens the New Oracle Patch window.

Click the File tab. Then click Upload.

This opens the New Oracle App Patch dialog box where you specify the location of the patch zip file.

Locate the patch zip file and click Open.

Stat opens the Patch Upload dialog box where you can specify a different platform and language for the patch.


	NOTE: An uploaded patch in Stat can contain one or more Oracle patch zip files. For example, a separate platform release zip file may be imported for a patch.