My Oracle Support Banner

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.
MSCFNSCW
MSCPDP
MTL_SYSTEM_ITEMS_B
MTL_SYS_ITEMS_SN


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:

SELECT
         -- columns
FROM
         INV.MTL_SYSTEM_ITEMS_B msik
WHERE (
          (
            (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
           )
          )
       AND
        (    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,

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
AND
a.2) has a non-null Primary UOM
AND
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)
      OR
a.3.2) is a Planning BOM
      OR
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
Purpose
 Item Status and Planning Data Collection
Troubleshooting Steps
References

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