Search Results bom_cto_order_demand




Overview
Explore in AI Chat

Overview

BOM_CTO_ORDER_DEMAND (internally referenced as BCOD) is an Oracle Bills of Material table that stores Configure-to-Order (CTO) order demand records. It captures the demand generated against an assemble-to-order (ATO) configuration model when a sales order line is booked, providing the demand-side counterpart that Oracle's planning and manufacturing engines consume during configuration explosion, scheduling, and fulfillment. The table resides in the BOM schema and is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2.

In Data Vault modeling terms, the heuristic classification mined from the foreign key structure is standalone. This suggests the table behaves as an independent entity rather than a strict hub, link, or satellite, primarily because no inbound foreign keys from peer BOM tables define it and its only documented relationship is an outbound reference from MRP_AD_CTO_ORDER_DEMAND. Modelers treating this as a hub should validate whether OE_LINE_ID, ATO_LINE_ID, or HEADER_ID carry sufficient business-key uniqueness; the documented unique business-key candidate is the primary key itself.

Key Information Stored

The table contains 18 documented columns. The most significant are:

Common Use Cases and Queries

Primary use cases include diagnosing CTO demand visibility in planning, reconciling sales order lines to their configuration demand records, and reporting on required quantities and dates by organization. A typical query joins BCOD to the order line to trace demand:

  • SELECT bc.oe_line_id, bc.ato_line_id, bc.inventory_item_id, bc.required_qty, bc.required_date FROM bom_cto_order_demand bc WHERE bc.organization_id = :org_id AND bc.demand_visible = 'Y';
  • Identify demand suppressed from forecasting: filter WHERE forecast_visible = 'N'.
  • Reconcile plan rows by joining to mrp_ad_cto_order_demand ON mrp.bcod_line_id = bc.bcod_line_id.
  • Aggregate required quantities by item and required_date for capacity planning.

Related Objects

  • MRP_AD_CTO_ORDER_DEMAND — References BOM_CTO_ORDER_DEMAND.BCOD_LINE_ID; the principal dependent planning table.
  • OE_ORDER_LINES_ALL — Source of OE_LINE_ID and order-line context.
  • OE_ORDER_HEADERS_ALL — Source of HEADER_ID.
  • MTL_SYSTEM_ITEMS_B — Resolves INVENTORY_ITEM_ID.
  • ORG_ORGANIZATION_DEFINITIONS — Resolves ORGANIZATION_ID for multi-org reporting.
  • BOM_CTO_ORDER_DEMAND_U1 / _PK — Unique index and primary key enforcing BCOD_LINE_ID integrity.