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.

Symptoms

While closing Purchase Orders (POs) for which cancelled receipts exists, using the PO Reconciliation Workbench.  The following SQL error is received.

Error: 

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.



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