XOrder API - Purchase Order Management Web Service Throws ORA-01001 Error On Update Operation.
(Doc ID 2695349.1)
Last updated on MAY 17, 2022
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.
When performing and update operation (ModifyDetail) via Xorder API and it throws the ORA-01001 error.
Error ORA-01001: invalid cursor returned by program unit ORDER_STATUS_SQL.INSERT_ORDER_REVISION.
Steps to reproduce:
1. Create an import order with all the required Items and Location.
2. Approve the Order and save Close.
3. Update the Order quantity via Xorder API (modifyDetail) using SOAP UI.
4. Run the Purchase Order Management Service API and it throws the ORA-01001 exception.
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