SQL Error When Trying To Save an Event: SQL error in Exec. (2,280) AUC_CREATE_COMP.GBL.AUC_HDR_CLB_GRP.SavePostChange PCPC:2431 Statement:14

(Doc ID 2340271.1)

Last updated on DECEMBER 17, 2017

Applies to:

PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:-When attempting to Save a Event, the following error occurs.

Error:-
"SQL error. Function: SQLExec Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("EMDBO"."PS_CS_DOC_COL_USER"."EMAILID") Statement: INSERT INTO PS_CS_DOC_COL_USER (CS_DOC_ID,CS_COLLAB_OPRID,CS_COLLABORATOR_SW,CS_CHECK_INOUT,CS_COLLAB_STATUS,COLLABED_DTTM,CS_SIGNER_FLG,CS_SIGN_VISIBLE, CS_SIGN_NBR,CS_SIGN_TITLE,CS_SIGN_STATUS, CS_SIGN_DTTM,CS_ALT_USER) VALUES(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13)
Original Statement: Insert Into PS_CS_DOC_COL_USER (CS_DOC_ID,CS_COLLAB_OPRID,CS_COLLABORATOR_SW,CS_CHECK_INOUT,CS_COLLAB_STATUS,COLLABED_DTTM,CS_SIGNER_FLG,CS_SIGN_VISIBLE, CS_SIGN_NBR,CS_SIGN_TITLE,CS_SIGN_STATUS, CS_SIGN_DTTM,CS_ALT_USER) VALUES(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13)"

"SQL error in Exec. (2,280) AUC_CREATE_COMP.GBL.AUC_HDR_CLB_GRP.SavePostChange PCPC:2431 Statement:14

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed."

Steps To Reproduce the Issue:-
1.Create an RFX event
2.Enter Description and click on the Event Collaborators link
3.Add a User ID and delegate ID and check the ‘Allow Rfx Document edit’ check box
4.Save the Event
5.Now Add a RFx document
6.Click Save
7.Save the Event again.Receive SQL Error

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