MSC Create and Reschedule Internal Sales Orders (ISO) and Order Import End in Error

Last updated on JULY 07, 2017

Applies to:

Symptoms

On : 12.1.3 version


The MSC Create and Reschedule Internal Sales Orders (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 Internal Sales Orders (ISO).

OR

1. Test standard Create Internal Sales Orders program in Purchasing. 

2. Order Management Order Import ends in Error.

Changes

 New Internal Customer Created.

Cause