HVOP Is Not Importing Orders Due To Unexpected Error (Doc ID 1223624.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Order Management - Version 12.1.1 and later
Information in this document applies to any platform.
HVOP: High Volume Order Processing


Symptoms

On : 12.1.1 version, Transaction Entry

When attempting to run the High Volume Order Processing (HVOP)
the following error occurs.

ERROR
-----------------------
NO DATA FOUND IN LOAD ITEM
OTHERS ERROR , LINE.DEFAULT_RECORD
ORA-06503: PL/SQL: Function returned without value
ENTERING P_ENCODED AS FALSE
THE MESSAGE IS ORA-06503: PL/SQL: Function returned without value in Package OE_BULK_PROCESS_LINE Procedure Default_Record
UNEXP ERROR , LINE.ENTITY
UNEXP ERROR IN PROCESS_BATCH
ENTERING P_ENCODED AS TRUE
ENTER SAVE_MESSAGES
EXIT SAVE_MESSAGES
ENTER SAVE_MESSAGES
EXIT SAVE_MESSAGES
LEAVING OE_MSG_PUB.INITIALIZE
Batch id: 19479 Status : Unexpected Error (all orders failed to import)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load 89 orders and have HVOP thread set to 100.
2. Run HVOP
3. See that orders fail
NOTE: Few of the orders in no particular pattern fails. However, on reprocessing from the error correction screen the order gets created.

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