Why Do We See Multiple Planned Orders For An Item For the Same Day - Why Are Quantities Not Aggregated?
Last updated on NOVEMBER 17, 2016
Applies to:
Oracle Advanced Supply Chain Planning - Version 11.5.10 and laterInformation in this document applies to any platform.
Symptoms
Why do we see Multiple planned orders on a single day?
We want to see all quantities in Aggregate - so we have a single planned order for each day with total quantity for an item.
We ran SQL to check all planned orders, by item and found many lines for the same item on the same Suggested Due Date.
select count(1), inventory_item_id, new_schedule_date
from apps.msc_supplies
where sr_instance_id = &Inst_id -- used 1
and plan_id = &plan_id -- used 25
and order_type = 5 -- planned orders
and supplier_id is not null -- buy items only
and new_schedule_date <sysdate+&daily_buckets -- set for daily buckets value in this case 180
group by inventory_item_id, new_schedule_date
having count(1) > 2
order by 1 desc;
from apps.msc_supplies
where sr_instance_id = &Inst_id -- used 1
and plan_id = &plan_id -- used 25
and order_type = 5 -- planned orders
and supplier_id is not null -- buy items only
and new_schedule_date <sysdate+&daily_buckets -- set for daily buckets value in this case 180
group by inventory_item_id, new_schedule_date
having count(1) > 2
order by 1 desc;
Our plan has been setup for ECC constrained without decision rules 180 days - so many of these orders fall inside 180 days. Planning Time Fence is checked.
Changes
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