Chat now with support
Chat with Support

Stat 6.0 - 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

Archive Set Types

You use archive sets to recover objects to environments and migrate completed changes. There are three types of archive sets: Base, Interim, and Final. There is also a fourth type called Merged, which is the result of using the Object Merge Wizard to combine the definition of two versions of the same data object.

You can use any archive set type to restore or migrate objects. Each archive set contains objects that are locked on one CSR, while the CSR itself may contain one or more archive sets, including the base, the final, and all the interim archive sets.

When you create an interim or final archive set, you tell Stat what environment the archives of the objects should come from. For data objects, the archives come from the selected Oracle Applications environment. For file objects, the archives come from either the source file locations defined for the selected environment or from the working directory of the assigned developer.

System administrators define source file locations for each file type and working directories for each developer. Working directories are where users make their changes. When creating an archive set, you can take the file archives either from the environment’s source file locations or from the developer’s working directory.

The base archive set is the most important because it contains the “pre-change” version of all the objects in the CSR. Stat automatically creates the base archive set when you save your CSR after locking objects. The base archive set is created from the Base environment in your migration path. Your system administrator defines which environment is the Base environment for each migration path. Your system administrator also defines each file type's source file locations for the Base environment. It is from these locations that Stat takes the “pre-change” version of the file objects locked in the CSR.

A CSR can contain only one base archive set, which contains all the locked objects. The base archive set is dynamic, meaning that Stat automatically adds to it objects that are locked in the Base environment after the set is initially created. The base archive set continues to grow as Stat issues more locks on objects in the CSR.

You should never delete base archive sets from the system, since they contain objects in their original, “pre-change” state. The moment you request a lock on objects, Stat places a holder in the system for the base set. Before you save the CSR, the status of the base set is In Process. If you do not save the CSR, the objects are not locked and the base archive is not created.

As you make changes to objects, you can save the modified objects in interim archive sets. Interim archive sets contain objects that are currently being modified and can be taken from any environment on your migration path, although by default the source environment is Development. If the archive set contains file objects, the archive of the file objects is taken either from the first source location defined for the specified environment or the developer’s working directory.

You can create an unlimited number of interim archive sets. An interim archive set is also dynamic. Stat can add objects to it after it is created. However, you cannot add or delete objects from an interim archive set once it has been migrated. This is to keep referential integrity intact. If you need to archive an object that is not in one of your interim archive sets, just create a new interim archive set for that object.

An interim archive set can contain some or all the objects associated with a CSR. You create interim sets to save objects after significant changes have been made throughout the development process.

Once your changes are completed and approved, you should create a final archive set. The final archive set is static, and although it is not mandatory that you create one, it is strongly recommended. A CSR can contain only one final archive set, and objects cannot be added to it once it is created. When the final archive set is created, Stat automatically adds to it all objects locked on the CSR.

You can create a final archive set from any environment on the migration path of the CSR. As with interim archive sets, if the final archive set contains file objects, the archive of the file objects is taken either from source locations defined for the particular file types or the developers’ working directories.

Merged archive sets are automatically created by Stat when you use the Object Compare Wizard to combine the definition of two versions of the same data object. Merged archive sets are automatically added to the CSR from which the original versions of the object were selected. A CSR can contain an unlimited number of merged archive sets. For more information on the Object Merge Wizard, see Object Tools and Wizards .

Archive Sets Table

The Archive Sets table shows the archive sets that have been created for a particular CSR. You can create and migrate archive sets whenever this table is displayed. To open the archive sets table, click Archive Sets on the Object Management tab of the Change Management/Version Control window. The table appears in the right section of the tab page.

The Archive Sets button becomes activated whenever you select the CSR node, the All Objects node, or the Migration Path node in the tree view on the left side of the tab page. If you select any object or developer node in the tree structure while the Archive Set table is displayed, the view switches to the Environment Info table and the Archive Sets button becomes dithered. This is because archive set information is not specific to these nodes and cannot be filtered.

To view archive set information by environment, select any of the environment nodes under the Migration Path node. This filters the archive set table to show information about only the archive sets created from that environment.

To sort rows of information in the Archive Set table, click on the column headings.

The archive set table displays the following information:

This is the archive set ID, which Stat automatically generates. Archive sets appear in the order you create them.

This is the source environment from which you copied the objects in the archive set. It must be an environment in the migration path defined for the CSR. A “-w” appears at the end of the environment name if the archive set was taken from the Development environment and it contains files that were taken from the users' working directories rather than the source file locations of the development environment. If it was taken from a VCM repository, a “-v” appears on the end of the environment name.

This is the type of archive set. Options include Base, Interim, and Final.

This is the description you entered when you created the archive set. Descriptions help distinguish between different interim archive sets. Base archive sets always contain the description: “Stat Baseline Set.”

This indicates how many objects the archive set contains. For a base or final archive set, this number is the total number of objects locked on the CSR. An interim archive set may contain less than that number.

This indicates the current status of the archive set. Possible statuses include:

In Process – Indicates that the Stat Central Agent is currently archiving the objects. When you add objects to a CSR, the archive set is in this initial status until all objects are archived. When the Stat is finished archiving, the status changes to Complete.
Complete – Indicates that all objects are archived
Complete/With Errors – Indicates that the archive set is created but errors were detected during the archiving process. For Oracle Applications, this could mean that one of the environments is not clean, or it could mean that Stat could not find the file objects you wanted to archive, or that the file location information was not set up correctly. Some errors are so severe that the archive set is unusable. Refer to the Logs window for further information.
Complete/With Warnings – Indicates that the archive set is created but warnings were issued during the archiving process. You can still migrate an archive set in this status. Refer to the Logs window and investigate further.
Delete Pending – Indicates that the archive set is set for deletion. It remains in this status until Stat completes its tasks.
Deleted – Indicates that Stat deleted the archive set

If selected, this indicates one or both of the following:

For more information, see Migration Approvals and Mass Migrations (Oracle Applications) .

This indicates the status of any archive set that you marked as Ready to Migrate. Before you select the target environment(s) for the archive set, the status is N/A. After you select the target environment(s), the status is In Process. Once the archive set has been migrated to all the selected environment(s), the Ready to Migrate check box is unchecked and the status reverts to N/A.

This is the date that the archive set was created.

The archive sets table features the following short cut buttons:

New – Opens the Archive Set window in which you can define new archive sets
Edit – Opens the Archive Set window in which you can edit the selected archive set
Delete – Deletes the selected archive set
Refresh – Refreshes the window with the most up-to-date information from the Stat Repository. You can also press <F5> to refresh.
Print – Prints the contents of the Archive Set table
Migration Target – Opens the Target Environments window for the source environment of the selected archive set. This button is activated when the Ready to Migrate check box is selected for the archive set.

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.

2
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.
3
In the Environment field select the environment containing the objects you want to include in the archive set.
4
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.
11

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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating