Transaction Stages constraint in CRC Staging Job - NewVal & NewRow (Doc ID 2088153.1)

Last updated on DECEMBER 11, 2015

Applies to:

PeopleSoft Enterprise EPM Campus Solutions Warehouse - Version 9.1 and later
Information in this document applies to any platform.

Goal

On: PeopleSoft Enterprise EPM Campus Solutions Warehouse 9.1; DataStage ETL Jobs

Transaction Stages constraint in CRC Staging Job.

The ‘Trans_Check_CRC’ stage has the ‘NewVal’ constraint which is used for the ‘Trans_Load’ and ‘UpdateHash’ links. The code determines if the value of NewVal <> ‘N’. Where does the value ‘N’ came from?

The ‘Trans_Check_CRC’ stage has the ‘NewRow’ constraint which is used in the ‘Trans_Split_Insert_Update’ stage where the ‘NewRow’ should have values of ‘I’ or ‘M’. The NewRow is defined in the ‘SOURCE_ROW_SPLITTER' stage. Where is the source to populate this value?

Solution

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