My Oracle Support Banner

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 APRIL 15, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.1 and later
Information in this document applies to any platform.


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


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.