ERS9.1: Incremental Sync Messages like WORKFORCE_SYNC And PERSON_BASIC_SYNC Fails With Cannot Insert NULL Error (Doc ID 1907277.1)

Last updated on JULY 02, 2017

Applies to:

PeopleSoft Enterprise FIN Resource Management - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

 Incremental Sync messages like WORKFORCE_SYNC and PERSON_BASIC_SYNC fails with Cannot Insert NULL Error.

Steps:
-----------
1) Enable WORKFORCE_SYNC between HCM and FSCM.
2) In FSCM, COMP_RATE_POINTS is 'not included' in record PS_COMPENSATION for WORKFORCE_SYNC message.
3) In HCM, following row is there but same row is not available in FSCM:
EMPLID ='12345'
EMPL_RCD =0
EFFDT ='19-SEP-11'
EFFSEQ =0
COMP_EFFSEQ=0
COMP_RATECD=’CAR’;
4) Change the above row in HCM to
EMPLID ='12345'
EMPL_RCD =0
EFFDT ='19-NOV-13'
EFFSEQ =0
COMP_EFFSEQ=0
COMP_RATECD='BIKE';


Error Message:
----------------------
WORKFORCE_SYNC fails with following error message in FSCM:

A fatal PeopleCode SQL error occurred. Please consult your system log for details.        
Fatal SQL error occurred. (2,125) FUNCLIB_EOEIP.SUBSCRIBE_MSG_PC.FieldFormula
Name:Audit_Actn_Update_Keys  PCPC:9227  Statement:169 Called
from:FUNCLIB_EOEIP.SUBSCRIBE_MSG_PC.FieldFormula  Name:Process_Row_Action
Statement:252 Called from:FUNCLIB_EOE
Attempt to call abstract method/property OnError of object class
PS_PT:Integration:INotificationHandler. (180,845)  

Error in app server log:
--------------------------------
Return:  1400 - ORA-01400: cannot insert NULL into
("EMDBO"."PS_COMPENSATION"."COMP_RATE_POINTS")  
Statement:  INSERT INTO PS_COMPENSATION
(EMPLID,EMPL_RCD,EFFDT,EFFSEQ,COMP_EFFSEQ,COMP_RATECD,CURRENCY_CD,MANUAL_SW,CO
NVERT_COMPRT,RATE_CODE_GROUP,CHANGE_AMT,CHANGE_PCT,CHANGE_PTS,FTE_INDICATOR,CM
P_SRC_IND) VALUES(:1,:2,TO_DATE(:3,'YYYY-MM-DD'),:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)
Original Statement:  %Insert(:1)

Please see replication steps document for more details.

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