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

Last updated on JULY 07, 2017

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


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

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