Advanced Supply Chain Planning (ASCP) Item Collection Criteria (Doc ID 1060245.1)

Last updated on SEPTEMBER 04, 2024

Applies to:

Purpose

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:

In product terminology, In forms -> Inventory(R) / Items / Master Items OR Organization Items (depending on setups that control updating fields at Master or Item level)

Collect all items

WHERE
A> Inventory Items -- TAB->Inventory - Inventory Item box is checked
OR Engineering Items -- Only available in Engineering Responsibility / Items / Master Items / TAB->Bills Of Material - Engineering Item checkbox is checked
-- AND --
X> in TAB->MPS/MRP Planning - the Planning Method NOT EQUAL - Not Planned
-- OR IF --
X> Planning Method = NOT Planned
AND Y> OR Z> are true
THEN collect the item
Y> TAB->Order Management - Pick components box is checked
OR
Z> TAB-> Bills of Material - BOM Item Type = Planning BOM 


OR IF
A> IS TRUE (AND X, Y, and Z are NOT TRUE)
AND any of the below are true,
THEN collect the item
a) Check ATP enabled items - TAB->Order Management - Check ATP - is not None
b) ATP Components - TAB->Order Management - ATP Components - is not None
c) DRP Planned Items - TAB->MPS/MRP Planning - Distribution Planned box is checked
d) Equipment Items - TAB->Physical Attributes - Equipment box is checked
e) Asset Management Items - TAB->Asset Management - Asset Item Type is not NULL

 Item Status - This setting is NOT considered in Data Collection

In Item Master form in the Main tab -

Note that the Snapshot criteria above do NOT make any reference to 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
•   Transactable
•   Purchasable
•   Stockable

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.

Troubleshooting Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.