My Oracle Support Banner

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 later
Information 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


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