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