Inventory Optimization Plan Not Picking Up Forecast And Other Data (Doc ID 1554447.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Optimization - Version 12.1.3.8 and later
Information in this document applies to any platform.

Goal

Users are on 12.1.3 and have applied VCP 12.1.3.8 Patch 14247039 with no one offs at this time. They are testing an Inventory Optimization (MSR) plan run with a Service Parts Plan (SPP) and MRP forecast (from source MRP in EBS instance) as demand schedules. This works fine in another instance but in this instance they are not getting any output in the IO planners workbench. We checked the following:

1. Items are setup with safety stock method as MRP Planned %. They input a proper percentage and safety stock bucket days.

2. The items in question have an ABC class code assigned

3. Data shows collected to the ASCP side and confirmed with following sql where we input the plan id for the SPP plan that was attached as a demand schedule and ABC Class Code assigned to the items:

SELECT
md.inventory_item_id, md.using_assembly_item_id, md.organization_id,
forecast_mad,
MD.USING_assembly_demand_date, msi.organization_code, msi.abc_class,
msi.item_name, msi.description, msi.abc_class_name, MD.USING_REQUIREMENT_QUANtity,
md.bucket_type
from apps.msc_demands md, apps.msc_system_items msi
where md.plan_id = &plan_id_for_demand_schedule_for_SPP
and md.sr_instance_id = 1
and md.origination_type = 29
and msi.plan_id = md.plan_id
and msi.sr_instance_id = md.sr_instance_id
and msi.inventory_item_id = md.inventory_item_id
and msi.organization_id = md.organization_id
and msi.abc_class_name = '&abc_class_code'
order by md.using_requirement_quantity desc;

How was this resolved?
 

Solution

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