My Oracle Support Banner

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 later
Information 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

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