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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed 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
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern