My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

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

In product terminology,

Collect all
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

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

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
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.