Process Order API ISG Web Service Error OE_INBOUND_INT.PROCESS_ORDER API (Doc ID 2022217.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transaction Entry

Using Maintain Sales Order (Internal Name:PROCESS_ORDER) SOAP for importing sales order.

The web service is invoked successfully and creating Sales Order in OM when header_id is passed in the SOAP body. Without header_id, the web service is returning error and not creating the sales order.
For workaround tested the same with PROCESS_HEADER SOAP also, but again header_id needs to be passed in the SOAP. Without header_id, it is returning error and sales order not created.

Run the same api (OE_ORDER_PUB) by running directly with same parameters from toad/plsql tool, it is creating the Sales Order successfully without passing any header_id.

 

 

ERROR
-----------------------
<X_MSG_DATA>FND FND_AS_UNEXPECTED_ERROR N PKG_NAME OE_Delayed_Requests_PVT N PROCEDURE_NAME LOGREQUEST N ERROR_TEXT ORA-6502: PL/SQL: numeric or value error: NULL index table key value </X_MSG_DATA>

 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use Maintain Sales Order (Internal Name:PROCESS_ORDER) SOAP for importing sales order >
2. Seeded ISG Sales Order Header creation webservice callls oe_order_pub.process_header api works with plsql developer
3. Tested the web service with same input parameters and receive error:
FND FND_AS_UNEXPECTED_ERROR N PKG_NAME OE_Delayed_Requests_PVT N PROCEDURE_NAME LOGREQUEST N ERROR_TEXT ORA-6502: PL/SQL: numeric or value error: NULL index table key value

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms