Stat 7.0 - System Administration Guide

Updating Products per Environment

Each Oracle Applications environment you define may feature a different set of Oracle Applications products. In order to utilize Stat’s change management support for proprietary Oracle Applications file objects, 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 of the Application Options window.

IMPORTANT: Many new features in Stat supporting R12.2 rely on the Release Level of the AD record in the list of products for each environment. After successfully starting the Oracle agent, the next step is to update the product list for each R12.2 environment.

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. When you first define an environment, or when you install new Oracle Applications products to a particular environment, you should update the environment’s product list. To do this, 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.

NOTE: You can also update the products list of an environment in the Products tab of the Oracle Application Configuration window. For more information, see Updating Products .

Copying Oracle Applications Environments

If you need to define an Oracle Applications environment that closely resembles an existing Oracle Applications environment, you can save time by copying the definition of the existing environment and editing the copy as needed. When you copy an Oracle Applications environment, all the information gets copied over, including server definitions and approval lists.

Generic Application Connection Maintenance

The GenApps Environment Connection Maintenance table defines the generic (non-PeopleSoft and non-Oracle Applications) application environments connected to Stat. The table closely resembles the connection maintenance tables for PeopleSoft and Oracle Applications, and many of the maintenance procedures are the same. Within the definition for each environment is the information Stat needs to connect to it.

Connection security for generic applications is controlled by the following user class rights:

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

Testing Environment Connections

After defining an environment in the maintenance table, you can make sure that you have entered all the information correctly by clicking Test Connection. This makes Stat establish a connection to the newly defined environment. If successful, Stat immediately disconnects from the environment and displays a “Connection Successful” message. If Stat is unable to connect, it displays an error message.

You can also test connections to multiple databases simultaneously. To test multiple connections, hold the <Ctrl> or <Shift> keys and select the databases you want to test. Then click Test Selected. Stat attempts to establish a connection to each database and reports its results in the Database Test Connect window

Note that when you test a single environment, Stat does not validate the values specified in the fields Host Name, Service Name, or DB Listener Port. If any of these fields are not configured properly, the Stat Central Agent will log an error when the user attempts to migrate an object to or from the environment. When you test multiple connections, however, Stat does test both client and agent connections, including Host Name, Service Name, DB Listener Port or (in the case of Oracle-based environments) TNS Entry.

NOTE: When testing environment connections in the Stat Web Client, Stat Web attempts to connect using the Host, Port, Service Name, and TNS Entry values specified in the Stat maintenance tables for each particular environment. If there is no TNS Entry value specified for an environment, it uses the Host/Port/Service Name values. If a TNS Entry value is specified, it uses that value and disregards the others.