Advanced Supply Chain Planning (ASCP) Item Collection Criteria
(Doc ID 1060245.1)
Last updated on DECEMBER 18, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 11.5.10 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.
The items that are collected by ASCP's Planning Data Collection are controlled by the filtering on the Item Collection Snapshot named MTL_SYS_ITEMS_SN that pulls data from INV.MTL_SYSTEM_ITEMS_B
The SQL that defines what is collected from INV.MTL_SYSTEM_ITEMS_B into MTL_SYS_ITEMS_SN is:
(msik.mrp_planning_code IS NOT NULL
AND msik.mrp_planning_code <> 6 -- Planned Items
OR (msik.PICK_COMPONENTS_FLAG = 'Y' -- CTO Pick components
OR msik.BOM_ITEM_TYPE = 3 -- Planning BOM
( msik.inventory_item_flag = 'Y'
OR msik.eng_item_flag = 'Y'
AND msik.planning_make_buy_code IN (1,2)
AND msik.primary_uom_code IS NOT NULL
OR msik.ATP_FLAG <> 'N'
OR msik.ATP_COMPONENTS_FLAG <> 'N'
OR msik.EQUIPMENT_TYPE = 1
OR msik.DRP_PLANNED_FLAG = 1
OR msik.EAM_ITEM_TYPE IS NOT NULL;
In product terminology,
a) Qualified Inventory or Engineering Items
b) ATP Items
c) ATP Components
d) DRP Planned Items
e) Equipment Items
f) EAM Items (non null Asset Item Type)
The qualifications for Inventory or Engineering Items are
a.1) is a Make or Buy Item
a.2) has a non-null Primary UOM
a.3) is needed for planning because
a.3.1) MRP Planning Method is anything other than Not Planned
(that is to say, not "Not Planned", which means Planned)
a.3.2) is a Planning BOM
a.3.3) is a CTO Pick Component
Item Status and Planning Data Collection
Note that the qualification criteria above do NOT make any reference to Inventory Item Status.
In Inventory, Item Status is a name for a collection of settings for the attributes
- BOM Allowed
- Build in WIP
- Customer Orders Enabled
- Internal Orders Enabled
- Invoice Enabled
The definition of an Item Status does not control the MRP Planning Method attribute.
This means that even if an item has an Item Status = Inactive, it will still be collected for planning if it meets the above Item Collection Criteria.
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
|Item Status and Planning Data Collection|