Chat now with support
Chat with Support

Quest has tools and processes in place to identify, protect, detect, and remediate vulnerabilities and incidents when they occur, including external security partners. As part of our standard security operations, Quest does not use CrowdStrike in any of our operations. We are reviewing our third parties, and so far, there is minimal affect. It is Quest's policy not to provide further technical details unless they directly impact customer data.

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

Viewing and Merging Object Definitions

After the selecting the objects you want to compare, how you view the results of the comparison depends on the classification of the selected objects. See the following sections for information on viewing the comparison results of different object classes:

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.

You can also use the Object Compare Wizard to compare the PeopleCode 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 .

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating