My Oracle Support Banner

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.

Symptoms

When performing and update operation (ModifyDetail) via Xorder API and it throws the ORA-01001 error.


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

Changes

 

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