HVOP Is Not Importing Orders Due To Unexpected Error
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
On : 12.1.1 version, Transaction Entry
When attempting to run the High Volume Order Processing (HVOP)
the following error occurs.
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
Batch id: 19479 Status : Unexpected Error (all orders failed to import)
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.
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