Resolve Discrepancies SCC_DISCREP3 Failing Since CS Bundle #39 Applied (Doc ID 2077382.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

On : CS 9 version, Campus Community Integrations & Interfaces

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. setup the IIU 
2. Apply bundle 39
3. Run the SCC_DISCREP3 for the DIVERS_ETHNIC record and get error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the IIU after applying bundle 39.

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