ERROR Calling OE_INBOUNT_INT.PROCESS_ORDER ORA-06502: PL/SQL: Numeric Or Value Errorr (Doc ID 1959181.1)

Last updated on JULY 07, 2017

Applies to:

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

Symptoms

On : 12.2.3 version, Transaction Entry

When calling OE_INBOUND_INT.PROCESS_ORDER using the input P_HEADER_SCREDIT_TBL. to create orders adding one sales rep, following error occurs:

Calling the procedure without this record type, the orders get created with no error.,also calling OE_ORDER_PUB.PROCESS_ORDER with the exact same data, it works fine.


ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: NULL index table key value in Package OE_Delayed_Requests_PVT Procedure LOGREQUEST


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Calling OE_INBOUND_INT.PROCESS_ORDER using the input P_HEADER_SCREDIT_TBL




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