My Oracle Support Banner

FAQ: Using the Integration Integrity Utility to Monitor and Maintain Data Relating to CS/HCM Split (Doc ID 1602272.1)

Last updated on JULY 10, 2020

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.


The purpose of this document is to provide frequently asked questions relating to use of the Integration Integrity Utility (IIU) for detecting, reporting and re-synchronizing data.

The CS-HCM Integration Integrity Utility Guide was released as part of the April 2013 Additional Features release.  It has been incorporated into PeopleBooks and most recently updated as part of the July 2013 Additional Features release.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 Question 1:  Can the utility be run on the HCM side?
 Question 2:  Are there any thoughts to extend IIU to other modules/pillars?
 Question 3:  Is it possible to use this tool in bulk for multiple instances at the same time?
 Question 4:  Can this tool compare longs (long varchar field types)?
 Question 5:  How do you specify the primary key fields in the record mapping?
 Question 6:  Is it possible to set and enforce referential integrity?
 Question 7:  What happens if two people are doing the same compare and update? For example, does that last person win? Is there a warning that the data has changed since the last compare?
 Question 8:  How is it possible to specify parent/child relationships for different related records?
 Question 9:  How can data be analyzed that needs to be transformed when going from one system to another?
 Question 10:  Since the utility is in CS, how does the utility handle data on the HCM side where CS is the source? Does setting the "winner" as local in CS cause the data to be updated in HCM?
 Question 11:  Can the compare process be run multiple times at the same time?  For example, to save run time run it once looking at NAMES and at the same time run it against ADDRESSES.
 Question 12:  Which organizational areas typically run the discrepancy reports, and can they be automated?
 Question 13:  In the case of a one field difference, how do we decide which side - HR or CS - was the last who updated the field?
 Question 14:  On the discrepancy comparison, can you run for multiple records at once, or do you always have to go through for individual records? Is there any difference in the answer or functionality depending on parent/child relationships?
 Question 15:  Once you create multiple run controls, can they be associated together in a single job?
 Question 16:  What is the minimum Tools requirement?
 Question 17:  Can it handle just one field being different between the records? The record exists in both databases with one field being different.
 Question 18:  How is it handled when the record structure is different between the databases - a field exists in HCM and not CS.
 Question 19:  If you mistakenly choose local instead of foreign and accidentally wipe out data, is there any mechanism for recovery, or would it require rekeying the data manually?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.