PO Reset Script (poxrespo.sql) Fails With 'This PO Has At Least One Distribution With Wrong Encumbrance Amount'
(Doc ID 2932121.1)
Last updated on JULY 27, 2023
Applies to:
Oracle Purchasing - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.9 version, Approvals/Accounting
Encumbrance error 'This PO has at least one distribution with wrong Encumbrance amount' when attempting to reset some PO documents with the reset scripts provided in <Note 390023.1> How To Reset a Stuck Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases
The following error message appear running the reset script:
SQL> @poxrespo.sql
Please enter the PO number to reset : 12345
Please enter the organization id to which the PO belongs (Default NULL) : 555
Do you want to delete the action history since the last approval ? (Y/N) N
Updating amount changed flag on distribution# nnn
Processing STANDARD PO Number: 12345
......................................
An Open notification exists for this document, you may want to use the
notification to process this document. Do not commit if you wish to use the notification
This PO has at least one distribution with wrong Encumbrance amount.
Hence this PO can not be reset.
PL/SQL procedure successfully completed.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |