Copying The Requisition With Attachment Gives SQL Fatal Error "SQL error in Exec. (2,280) PV_REQ_WRK.PV_SAVE_REQ.SavePostChange PCPC:1103 Statement:37"
Last updated on JULY 25, 2017
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.
A fatal PeopleCode SQL error occurred. Please consult your system log for details.
SQL error in Exec. (2,280) PV_REQ_WRK.PV_SAVE_REQ.SavePostChange PCPC:1103 Statement:37
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 a Requisition with two lines on line 1 there is comment and attachment and on line 2 there is only comment.
2.Now delete the row from PS_REQ_COMMENTS table for the line number 1 from the backend(The issue is caused due to bad data, we are recreating this bad data)
3.Now create a new Req with comments and attachment on line 2 and there are no comments and attachments on line 1
4.Save ans Submit the requisition and then edit the requisition, delete the line 1 and again save the requisition.
5.Now in manage requisition copy the requisition and and try to Save and Submit, receive the Error message.
Note:-The issue is happening due to bad/orphan data in PV_REQ_ATTCH.As there is no mapping of these rows to REQ_COMMENTS, these orphan rows can be removed from PV_REQ_ATTCH.Further the SQL(PV_ATTACH_UPDATE) is being fixed to ensure that update happens only for the current requisition and not for orphan data
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms