SQL Error - Process 0 ABENDED at Step PO_PORECON.PX10001.Step02sq when using the Purchase Order Reconciliation Workbench (Doc ID 1520718.1)

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms