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.

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