Getting Error When Canceling Amount Only Purchase Order(PO) Line: SQL error in Exec. (2,280) FUNCLIB_PM_SQL.QTY_PO_RECEIVED.FieldFormula Name:get_recv_line_amt
Last updated on DECEMBER 05, 2016
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.
When cancel PO line amount only the following error occurs.
"A fatal PeopleCode SQL error occurred. Please consult your system log for details.
SQL error in Exec. (2,280) FUNCLIB_PM_SQL.QTY_PO_RECEIVED.FieldFormula Name:get_recv_line_amt PCPC:3887 Statement:35
Called from:PO_PNLS_WRK.CANCEL_LINE_PB.FieldChange Name:check_recv Statement:71
Called from:PO_PNLS_WRK.CANCEL_LINE_PB.FieldChange Name:cancel_line Statement:278
Called from:PO_PNLS_WRK.GOTO_LINE_DTLS.FieldChange Name:line_changes Statement:144
Called from:PO_PNLS_WRK.GOTO_LINE_DTLS.FieldChange Name:goto_line_details Statement:274
Called from:PO_PNLS_WRK.GOTO_LINE_DTLS.FieldChange Statement:303
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:
The issue can be reproduced at will with the following steps:
1 – Create a requisition with multiple lines
2 – Create PO from requisition (copy from requisition)
3 - Check PO amount only for all lines.
4 – Dispatch PO
5 – Cancel line 2 and getting the error.
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