The social network for Oracle people

OM Shipping from Multi Warehouses

Ok, here is our business scenario.

We have two warehouses (DCs) West coast (WCDC) and East Coast (ECDC). ECDC is the preferred warehouse. We have defined the Zip-code range that defines the ECDC, and the remaining United States is WCDC. We are using ATP sourcing rules to determine where the sales order will ship from. ATP includes on-hand + any incoming Purchase orders. ECDC is the preferred DC.

Sourcing rule is like:
If we have ATP in both DCs, it will check Zip code, if it falls with ECDC it will ship the item from ECDC other wise from WCDC. If we do not have enough ATP in either DC, it will ship from wherever it's available. Now since ATP is included on-hand incoming POs, and ECDC is the preferred DC, even though we do not have any on-hand in ECDC, and PO is for the future date, OM scheduled the orders for ECDC, even though WCDC has some available on-hand.

We want order to be scheduled from the DC wherever it can ship earliest, and not scheduled for future POs. Is this possible? Are there any setups that we are missing, or if you can point to any white papers on this subject, I will greatly appreciate.

Thanks,
Toral

Tags: ascp, atp, om

▶ Reply to This

Replies to This Discussion

Permalink Reply by Bibs on March 28, 2008 at 6:57pm: Is your ATP rule based on Planning output?If not then please define a plan and check the ATP flag to yes.For that plan, in the supply option , donot include Future POs as supply or have a cutoff date for POs to be considered as supply.; ▶ Reply to This

Permalink Reply by tdoracle on March 31, 2008 at 11:13am: Our ATP is based on the collected data. We are in retail business, so we need to ship to customer as soon as we can. If we have future POs, we need to schedule the order to the PO that's going to arrive first to any DCs. If we select a cutoff dae, and PO is out of the range of Cut off date, then order does not get scheduled at all? Does this make any sense?; ▶ Reply to This

Permalink Reply by Bibs on March 31, 2008 at 12:31pm: I think you have to change the way ATP looks at the data.It has to be changed from Collected data to Based on Planning output.Then you have to define some set ups for this.

Let me know if you want to go forward on this.
Then I will tell you what exactly needs to be set up.; ▶ Reply to This

Permalink Reply by tdoracle on March 31, 2008 at 1:44pm: If you have any whitepaper, I can present the solution to my boss, and then we can go forward.; ▶ Reply to This