Analytics Catalog/Data dictionary/MSC_ANALYTIC_ITEMS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

MSC_ANALYTIC_ITEMS

SharedUsed in 98 subject areas69 reporting columns

Supply Chain Planning (MSC).

Primary key: not yet catalogued for MSC_ANALYTIC_ITEMS, reference Oracle Tables & Views guide.
Joins (inferred from key columns): INVENTORY_ITEM_ID → INV_LICENSE_PLATE_NUMBERS · ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V

Columns

ColumnKeyIn reportsDescription (inferred)
ABC_CLASS_NAME●Name of the abc class.
ATO_FORECAST_CONTROL●Ato forecast control.
BASE_MODEL●Base model.
BOM_ITEM_TYPE●Type of bom item.
BUYER_NAME●Name of the buyer.
CARRYING_COST●Carrying cost.
CATEGORY_SET_ID●Identifier for the category set.
CATEGORY_SET_NAME●Name of the category set.
CRITICAL_COMPONENT_FLAG●Indicator (Y/N) for the critical component.
CUM_MANUFACTURING_LEAD_TIME●Cum manufacturing lead time.
DEMAND_TIME_FENCE_CODE●Code identifying the demand time fence.
DEMAND_TIME_FENCE_DATE●Demand time fence date.
DEMAND_TIME_FENCE_DAYS●Demand time fence days.
DESCRIPTION●Description.
FIXED_DAYS_SUPPLY●Fixed days supply.
FIXED_LEAD_TIME●Fixed lead time.
FIXED_LOT_MULTIPLIER●Fixed lot multiplier.
FIXED_ORDER_QUANTITY●Fixed order quantity.
FORECAST_NAME●Name of the forecast.
FULL_LEAD_TIME●Full lead time.
HIERARCHY_ID●Identifier for the hierarchy.
INVENTORY_ITEM_ID●Identifier for the inventory item.
ITEM_COST_OVERRIDE●Item cost override.
ITEM_COST_UOM●Item cost unit of measure.
ITEM_NAME●Name of the item.
LIFE_CYCLE_PHASE●Life cycle phase.
LIST_PRICE●List price.
MAXIMUM_ORDER_QUANTITY●Maximum order quantity.
MEMBER1●Member1.
MEMBER10●Member10.
MEMBER2●Member2.
MEMBER3●Member3.
MEMBER4●Member4.
MEMBER5●Member5.
MEMBER6●Member6.
MEMBER7●Member7.
MEMBER8●Member8.
MEMBER9●Member9.
MINIMUM_ORDER_QUANTITY●Minimum order quantity.
MRP_PLANNING_CODE●Code identifying the mrp planning.
NAME1●Name1.
NAME10●Name10.
NAME2●Name2.
NAME3●Name3.
NAME4●Name4.
NAME5●Name5.
NAME6●Name6.
NAME7●Name7.
NAME8●Name8.
NAME9●Name9.
NET_SELLING_PRICE●Net selling price.
ORGANIZATION_CODE●Code identifying the organization.
ORGANIZATION_ID●Identifier for the organization.
PLANNER_CODE●Code identifying the planner.
PLANNING_MAKE_BUY_CODE●Code identifying the planning make buy.
PLANNING_TIME_FENCE_CODE●Code identifying the planning time fence.
PLANNING_TIME_FENCE_DATE●Planning time fence date.
PLANNING_TIME_FENCE_DAYS●Planning time fence days.
POSTPROCESSING_LEAD_TIME●Postprocessing lead time.
PREPROCESSING_LEAD_TIME●Preprocessing lead time.
RELEASE_TIME_FENCE_CODE●Code identifying the release time fence.
RELEASE_TIME_FENCE_DAYS●Release time fence days.
SAFETY_STOCK_CODE●Code identifying the safety stock.
SAFETY_STOCK_PERCENT●Safety stock percentage.
SAFETY_STOCK_QUANTITY●Safety stock quantity.
SAFETY_STOCK_QUANTITY_OVERRIDE●Safety stock quantity override.
UOM_CODE●Code identifying the unit of measure.
USE_UP_DATE●Use up date.
VARIABLE_LEAD_TIME●Variable lead time.

Used by reports

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.

Need the extract + dbt staging for MSC_ANALYTIC_ITEMS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern