HVOP Is Unable to Import/Create the Sales Order When One Line Fails. (Doc ID 1348634.1)

Last updated on APRIL 16, 2017

Applies to:

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

Symptoms


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: 92839 Status : Unexpected Error (all orders failed to import)



STEPS

1. Load 89 orders and have HVOP thread set to 100.
2. Order management Responsibility -> Run HVOP
3. See that orders fail

 

NOTE: Few of the orders in no particular pattern fails. However, on reprocessing from the Order Import Corrections Window the order gets created/imported.

 

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