Stat 6.3 - User Guide

Main Console Window

By default, the console displays all the migration jobs that have been submitted to the Stat Central Agent within the last 7 days, but this time frame can be modified by system administrators.

Select the Show All Migrations option to view all the migrations run by all users.

From here you can print or export the list by pressing the appropriate button. You can also filter the list using SQL commands. For PeopleSoft users, you can check the lock status of staging databases.

The main console window displays the following information about a migration. Double-click a migration to see more detailed information, including log reports, approval statuses, and the migration status of individual objects.


Column	Description
Migr ID	The number that identifies the migration.
Status	The current status of the migration. Options include: Scheduled PS Waiting for Lock (PeopleSoft only) PS Lock Removed (PeopleSoft only) Canceled OA Generation Error (Oracle Apps only) Submitted Completed In Process PS Pending (PeopleSoft only) PS in Process (PeopleSoft only) Complete with Warning Complete with Error Waiting for Pre-Step Waiting for Post-Step Planned
Auto	(PeopleSoft) Indicates if the archive set was auto-migrated.
Schedule Date	If the migration was scheduled, the scheduled date and time
Start Date	Date and time the Stat Central Agent began migrating the archive set.
End Date	Date and time the Stat Central Agent completed migrating the archive set.
Duration	How long it took to complete the migration in hours, minutes, and seconds
Description	The description of the migration, either the Stat-assigned default description or the description the user assigned.
Archive ID	CSR archive set number.
Target Environment	The environment the archive set was migrated to.
Release	The release label assigned to the archive sets.
Module	The change management module in which the migration took place. Options include PeopleSoft, Generic Applications, and Oracle Applications.
Migration Type	Indicates how the migration was initiated. Options include: CSR Migration (drag and drop), Rapid Recovery, Release Recovery, Mass Migration, Point-to-Point, Archive Sync, and Object Sync.
Stage Environment	(PeopleSoft) the environment in which the PeopleSoft objects in the archive set were staged.
Staged	(PeopleSoft) Indicates if the PeopleSoft objects in the archive set were copied to the Staging database.
PS Project	(PeopleSoft) The PeopleSoft project that the archive set is associated with. This field is blank if the archive set did not include any PeopleSoft proprietary objects or if only the file objects of the archive set were migrated.
Canceled By	If the migration was canceled, the user who canceled it.
Submit Date	The date and time the migration job was submitted to the Stat Central Agent.
Migrator	The user who ran the migration.

Migration Details Window

The Migration Details window shows additional information about a migration, including the migration status of the individual objects, approval statuses, pre and post migration steps, and logs. To open the Migration Details window, do one of the following:

•

In the Migration Console, select a migration and click the Migration Details button or double-click a migration row.

•

In the Migration History Wizard, select a migration and click Details.

•

Double-click an environment, either in the Migration Path tab or in the CSR window.


	NOTE: When you open the Migration Details window by double-clicking an environment, the window shows information regarding all the migrations that have targeted that environment.

The top portion of the Migration Details window displays much of the same general information as the main console window, but with additional information, such as:

•

Submit Date— The date and time the user ran the migration

•

Schedule Date — In the case of scheduled migrations, the date and time the migration was scheduled

•

Maintenance — For migrations to Oracle Apps environments, indicates whether Maintenance Mode was enabled or not.

•

Migration Exit Option — Indicates whether Stat is configured to stop the migration if any errors are encountered

•

Edition — For migrations to Oracle Apps R12.2 environments or higher, indicates the file system to which file objects were migrated. Options include Run, Patch, or Both.

The bottom portion of the Migration Details window displays the migration status of each object contained in the archive set, migration approval statuses, pre and post migration steps, and migration logs.


	NOTE: In the case of migrations to distributed environments, the Objects tab displays the migration status of each object to each environment.

In the Migration Details window:

•

If you are a user with appropriate user rights, you can change the status of a migration that has not yet been processed from Submitted to Completed or Canceled and from Planned to Submitted or Canceled. If you change the status to Completed, however, the migration is assigned the status Completed with Errors since the Stat Central Agent had not yet migrated all the objects.

•

You can use the Pre and Post Migration Steps tab to run steps, view logs, or update migration step status.

•

To view migration approval statuses, select the Approvals tab, which shows who approved the migration and when.

•

(PeopleSoft) To view the audit flags and other PeopleSoft project settings, click the Audit Flags button. This opens the Upgrade Options window in read-only format which shows whether these properties were set to be copied into the target environment during the migration or whether the settings as defined in the target environment were retained.

•

Use the refresh button to update the status of migrations.

•

The Log tab displays a list all the Stat-generated migration logs, including (for PeopleSoft) the PeopleSoft project copy log. Double-click a log to open it.

Patch Application History

(Oracle Applications only) If patches have been applied to the selected environment, the Migration Details window features an additional Patch Application History tab, which is divided into two sections. The top section displays information concerning each patch that has been applied to the selected environment. When you select a patch, the bottom section of the window shows information about each object included in the patch file. From here you can also access information about patch application approvals and the driver files contained in the patch.

In the Patch Application History tab, all the patches applied to the selected environment appear in descending order with the most recently applied patch set appearing first.

The Patch Application History tab displays the following information:


Column	Description
Patch Name	The ID number that Oracle Support assigns the patch for tracking purposes.
Apply ID	A unique ID number assigned to each patch application request.
Process Order	If the patch was included in a multiple patch application request, the order in which it was scheduled to be applied. The default order number is 1.
Process Status	Shows if AutoPatch encountered an error when processing a patch. Possible statuses include Completed, Completed with Warnings, and Completed with Errors (Pending requests have a status of Pending/New, Sent to Agent, Received by Agent, or In Process. The status Not Processed means AutoPatch failed the process event before processing the driver).
Date Applied	The time and date the patch was applied to the selected environment.
Applied By	The user who applied the patch.
Process Type	The type of patch application request. options include Apply Patch, Roll Back, and Patch Impact.

Impacted Objects Tab

When you select a patch application in the top portion of the Patch Application History tab, the Impacted Objects tab lists all the objects (if any) that were modified during a patch application request. The information includes the class, type, name, navigation path, its pre- and post-patch version number, and application name.

If applicable, you can view the navigation paths that access an object (for example, the responsibilities and menus that access a form) by selecting the object and clicking Navigational Path. Stat displays the navigation paths in the View Navigation Path window. Only active navigation paths associated with one or more active users are included.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Stat 6.3 - User Guide

Main Console Window

Migration Details Window

Patch Application History

Impacted Objects Tab