Why Do We See Multiple Planned Orders For An Item For the Same Day - Why Are Quantities Not Aggregated? (Doc ID 1150633.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information 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;


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