Chat now with support
Chat with Support

Stat 6.0 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Country Maintenance Customer Maintenance Object Type Maintenance PeopleSoft Environment Connection Maintenance Pre/Post Migration Steps Parameters Oracle Applications Configuration Oracle Applications Connection Maintenance Generic Application Connection Maintenance Schema Object Parameters Maintenance Data Object Maintenance PeopleSoft Search Configurations Stat Report Definition Maintenance Version Control Management Connection Maintenance
Service Domain-Specific Maintenance Configuring the Stat Central Agent Email Configuration Object Security Appendix: Sample Service Domain Configuration Appendix: User Class Rights Appendix: Creating a Staging Database Appendix: Database Tuning Appendix: Oracle Applications File Type Directory Appendix: Ports and Firewalls Appendix: Stat Web Services Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

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. 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.

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.


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.

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:

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

Related Documents