Chat now with support
Chat with Support

Stat 6.1 - 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: Stat Web Services Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Pre/Post Migration Steps Parameters

In the Pre/Post Migration Steps Parameters Maintenance table, you can define user and server-based parameters that can be included in the definition of pre and post migration custom command steps. This provides a convenient way to insert variables such as server names and passwords in custom commands. And because parameter values can be encrypted, sensitive information that you do not want visible to the users executing the commands can be secured.

The table also includes a number of predefined parameters, which specify commonly invoked values used to login into an environment during a migration or to invoke Stat web services.

A user must have one of the following rights to open the Pre/Post Migration Step Parameters Maintenance table:

•
Pre/Post Migration Server Parm - Add
•
Pre/Post Migration Server Parm - Edit
•
Pre/Post Migration User Parm - Add
•
Pre/Post Migration User Parm - Edit

For more information on pre and post migration steps, see the sections, Pre Migration Steps .

The parameters defined in this table are public, meaning that they specify a set default parameter values that can be included in the definition of any custom command pre and post migration step. It is possible, however, to define parameters and parameter values that are specific to individual users or servers. User and server-specific parameters can be used in conjunction with public parameters, while parameter values specific to users and servers can be used to override the default values of public parameters:

•
User-specific parameters (such as user names and passwords) apply to particular Stat users, who define them themselves. For more information on user-specific parameters, see the book, Stat User Guide, “Appendix: User-Specific Parameters.”
•
Server-specific parameters (such as home directories and version numbers) apply to particular file servers. You can define server-specific parameters here, or you can define them on the File Servers tab of the Object Type Maintenance window. For more information, see the section, Server-Specific Pre/Post Migration Step Parameters .
•
Predefined parameters are commonly used parameters included as a convenience. These parameters, which specify values used to login to an environment during a migration or to invoke Stat web services, are read-only and cannot be modified or removed. Certain predefined parameters are specific to particular change management modules, as noted in the table below:
Predefined Parameter
Description
Module

CSR_ID

CSR ID

All

SD_CD

Service domain code

All

PS_PROJECT

PeopleSoft Project

PS and Generic only

SOURCE_DB_NAME

Source database name

All

SOURCE_DB_PASSWORD

Migration source database user password

All

SOURCE_DB_USERNAME

Migration source database user name

All

SOURCE_ENV_CD

Source environment code

All

TARGET_APPLSYS_PASSWORD

Target application system password

Oracle Apps only

TARGET_APPLSYS_USERNAME

Target application system user name

Oracle Apps only

TARGET_APPS_PASSWORD

Target apps password

Oracle Apps only

TARGET_APPS_USERNAME

Target apps user name

Oracle Apps only

TARGET_DB_LISTENER_PORT

Target database listener port

All

TARGET_DB_NAME

Migration target database name

All

TARGET_DB_PASSWORD

Migration target database user password

All

TARGET_DB_USERNAME

Migration target database user name

All

TARGET_ENV_CD

Target environment code

All

TARGET_HOSTNAME

Target host name

All

TARGET_OBJECT_NAME

Target object name

All

TARGET_OBJECT_PATH

Target object path

PS and Generic only

TARGET_SERVICE_NAME

Target service name

All

TARGET_SYSTEM_PASSWORD

Target system password

Oracle Apps only

TARGET_TNS_ENTRY

Target TNS entry

 

* 
NOTE: The parameters used to login into source and target environments include the database (identified by name or environment code) as well as user names and passwords. These values are encrypted.
To define a pre/post migration step parameter:
1
Depending on the type of parameter you want to define, select either the User Parameters or Server Parameters tab.
2
Click New.
3
Enter the parameter name.
4
Enter the parameter value.
This is the parameter’s public default value, which can be overridden by a user or server-specific value that is defined for the public parameter.
* 
NOTE: If you do not enter a parameter value, the value defaults to null.
5
Select the encrypted option if you do not want the parameter value to be visible to users executing the pre/post migration custom command step.
6
(Optional) Enter a description of the parameter.
7
Click OK.

Oracle Applications Configuration

The Oracle Applications Configuration table defines operating parameters for uploading Oracle Applications patches into the Stat Repository and providing change management support for Oracle Applications objects. These parameters include patch types, products and product families, and the languages supported by your Oracle environments.

For more information on Oracle Patches, see the book, Stat User Guide, Chapter 12, “Change Management for Oracle Applications.”

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

Patch Types

In the Patch Types tab, you specify which Oracle Applications patch types you want Stat to support. Patch types are used in the Patch Console to categorize uploaded patches. When first installed, Stat is pre-configured to support the most common Oracle Applications patch types. You can edit the names of these patch types as needed, or you can define new patch types.

To define a patch type:
1
Click New. Then in the Patch type field, enter the name of the patch type, for example, Family Pack.
2
Click OK or Apply.

Product Families

Stat comes pre-configured with all Oracle product families. In the Product Families tab, you can define new Oracle Applications product family groups or de-activate existing ones. The product family values specified here are used in the Oracle Apps Patch Console to categorize Oracle patches that are uploaded to the Stat Repository and then applied to your Oracle Applications environments.

The individual products that make up a product family are defined on a per environment basis in the Products tab.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating