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 MAY 19, 2019

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. 


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.