My Oracle Support Banner

Release of Shipments For DRP Plan Errors When Trying To Create Internal Req and Internal Sales Order (Doc ID 746762.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0.4 and later
Information in this document applies to any platform.
*** Checked for relevance on 04-SEP-2015 ***

Symptoms

R12.0.4 in Test


PROBLEM
Using R12 DRP plan for supply and demand leveling between Warehouses. Internal Sales Order / Requisition and shipping networks has been created for the Warehouses.

For Item where demand was created in Warehouse A and sourcing rule was set-up to Transfer
from Warehouse B .
DRP Plan created Planned Inbound request in Whse A for the Item to ship from Whse B


When Planned inbound request was released from Whse A it failed to create the Internal Requisition in Whse A
And it also received an Error When trying to create the Internal Sales order for Whse B


STEPS
DRP Plan --> Query DRP Plan ---> Find Item --> Planned Inbound shipment Order-->
Release the planned shipment which should create both the Internal Requisition and Internal Sales order




Log file Error:

MSC_RELEASE_ISO module: MSC Create and Reschedule ISO

.......
**Starts**18-OCT-2008 13:01:35
**Ends**18-OCT-2008 13:01:37
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Transaction_id :67502
Load_type :32
Successful in Creating requisition.
Requisition Header ID     :465
Internal Requisition Number : 14
Requisition Line Num        : 1
Requisition Line ID       : 577
Item ID                     : 3043
Quantity                    : 68
Deliver To loc ID         :145
DRP_REQ_LOAD :32
l_org_trans_rel_cur.load_type :32
lv_source_subinv
Source organization id => 86
Error :1 Validation failed for the field - Bill To
Error in loading sales order.
Error in CREATE_AND_SCHEDULE_ISO : e_creating_iso_err

Output File

                                            Internal Requisition/ISO Release and Reschedule Report
                                            ----------------------------------

.....

67502         Release        Error while creating Internal Sales Order. 
 
0 out of 1 Internal Req/ISO released successfully. 

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