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.
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