Chat now with support
Chat with Support

Stat 6.3 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Issue Tracking 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: REST Web Services API Appendix: SOAP-Based Web Services API 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. 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

In case an environment is retired and no longer needed, you may select the environment and click the Delete Products button in order to remove the list of products for that environment..

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.

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.

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.

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

Weblogic Password

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

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating