My Oracle Support Banner

OE_ORDER_PUB.Process_Order API Error: FND_AS_UNEXPECTED_ERROR PKG_NAME OE_Delayed_Requests_PVT PROCEDURE_NAME LOGREQUEST ERROR_TEXT ORA-06502: PL/SQL: numeric or value error: NULL index table key value (Doc ID 3043806.1)

Last updated on SEPTEMBER 05, 2024

Applies to:

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

Symptoms

 On : 12.2 version,  Order Management

When attempting to use OE_ORDER_PUB.Process_Order API to create/update orders
the following error occurs.

ERROR
-----------------------
FND_AS_UNEXPECTED_ERROR PKG_NAME OE_Delayed_Requests_PVT PROCEDURE_NAME LOGREQUEST ERROR_TEXT ORA-06502: PL/SQL: numeric or value error: NULL index table key value

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create a package to call OE_ORDER_PUB.Process_Order API
2. try to create /update an order
3. see the error

 

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