L_MSG_DATA=User Order Import Fails With Defined Exception in Package OE_SCHEDULE_UTIL Procedure (Doc ID 2255048.1)

Last updated on MAY 01, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Finance & Accounting

Order import fails with scheduling error

When trying to import sales orders using standard order import program.
But around 1200+ orders are failing because of the following scheduling error.
-- If the same order is imported without shipset value then they get imported.


ERROR
The errors are in Order Import program which is an OM program.
Also the main errors in the program are clearly from
OM Package OE_GROUP_SCH_UTIL:

ENTER SAVE_MESSAGES
L_MSG_DATA=ATP Process resulted in no data
Error in Procedure insert_message ORA-01403: no data found
Order number not found
Order Number : Line Number :
Message :ATP Process resulted in no data
 
L_MSG_DATA=User-Defined Exception in Package OE_SCHEDULE_UTIL Procedure Load_Results_from_rec
Error in Procedure insert_message ORA-01403: no data found
Order number not found
Order Number : Line Number :
Message :User-Defined Exception in Package OE_SCHEDULE_UTIL Procedure Load_Results_from_rec
 
L_MSG_DATA=User-Defined Exception in Package OE_SCHEDULE_UTIL Procedure Load_Results_from_tbl
Error in Procedure insert_message ORA-01403: no data found
Order number not found
Order Number : Line Number :
Message :User-Defined Exception in Package OE_SCHEDULE_UTIL Procedure Load_Results_from_tbl
 
L_MSG_DATA=User-Defined Exception in Package OE_GROUP_SCH_UTIL Procedure Schedule_set_lines
Error in Procedure insert_message ORA-01403: no data found
Order number not found
Order Number : Line Number :
Message :User-Defined Exception in Package OE_GROUP_SCH_UTIL Procedure Schedule_set_lines
 

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