Difference Query - Main

Use Admin Menu > Difference Query to view a summary of the differences between the maintenance objects in two environments.

Description of Page

Batch Control , Batch Number , and Batch Business Date is the batch run that compared the maintenance objects.

DB Process is the DB process that defines the maintenance objects that were compared.

Environment Reference is the name of the environment whose data was compared against the data in the current environment.

The grid contains a summary of the comparison results:

• Add. If a maintenance object exists in the source environment that is not in the current environment, the maintenance object is categorized as "add".
• Change. If a maintenance object exists in the source environment with the same prime key as data in the current environment but with different column values, the maintenance object is categorized as "change".
• Delete. If a maintenance objects exists in the current environment that is not in the source environment, the data is categorized as "delete".

The summary is further categorized based on the promotion status of the difference. Distinct summary lines are shown for each status value - All , Approved , Complete , Error , Initial , Pending , Rejected.

The area above the grid allows you to filter the items that appear in the grid:

• Use Action to restrict the summary information based on the comparison category (see above for a list of the categories).
• Use Status to restrict the summary information based on the status of the information. Refer to The Comparison Process Creates Root Objects for a description of each state.

Don't forget to click the search button after changing the filters.

The following points describe each column in the grid:

• Click the adjacent go to button to transfer to the Differences Query tab where the associated root objects can be viewed.
• The Maintenance Object column defines the type of maintenance object.
• The Description column describes the maintenance object.
• The Action column indicates if the maintenance objects are to be Added, Changed or Deleted (note, these actions are only performed if the execute the apply changes background process CL-APPCH).
• The Status column indicates the status of the maintenance objects.
• The Total Root Objects column displays the number of maintenance objects with this Action and Status for the Batch Control and Batch Number .

Click Approve All to set the status of all root objects associated with the Batch Control and Batch Number to Approved.

Click Reject All to set the status of all root objects associated with the Batch Control and Batch Number to Rejected.