Stat 7.0 - System Administration Guide


	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
System user	The schema name which the EBS is using for database Administrator. IMPORTANT: Until now this value was hard coded as SYSTEM and it's still SYSTEM by default, however this value is configurable now. After the EBS_SYSTEM schema migration completion patch is applied on the user's EBS instance, this value should be updated EBS_SYSTEM manually by the user. This column is introduced in 6.2 HF-o.

Testing Environment Connections

Oracle Applications Connection Maintenance

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
System user	The schema name which the EBS is using for database Administrator. IMPORTANT: Until now this value was hard coded as SYSTEM and it's still SYSTEM by default, however this value is configurable now. After the EBS_SYSTEM schema migration completion patch is applied on the user's EBS instance, this value should be updated EBS_SYSTEM manually by the user. This column is introduced in 6.2 HF-o.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Stat 7.0 - System Administration Guide

Languages

Patch Prerequisites

Oracle Applications Connection Maintenance

Testing Environment Connections