My Oracle Support Banner

MSC Create and Reschedule ISO and Order Import Ends in Error (Doc ID 2051298.1)

Last updated on JUNE 07, 2021

Applies to:

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

Symptoms

On : 12.1.3 version

"MSC Create and Reschedule ISO" program completes with warning.

MSC_RELEASE_ISO module log

Error :1 Item Validation Resulted in error(s).
Error in loading sales order.
Error in CREATE_AND_SCHEDULE_ISO : e_creating_iso_err
User-Defined Exception
Transaction rolled back


Another test shows that Order Import also ends in error after running Create Internal Sales Orders program.

Order Import log errors

Invalid Generic Item 

LEAVING OE_MSG_PUB.ADD

Item Orderability Validation Result : E

PROCESS_ORDER RETURN STATUS BEFORE ACTION : E
PROCESS ORDER FAILED. NO NEED TO CALL FOR ACTIONS

L_MSG_DATA=Item Validation Resulted in error(s).
Error in Procedure insert_message ORA-01403: no data found

Error in Procedure insert_message ORA-01403: no data found
Order number not found

 


Steps

The issue can be reproduced at will with the following steps:
1. Release planned order from Distribution Requirements Planning (DRP) workbench.
2. Error is received during run of MSC Create and Reschedule ISO

OR

1. Test standard Create Internal Sales Orders program in Purchasing. 
2. Order Management Order Import program ends in Error.

 

Changes

 New Internal Customer Created.

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