My Oracle Support Banner

Creating Orders With Pack Item Throws Invalid Cursor Error Via XOrder API (Doc ID 2610934.1)

Last updated on JUNE 12, 2021

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.


Following error is encountered when creating a Purchase order (PO) via XOrder RIB API:

Error: javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_XORDER.CONSUME(?,?,?,?)}: [E] Error ORA-01001: invalid cursor returned by program unit ORDER_STATUS_SQL.CHECK_SUBMIT_APPROVE.

1. Create a pack item with components.
2. Create a purchase order with the pack no through UI and notice it asks to explode the pack.
3. Create an order through XOrder API with the same pack item and notice the invalid cursor ORA error.


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.