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" (Doc ID 2264191.1)

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.

Symptoms

Error:-

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

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