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


R12.0.4 in Test

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

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
l_org_trans_rel_cur.load_type :32
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. 


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