Approving A Modified PO Is Throwing An 'Error ORA-01001 : Invalid Cursor Returned By Program Unit ORDER_STATUS_SQL.INSERT_ORDER_REVISION' (Doc ID 2719859.1)

Last updated on OCTOBER 20, 2020

Applies to:

Symptoms

Import Purchse Order(PO) created in Retail merchandising System(RMS), once put to worksheet status, modify  any value, cannot revert back to approved status.

While trying to do that, below error is encountered:

Error:

 Error ORA-01001 : Invalid cursor returned by the program unit ORDER_STATUS_SQL.INSERT_ORDER_REVISION

Steps To Recreate:
1. Create an Import PO.
2. Approve it.
3. Go to Manage Order and open the PO as Edit.
4. Put it on Worksheet status.
5. Change any data.
6. Approve it.

Changes

Cause

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