DRP - Create And Reschedule ISO Failed When Across Multiple OU's (Doc ID 943244.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0.4 and later
Information in this document applies to any platform.
MSCRLISO module: MSC Create and Reschedule ISO
***Checked for relevance on 08- APR-2015***

Symptoms

On 12.0.4/12.0.6
When attempting to create Internal sales order, request MSC CREATE AND RESCHEDULE ISO is failing with following error

ERROR
Error :1 Validation failed for the field - Order Type

STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility : Distribution Planning
2. Navigation : DRP Planner Workbench, release a planned order or reschedule recommendation for Internal Req/ISO pair from DRP Plan.
3. It fails with error when the releases happen for lines for orgs that reside in different Operating Units (OU)

Example:
Plan is defined in ORGA which is part of OU1
Plan also includes ORGB which is part of OU2
When releasing planned shipment orders for ORGB, errors will occur.

BUSINESS IMPACT
The issue has the following business impact:
ISO cannot be created

MSCRLISO module: MSC Create and Reschedule ISO
+---------------------------------------------------------------------------+

Current system time is 02-SEP-2009 09:54:54

+---------------------------------------------------------------------------+

**Starts**02-SEP-2009 09:54:54
**Ends**02-SEP-2009 09:54:57
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Profile Option: MSC_DRP_PASS_LIST_PRICE_OM : Y
Successful in Creating requisition.
Requisition Header ID    :133485
Internal Requisition Number : 960000011
Requisition Line Num       : 1
Requisition Line ID      : 162162
Item ID                    : 111605
Quantity                    : 45
Deliver To loc ID        :66212
Source organization id => 2318
Customer ID              : 3784
Error :1  Validation failed for the field - Order Type
Error in loading sales order.
Error in CREATE_AND_SCHEDULE_ISO : e_creating_iso_err

OM Debug log file was created by setting profile OM: Debug Level = 5 in the EBS source applications for the User who was performing the release from the DRP Planner workbench.

AND OM debug file shows 

Validation of desc flex is set to Y in OE_Validate_Header.attributes  
Before calling header_desc_flex 
source doc type:10 
Enter Is Flex Enabled 
Enter Load Flex Enabled Flag  
After header_desc_flex  E 
Before G_header_desc_flex 
Enter Is Flex Enabled 
Enter Load Flex Enabled Flag  
After G_header_desc_flex E 
Enter Is Flex Enabled 
Enter Load Flex Enabled Flag  
Exiting OE_VALIDATE_HEADER.ATTRIBUTES 
ENTER SET RECURSION MODE 
ENTITY CODE-2 
ENTRY-EXIT MODE -0 
RECURSION MODE AT ENTRY -N 
RECURSION MODE WITHOUT EXP AT ENTRY -N 
RECURSION MODE AT EXIT -N 
RECURSION MODE WITHOUT EXP AT EXIT -N 
DELETE REQUEST1 
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt 
ENTERING DELETE_ATTRIBUTE_CHANGES -1 
PO: EXITING PROCESS ORDER WITH ERROR 
ENTER SET RECURSION MODE 
ENTITY CODE-1 
ENTRY-EXIT MODE -0 

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