Chat now with support
Chat with Support

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

Comparing PeopleSoft Proprietary and Data Objects

You can view a detailed comparison of each data table that defines two PeopleSoft proprietary or data objects. For PeopleSoft proprietary objects, you can then use the Object Merge Wizard to combine the definitions into a new object, which can be added to an archive set and migrated to any environment you want to update. For more information, see the section, Merging PeopleSoft Proprietary Objects .

In the Object Compare Wizard, the definitions of the first and the second object you selected are displayed in the top and bottom sections of the window, respectively. The names of the data tables that comprise the two objects are displayed on the right. Select a table to view results of the comparison on a row by row basis. When you select a row in either the top or bottom section of the window, the wizard highlights its corresponding row in the other section of the window. If one object contains a row that does not exist in the definition of the second object (no row with same key values), when you select that row, no row is highlighted in the other object, which tells you that this row has no equivalent.

Both the names of the data tables, the rows that make up those tables, and the values contained in each row are color coded to indicate whether differences exist between the two objects. The following colors are used:


In the case of a table, indicates that the table is identical for both objects. In the case of a table row, indicates that the values contained in that row are identical for both objects.


In the case of a table, indicates that differences exist between the two objects in every row of the table. In the case of a table row, indicates that every value contained in that row is different between the two objects. The different values are themselves displayed in red.


In the case of a table, indicates that differences exist in only some of the table rows. In the case of a table row, indicates that only some of the values contained in that row are different between the two objects.


Indicates that the table is empty for both objects

You can filter the comparison results with the following toolbar buttons:

Show all tables and rows

Show only tables and rows with differences (coded red and pink)

Show only identical tables and rows (coded green)

Show only empty tables (coded gray)

If the data table you are comparing contains a Blob field that is textually formatted (as indicated by the value “BLOB” displayed in all caps), you can compare and merge the contents of the Blob field by clicking the Blob button. This opens the File Comparison tool, which displays both versions of the Blob field and identifies any differences that may exist. The File Comparison tool cannot compare blob information, however, if the source environment for one data table is Unicode and the other is non-Unicode; the source environments must be both either Unicode or non-Unicode. For more information, see Comparing File and Schema Objects .

When you compare two version of a PeopleSoft Image object, the wizard displays an Image button that you can use to compare the two versions visually. If differences are reported by the wizard, select a row and click Image. This opens the Compare Images window which shows both versions of the image object.

In addition to comparing object definitions, for PeopleCode objects version 8.x, you can also use the Object Compare Wizard to compare the scripts that those objects contain.

Comparing PeopleCode scripts is similar to comparing the text-based Blob field in other PeopleSoft objects. In both cases, the contents are compared textually in the File Comparison tool. When you compare PeopleCode scripts, however, Stat does the following:

Click Compare.

Merging PeopleSoft Proprietary Objects

If you are comparing two versions of the same PeopleSoft proprietary object, you can merge the two versions to create a new object that is automatically archived by Stat. You can also compare and merge PeopleSoft proprietary objects that contain blob data from UDB/DB2 databases with other UDB/DB2 databases or with the Stat archives.

Click Next.
(Optional) Modify the message displayed in the Comments field. Otherwise click Next.
Click Finish.

Comparing Objects in Oracle Applications

The Object Compare Wizard can show differences that exist between setup or developer object types for Oracle Applications. After you select the source locations and the two setup or developer objects you want to compare (or the two versions of the same object), click Next. The wizard processes the request and in the next window compares the properties of the two objects. The left side of the window displays in a merged tree view the structural classes and entities of the two objects. When you select an entity, the right side of the window shows any differences that may exist between the two objects.

The icons and flags displayed in the tree view indicate whether differences exist between the objects. Also, you can use the action buttons to control how information is displayed in the window. The table below describes the icons and action buttons featured in the window.

Entities are equal.

Entities are equal Different

Classes are equal

Classes are different

Properties are equal

Property does not exist in object 1

Property does not exist in object 2

Properties are different

Button: Show all the entities

Button: Show different entities only

Button: Expand all the items in the tree view

Button: Collapse the tree view to the second level

When you double-click on a property in the tree view, the wizard opens the Text Comparison window, which shows in detail any differences that may exist between the properties shared between the two objects. The Text Compare window functions and behaves the same way as the File Compare Window, except without any merge capabilities. For more information the File Compare window, see the section, Comparing File and Schema Objects .

Comparing File and Schema Objects

You can use the File Comparison Tool to compare the contents of file and schema objects and easily identify differences.

In the File Comparison window, the contents of the two file or schema objects are displayed side by side separated by a center divider. Differences between the two versions are highlighted with color. The colors may be customized by the user. Using the default color values, the following occurs:

The tool finds lines of text that correspond to each other and does not depend solely on the line number.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating