Chat now with support
Chat with Support

Stat 6.3 - User Guide

Introduction to Stat Connecting to Stat Change/Service Requests Stat Consoles Tasks and Time Entries Stat Projects Search Engines Reports and Graphs Personal Rules Object Tools and Wizards Change Management for PeopleSoft
Object Management (PeopleSoft) Object Archives (PeopleSoft) Object Migrations (PeopleSoft)
Change Management for Oracle Applications
Object Management (Oracle Applications) Patch Management Object Archives (Oracle Applications) Object Migrations (Oracle Applications)
Change Management for Generic Applications
Object Management (Generic Applications) Object Archives (Generic Applications) Object Migrations (Generic Applications)
Appendix: Troubleshooting Chart Appendix: Migration Options Appendix: User-Specific Parameters Appendix: Supported PeopleSoft Proprietary Objects Appendix: Stat Reports

Creating Archive Sets (Oracle Applications)

As you make your changes to objects, you should periodically make interim archive sets. This lets you save your work at that point in time. When all your changes are completed and approved, you should make a final archive set. The procedure for both is the same.

In the Type field select the type of archive set you want to create.
Options include Interim and Final. Base sets are automatically created by Stat.
In the Environment field select the environment containing the objects you want to include in the archive set.
In the Description field, enter a short description of the changes you made to the objects.
Select Environment if the source environment is Development and you want to take the file archives from the environment’s source file locations
Select Working if the source environment is Development and you want to take the file archives from the assigned user’s working directories. Or select No if you want to take the archives from the source file locations of Development.
Select VCM if you have associated the CSR with a version control management record and you want to take the file archives from the VCM repository. After selecting this option, a VCM-specific field is displayed (Revision for SVN and P4, Tag/Branch for CVS and Git, Label for PVCS, and Version for TFS). In this field you can specify the particular version of the objects you want to add from the VCM repository. Your system administrator may have configured a default value, but you can override it either by entering the version you want manually or by clicking the control button and selecting the version from the dropdown list. If left blank, Stat adds the most recent version of the objects in the repository.
Stat goes out to the source environment or file locations and looks for the object. If it finds the object it displays the value Yes in the corresponding Exists field. If the object does not exist, Stat displays the value No. Objects that do not exist in the source environment cannot be included in the archive set.

Archive Set Object Information

To see the details of your archive set, double-click on it in the Archive Set table. This re-opens the archive set window. The Details tab should look familiar since this is the tab you filled out when you created the archive set. The next tab, Objects, now contains all of the object information for the archive set.

The Objects tab displays the following information:

For schema objects, file objects, and setup objects only, indicates the order in which the object will be migrated relative to the other objects in the archive set. Objects assigned a lower number are migrated before objects assigned higher numbers.

Indicates the class of object. Object classes include data and file.

The object type.

The object name.

A version number internal to Stat. It indicates the number of times the object has been modified/archived in Stat for a given environment.

Reflects the current status of the object. Possible statuses include:

Archived – Indicates Stat finished archiving the object
Archive Pending – Indicates Stat is in the process of archiving the object
Wait Lock – Indicates Stat is waiting for Stat to issue the objects in this CSR a lock. You can archive only locked objects.
Delete Pending – Indicates Stat is in the process of deleting the objects
Re-archive Pending – Indicates Stat is in the process of archiving the object again

Indicates the number of errors found. See the Logs window for further details.

Indicates the number of warnings found. See Logs window for further details.

If the object is a data object, this field shows the number of tables and rows in Stat used to complete the archive. If it is a file object, the field shows the exact file location of the archive source in the archive set.

This information is displayed at the bottom of the window. It shows the total number of objects in the archive set and how many of these have been archived.

For any Oracle Apps file type that has been marked as a database script (including SQL Scripts and SPL/SQL, PKB, and PKH file object types as well as custom object types marked as database scripts), this drop-down list displays the list of products that are present in Stat for the source environment. If a value is selected in this column, the object is generated on the target environment using this schema. If the value is blank, the default APPS schema is used.

The Objects tab features the following short cut buttons:

Add – Adds selected objects to the archive set. Press this button and Stat displays a list of the objects.
Delete – Deletes all of the objects in the selected archive set. You cannot delete objects from a base or final archive set.
Re-Archive – Instructs Stat to re-archive the objects
Refresh – Refreshes the current display
Print – Prints the contents of the window
Export – Exports the contents of the window
Default Order – For schema objects, file objects, and setup objects only, restores the migration order of selected objects to the default order as defined in the Object Type Maintenance table
Reorder – For schema objects, file objects, and setup objects only, changes the migration order of selected objects starting with the numerical value specified in the field positioned above the button and in the order in which they are listed in the Objects tab. This provides a convenient way to change the migration order of multiple objects simultaneously. For example, assuming 5 as the starting value, the first selected object is assigned the value 5, the next selected object is assigned 6, and so on.
View – For file, schema, and setup object types only, displays the definition of the selected object in a separate window.
Download – Allows users to download the selected file or schema object from archive.

Copying Archive Sets

When you copy an archive set, the copy retains the migration order set on the source archive set.


Deleting Objects

Stat lets you delete unwanted objects from selected Oracle Applications environments along a migration path. After adding the unwanted objects to an archive set, you can mark them for deletion. When you migrate an archive set containing objects marked for deletion to an environment, Stat deletes them from that environment. However, you can always recover deleted objects since they remain archived in the Stat Repository.

In the Action field, change the setting to Delete.

If you decide that you do not want to delete an object marked for deletion before you migrate it, go back to the Migration Flags tab and in the Action field change the setting to Copy. Stat is now configured to migrate the object as it normally would by placing a copy of the object in the target environment rather than deleting it.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating