My Oracle Support Banner

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

Last updated on MARCH 27, 2019

Applies to:

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


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.