Last updated on FEBRUARY 03, 2016
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
While closing Purchase Orders (POs) for which cancelled receipts exists, using the PO Reconciliation Workbench. The following SQL error is received.
Process 0 ABENDED at Step PO_PORECON.PX10001.Step02sq (SQL) -- RC = 805 (108,524)
CallAppEngine: Application PO_PORECON: AppEngine error. (2,653) PO_RC_WB_WRK.CLOSED_FLG.SavePostChange PCPC:1143 Statement:23
Steps to reproduce the issue:
1) Create a Purchase Order with ‘Distribution Method’ set as ‘By Quantity’ and Receiving is required. Also, Select an item category which has ‘Close Under Quantity Percent Tolerance’ greater than 0.
2) Create a Receipt for the PO.
3) Cancel the Receipt.
4) Modify the Purchase Order, select the ‘Amount Only’ flag , and then Approve and budget check the PO and dispatch it.
5) Create a new Receipt.
6) Close the PO through PO Reconciliation Workbench.
7) SQL error is received.
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