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

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.

Symptoms

When cancel PO line amount only the following error occurs.

ERROR

"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.


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