My Oracle Support Banner

HCM: Delivered Message PERSON_BASIC_SYNC From CS to HCM Fails, Receives in App Server Log file Error Messsage: 1400 - ORA-01400: cannot insert NULL into ("HCMXX"."PS_NAMES"."EFFDT") (Doc ID 2913325.1)

Last updated on JANUARY 26, 2024

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


PERSON_BASIC_SYNC message integrated from Campus Solutions to HCM environment, receives an error message.

The issue can be reproduced at will with the following steps:

  1.  Ensure Service Operation PERSON_BASIC_SYNC setup and integrated from Campus Solutions to HCM in both environments. 
  2.  Then, once student added in Campus Solutions, batch process triggers message PERSON_BASIC_SYNC.
  3.  In HCM environment, PERSON_BASIC_SYNC message is received, but generates an error.




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.