Application Messaging: Excluded fields in the message definition gives SQL error
(Doc ID 622228.1)
Last updated on JANUARY 03, 2023
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.2 and laterInformation in this document applies to any platform.
SPECIFIC TO: All Versions
This document was previously published as Customer Connection Solution 200765632
Symptoms
Excluded fields in the message definition gives SQL error
We have excluded fields in the message definition (unchecking the Include box next to the field) because we don't want some sensitive data from HCM to live in FSCM. We excluded on the FSCM side and have not excluded key fields. A key change was made to a row in HCM which triggered a WORKFORCE_SYNC message to FSCM which failed with this error:
SQL error. Function: Record.Insert Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_JOB"."POSITION_OVERRIDE"
Fatal SQL error occurred. (2,125) At FUNCLIB_EOEIP.SUBSCRIBE_MSG_PC.FieldFormula Audit_Actn_Update_Keys PCPC:8051 Statement:140
Cause
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
| Symptoms |
| Cause |
| Solution |