Stat 6.3 - User Guide

Setup Objects

Quest® Stat® allows you to archive and migrate configuration data contained in your Oracle® Apps environments by providing change management support for a number of predefined setup object types. Stat supports the foundation setup (AOL) object types.

You archive and migrate setup objects the same way you do file objects. However, because setup objects contain configuration data, they cannot be migrated into users’ working directories. Stat transparently integrates with FNDLOAD, AKLOAD, WFLOAD, XML Importer, XML Exporter, xdfgen.pl, scfcmp.pl, XDoLoader, and XLIFFLoader to process archive and migration requests.

IMPORTANT: Be aware of the following when migrating setup objects: • The default UPLOAD mode for AOL Menu objects is REPLACE instead of MERGE. • Stat architecture includes a framework for extending the list of Oracle E-Business setup objects that can be supported by the product. The Resource Kit for Oracle E-Business (maintained and available for download independently of Stat releases) utilizes this framework to add additional setup object types to the list of available object types. The Resource Kit for Oracle E-Business organizes setup objects into logical groupings based on E-Business applications so that you can selectively add the desired types. The latest Resource Kit for Oracle E-Business is available on SupportLink, and includes further documentation on supported application setup objects, and installation instructions.

Data Objects

Data objects are user-defined or third party data sets residing in your Oracle® Applications environments that your system administrator has configured Quest® Stat® to support. You can lock, archive, and migrate data objects the same way you do file objects.

Schema Objects

Quest® Stat® supports certain schema object definitions for Oracle® Applications environments. In the Oracle Applications change management module, schema objects are migrated by the Stat Oracle Agent. This allow Stat to enforce the migration order specified in the archive set.

Stat currently supports the following schema object types:

NOTE: Schema objects include a set of predefined true/false parameters that are executed before the definition of the object is captured in Stat. You can change the true/false values of these parameters in the Schema Object Parameters Maintenance table. For more information, see the Stat System Administration Guide, Chapter 4, “General Maintenance Tables.”

IMPORTANT: Stat only deletes and replaces schema objects that have drop/create operations in the script. If the schema object does not have drop in the script, then the migrator must delete the object from the target environment prior to migration.

Patch Objects

Quest® Stat® provides comprehensive patch support for Oracle® Applications. You can associate with a CSR any patch that has been downloaded from Metalink, Oracle’s web support service, and uploaded to the Stat Repository.

Like schema objects, you can lock patch objects on a CSR but you cannot archive or migrate them. Instead, you use the Stat Oracle Application Management Console to apply the patch you want to a specified target environment.

To associate Oracle patches to a CSR, the Patches tab must be enabled. The enabling of the Patches tab is determined by CSR type. For more information, see The Oracle Apps Management Console .