My Oracle Support Banner

SCC_PERSON Batch Publish From CS To HCM Creating Discrepancies Between CS And HCM (Doc ID 2002516.1)

Last updated on APRIL 22, 2019

Applies to:

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


Need to resolve the following test case:

When running the ISIR Load process (FAPSAR00) the File Parser process (SCC_SL_SMP) to load application data and the test score load process (SAD_TEST_PST) to create prospects -- all in the Campus Solutions (CS) instance

Have found that the new EMPLIDs created in the CS instance are created with a POI_TYPE of '00009' but are created in the Human Capital Management (HCM) instance with a POI_TYPE of '00000'.

In addition, the ISIR load process populates the PS_PERS_DATA_EFFDT.MAR_STATUS_DATE field with a NULL value in CS, but the PS_PERS_DATA_EFFDT row created in the HCM instance for the new person is populated with a date that is the same as the effdt for the row. As a result, our data is out of sync between CS and HCM.


So the valid content for Marital Status Date that comes in on the ISIR is this for the 2015-2016 Aid Year …


In that case the CCPMNTPD_I_PDTAEFD does not insert a value into the MAR_STATUS_DT field.




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

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