Stat 6.2 - System Administration Guide

Updating Products

Each of your Oracle Applications environments may feature a different set of Oracle Applications products. In order to utilize Stat’s change management support for the proprietary file objects in your Oracle Applications environments, as well as apply product-specific Oracle patches to the appropriate environments, you need to specify the products that each environment contains. For Oracle Apps Setup objects, each environment may have a different list of active products. To retrieve the proper list of Setup Objects in Stat, it is imperative that the list of products are updated. This is done in the Products tab.

Except for the Active check box, the Products tab is read-only. It displays a list of all the products contained in the selected environment along with their release level. When you first define an environment, install new Oracle Applications products to a particular environment, create a custom product, or apply a maintenance pack, you should update the environment’s product list. To do this, select the environment you want to retrieve the product list for and click Update Products. This sends a request to the Stat Oracle Agent, which updates the list with any fully installed, shared, or custom products it finds for the selected environment. To deactivate a product, deselect Active.


	NOTE: You can also update the products list of an environment in the Products tab of the Application Options window, which you open from the Oracle Application Environment Connection Maintenance table.

When updating products, be aware of the following considerations:

•

For Stat to recognize a custom product, the product must have a record created in the FND_PRODUCT_INSTALATIONS table. To create this record, select System | Installations in the Oracle Alert Manager responsibility and use the form to define the custom product. It will be necessary to re-start the Stat Oracle Agent after this record is created. Also, custom products may need to be defined in the stat.conf file before they can be updated in Stat. For Release 12.2, Stat reads the values for custom product locations from the Context File of the environment. If these parameters are present in stat.conf, they override the values in the Context File.

•

Oracle stores all form FMB files in the same directory ($AU_TOP/forms/<lang>). When getting a list of forms for a user to assign to a CSR, Stat uses two sources to determine the FMBs associated with the product selected by the user: All FMBs registered for the product are considered and all FMBS with a corresponding FMX file in the product top are considered. If a form is not registered or does not have an FMX file, Stat will not include it when displaying a list of forms. This limitation does not affect forms for custom applications since Stat also considered FMBs in the product top for custom applications.

Languages

In the Languages tab you configure Stat to support change management for language-specific, proprietary Oracle Applications file objects as well as translation patches. The Language tab is read-only. It displays a list of all the languages enabled for all environments. The default language is American English. You can update the list for any Oracle Application environment first by selecting an environment in the dropdown list and then clicking Update Languages.

To deactivate a language, deselect Active.

If you need to migrate AOL objects in multiple language versions, do the following to configure language support AOL object in Stat.

Select the Oracle Application environment containing the AOL objects you want to migrate in the drop-down list and click Update Languages.

Verify that the languages you want supported are installed.

Add the AOL objects you want to migrate to a CSR.

When you select the AOL object in a multi-lingual environment, you are prompted to select a language.


	NOTE: The following objects are exceptions: XDO Templates, XDO Translations, OAF Component XML, and XDF Editioning View (R12.2). Also, no prompt is displayed if only American English is installed.

After adding the objects to the CSR, each object’s description will have the language appended to the end. Also, after an archive set has been created successfully, you can view and verify the content of the archive set.

Open the archive set in the Objects tab, select an object, and click View.

A View Archive window is displayed showing specifics about the object, including the language.

Patch Prerequisites

In the Patch Prerequisites tab you specify the default environment against which Stat will process patch prerequisite requests whenever users upload and save a patch. Specifying a default environment is optional.

Oracle Applications Connection Maintenance

The Oracle Applications Connections Maintenance table defines the Oracle Applications environments and servers that Stat can connect to. These are the environments available for selection on CSRs and the various object wizards. Within the definition for each environment is the information Stat needs to connect to it.

Oracle Applications connection security is controlled by the following user class rights:

•

Oracle Connection - Add

•

Oracle Connection - Edit

The Oracle Application Connection Maintenance table is displayed in a standard maintenance window. To open this window, select Maintenance | General | Oracle Applications Connect.


Value	Description
Active	If selected, indicates that this environment is active in Stat
Environment Cd (Key Value)	A 1-10 character code which uniquely identifies the environment. This is the code that must be used in the Stat Oracle Agent configuration file.
Description (Required Value)	A 1-35 character description of the environment
OraApps Version (Required Value)	The version number of the Oracle Applications environment. Options include 11i and R12.
Data Obj Version	The Oracle Applications version number, as defined in the Data Objects Maintenance table. Select a value in this field only if you plan on using Stat to manage data objects within this environment.
Req. Mgr. Approval	If selected, indicates that archive sets cannot be migrated to the environment without approval
Req. Patch Approval	If selected, indicates that patches cannot be applied to the environment without approval
DBMS (Required Value)	The Oracle database management system that the environment is running on
Database Name	TNSNAMES.ORA entry on all Stat users’ workstations. Used by Stat Client for Oracle Net connections to the Oracle Applications database.
APPS User	Name of the APPS database account holder
APPLSYS User	Name of the APPLSYS database account holder
SYSTEM Pwd	SYSTEM database account password
APPS Pwd	APPS database account password
Host Name	Name of the machine hosting the database. Used by the Stat Central Agent and the Stat Oracle Agent for JDBC connections to the Oracle Applications database. Required value for the Stat Central Agent.
Service Name	For Oracle, the listener service of the database. Used by the Stat Central Agent and the Stat Oracle Agent to establish JDBC connections to the Oracle database. IMPORTANT: Required value for the Stat Central Agent, even when Tns values are specified.
DB Listener Port	Port number for the database listener. Used by the Stat Central Agent and the Stat Oracle Agent for JDBC connections to the Oracle Applications database. Required value for the Stat Central Agent.
Use Tns	For RAC Oracle databases, configures Stat to invoke TNS
Tns Entry	The full description as it appears in the tnsnames.ora file with no line breaks or carriage returns
Other Database Parameters	Additional environment-specific parameters, if needed
Last Update (Read Only)	The date and time this record was last updated
Update By (Read Only)	The user who last updated this record

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Stat 6.2 - System Administration Guide

Updating Products

Languages

Patch Prerequisites

Oracle Applications Connection Maintenance