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

Last updated on APRIL 07, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.