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

MSC_ANALYTIC_FACT_ORD_V

SharedUsed in 1 subject areas119 reporting columns

Supply Chain Planning (MSC) — denormalized view.

Primary key: not yet catalogued for MSC_ANALYTIC_FACT_ORD_V — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
ACTION●Action.
ACTUAL_START_DATE●Actual start date.
ARRIVAL_SET_NAME●Name of the arrival set.
BASE_PLAN_ID●Identifier for the base plan.
BUCKET_TYPE●Type of bucket.
BUYER_MANAGED_TRANSPORTATION●Buyer managed transportation.
CLEAR_TO_BLD_COMP_AVBLTY●Clear to bld comp avblty.
CLEAR_TO_BUILD●Clear to build.
CLEAR_TO_BUILD_HORIZON●Clear to build horizon.
COMPRESSION_DAYS●Compression days.
DAYS_LATE●Days late.
DAYS_PAST_DUE●Days past due.
DEMAND_CLASS●Demand class.
DEMAND_PRIORITY●Demand priority.
DESTINATION_TYPE●Type of destination.
END_DEMAND_VALUE●End demand value.
EXPENSE_TRANSFER●Expense transfer.
EXPIRATION_DATE●Expiration date.
FIRM_DATE●Firm date.
FIRM_QUANTITY●Firm quantity.
FIRM_STATUS●Status of the firm.
FULFILLMENT_LINE●Fulfillment line.
GLOBAL_ATTRIBUTE_NUMBER11●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER12●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER13●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER14●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER15●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER16●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER17●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER18●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER19●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER20●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER21●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER22●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER23●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER24●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER25●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER26●Global descriptive flexfield segment.
IMPLEMENTED_QUANTITY●Implemented quantity.
IMPLEMENTED_SUPPLY_QUANTITY●Implemented supply quantity.
IMPLEMENT_DATE●Implement date.
IMPLEMENT_DOCK_DATE●Implement dock date.
IMPLEMENT_FIRM●Implement firm.
IMPLEMENT_ITEM_STRUCTURE_NAME●Name of the implement item structure.
IMPLEMENT_ORDER_TYPE●Type of implement order.
IMPLEMENT_QUANTITY●Implement quantity.
IMPLEMENT_SHIPPING_METHOD●Implement shipping method.
IMPLEMENT_SHIP_DATE●Implement shipment date.
IMPLEMENT_SOURCE_ORGANIZATION●Implement source organization.
IMPLEMENT_STATUS●Status of the implement.
IMPLEMENT_SUPPLIER●Implement supplier.
IMPLEMENT_SUPPLIER_SITE●Implement supplier site.
IMPLEMENT_WORK_DEFINITION_NAME●Name of the implement work definition.
IMPLEMENT_WORK_ORDER_SUBTYPE●Implement work order subtype.
ITEM_STRUCTURE_NAME●Name of the item structure.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATE●Date and time the row was last updated (the incremental-extract key).
LATEST_ACCEPTABLE_DATE●Latest acceptable date.
LINE_NUMBER●Line number.
LOT●Lot.
MATERIAL_AVLBL_DATE●Material avlbl date.
NEED_BY_DATE●Need by date.
NETTABLE_SUP_QTY_OVERRIDE●Nettable sup quantity override.
OLD_DOCK_DATE●Old dock date.
OLD_DUE_DATE●Old due date.
ORDER_DATE●Order date.
ORDER_DATE_TYPE●Type of order date.
ORDER_ID●Identifier for the order.
ORDER_NUMBER●Order number.
ORDER_QUANTITY●Order quantity.
ORDER_TYPE_TEXT●Order type text.
ORDER_VALUE●Order value.
ORIGINAL_ITEM●Original item.
ORIGINAL_ITEM_QUANTITY●Original item quantity.
ORIGINAL_NEED_BY_DATE●Original need by date.
ORIGINAL_ORDER_QUANTITY●Original order quantity.
OVERRIDE_DEMAND_PRIORITY●Override demand priority.
PLANNED_ARRIVAL_DATE●Planned arrival date.
PLANNED_ORDER_TYPE●Type of planned order.
PRODUCT_FAMILY●Product family.
PROMISED_ARRIVAL_DATE●Promised arrival date.
PROMISED_SHIP_DATE●Promised shipment date.
QUANTITY_BY_DUE_DATE●Quantity by due date.
QUANTITY_SATISFIED_BY_DUE_DATE●Quantity satisfied by due date.
READY_TO_BUILD_PERCENTAGE●Ready to build percentage.
RECOMMENDATION_TYPE●Type of recommendation.
RELEASE_ERRORS●Release errors.
RELEASE_STATUS●Status of the release.
REQUESTED_ARRIVAL_DATE●Requested arrival date.
REQUESTED_SHIP_DATE●Requested shipment date.
RESCHEDULED●Rescheduled.
RESCHEDULE_DAYS●Reschedule days.
RESERVED_QUANTITY●Reserved quantity.
REVISED_DEMAND_DATE●Revised demand date.
REVISED_DEMAND_PRIORITY●Revised demand priority.
SCHEDULE_ARRIVAL_DATE●Schedule arrival date.
SCHEDULE_NAME●Name of the schedule.
SCHEDULE_SHIP_DATE●Schedule shipment date.
SEGMENT_NAME●Name of the segment.
SHIPMENT_SET_NAME●Name of the shipment set.
SHIPPING_METHOD●Shipping method.
SHIP_TO●Shipment to.
SOURCE_ORDER_PRIORITY●Source order priority.
SOURCE_ORGANIZATION●Source organization.
START_QUANTITY●Start quantity.
SUBINVENTORY●Subinventory.
SUGGESTED_DOCK_DATE●Suggested dock date.
SUGGESTED_DUE_DATE●Suggested due date.
SUGGESTED_ORDER_DATE●Suggested order date.
SUGGESTED_SHIP_DATE●Suggested shipment date.
SUGGESTED_START_DATE●Suggested start date.
TRANSIT_LEAD_TIME●Transit lead time.
UNIT_NUMBER●Unit number.
UNMET_DEMAND_QUANTITY●Unmet demand quantity.
UOM●Unit of measure.
USING_ASSEMBLY●Using assembly.
WORK_DEFINITION_NAME●Name of the work definition.
WORK_ORDER_STATUS●Status of the work order.
ZONE●Zone.

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_FACT_ORD_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us