Resolve Discrepancies SCC_DISCREP3 Failing Since CS Bundle #39 Applied

(Doc ID 2077382.1)

Last updated on OCTOBER 24, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Resolve Discrepancies SCC_DISCREP3 Failing Since CS Bundle #39 Applied

After applying CS Bundle 39, the SCC_DISCREP3 process, the Integration Integrity Utility Resolve Discrepancies has been failing. It is not failing in any of the non-production databases that are not yet patched.

ERROR
-----------------------
Invalid row number 1 for class Rowset method GetRow. (2,263) HCI_INTEGRATION.Hci_Record.OnExecute Name:iProcessRequest PCPC:4867

or

No transformation found in the OS transformation schema for 0000, message HCI_RECORD_REQ_MSG. (18137,202) (94,1)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set up the IIU 
2. Apply bundle 39
3. Run the SCC_DISCREP3 for the DIVERS_ETHNIC record and get error

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms