Performance Issue When Canceling a Purchase Order Using the Reconciliation Workbench (Doc ID 1241324.1)

Last updated on OCTOBER 01, 2014

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Performance issue with the Application Engine Step Action PO_POCANCEL.PE00EDIT.ED000027.SQL when canceling a Purchase Order using the Reconciliation Workbench (Purchasing, Purchase Orders, Reconcile POs, Reconciliation Workbench).

The same SQL statement errors with the below error if there are multiple rows returned by the subqueries as the SQL has not been written to handle multiple rows.

ORA-01427: single-row subquery returns more than one row

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