Chat now with support
Chat with Support

We are currently experiencing issues on our phone support and are working diligently to restore services. For support, please sign in and create a case or email for assistance

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

Setting Up Physical Object Lock Exclusions

The second tab of the PS Options window, Object Lock Exclusions, displays a list of all the PeopleSoft proprietary object types that can be physically locked in the selected non-staging environment. You can exclude any of these file types from physical object locking, which lets you control which types of objects users can physically lock while operating in a certain environment. The list of object types varies depending on the version number of the PeopleSoft environment.

Click OK or Apply.

For more information on physical object locking, see PeopleSoft Proprietary Object Security and the “Object Management” sections in the change management chapters of the Stat User Guide.

Setting Up Migration Approval Lists

If an environment requires the approval of certain users before an archive set can be migrated into it, you can specify who these users are in the Migration Approval List tab. Stat activates this tab only if Req. Migr. Approval has been selected for the environment in the PeopleSoft Environment Connection Maintenance table.

When setting up a migration approval list, you can include different approver groups, including individual users and entire user classes or a combination of the two. The approval of any user or user class that you add to a list can be either required or optional.

Approval requirements that involve multiple approver groups or that can be satisfied in more than one way are defined using AND and OR operators. As you add approver groups using AND and OR operators, Stat displays the list as a tree structure and in the form of a SQL statement at the bottom of the window.

For example, let’s say a migration to a particular environment in the Financial Services service domain can be approved in one of two ways:

In this case, your approval list would look like this:

To further illustrate, let’s say that the migration must be approved by:

In this case, the approval list would look like this:

It is recommended that before setting up a migration approval list, you have a basic idea of what approver groups (users and user classes) you want involved in the approval process as well as the relationships between these groups, which you define using AND and OR operators. For example, if the approval of one or more approver groups are required, you would begin the approval list with the AND operator. If, however, the approval of only one of two or more approver groups are required, you would begin the list with the OR operator.

Click AND if the approval of one or more approver groups are required
Click OR if the approval of one of two or more approver groups are required
In the Service Domain field, select the service domain that you plan to associate the environment with in the PeopleSoft Migration Path Maintenance table.
In the Approver Type field, select the approver group you want to add to the list.
Options include User and User Class.
In the Approver Name field, select the name of the user or user class you want to add.
In the Required field, select Required if the approval is required or Optional if it is not required.
The Required option means that the individual user and every member of the user class must approve the migration. Optional means that the individual user’s approval is not required, whereas for user classes, it means that the approval of only a specified minimum number of users within that class is required.
If you selected User Class in the Approver Type field and Optional in the Required field, specify the minimum number of users in that class who must approve the migration in the Number field.
Click Add.
Click AND or OR.
Click OK or Apply.

Copying PeopleSoft Environments

If you need to define a PeopleSoft environment that closely resembles an existing environment, you can save time by copying the definition of the existing environment and editing the copy as needed. When you copy a PeopleSoft environment, all the information gets copied over, including file locations and selected PS options.

Click Copy.

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:

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

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:





Service domain code



PeopleSoft Project

PS and Generic only


Source database name



Migration source database user password



Migration source database user name



Source environment code



Target application system password

Oracle Apps only


Target application system user name

Oracle Apps only


Target apps password

Oracle Apps only


Target apps user name

Oracle Apps only


Target database listener port



Migration target database name



Migration target database user password



Migration target database user name



Target environment code



Target host name



Target object name



Target object path

PS and Generic only


Target service name



Target system password

Oracle Apps only


Target TNS entry


Click New.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating