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. This is done in the Products tab of the Application Options window.
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.
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.
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.
The GenApps Environment Connection Maintenance table is displayed in a standard maintenance window. To open this window, select Maintenance | General | Generic Application Connect.
The version number of the generic application, 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.
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.