Search Results bom_sub_operation_resources




Overview
Explore in AI Chat

Overview

BOM_SUB_OPERATION_RESOURCES is a table in the Oracle Bills of Material (BOM) schema that stores substitute resource definitions associated with routing operations. In Oracle EBS manufacturing, a primary resource is assigned to an operation on a routing, and substitute resources may be defined to provide alternate capacity or cost alternatives when the primary resource is unavailable, constrained, or must be replaced for a specific production run. This table captures those substitutes, together with the replacement groups, usage rates, basis types, and scheduling attributes that govern how each substitute is applied.

The table is owned by the BOM schema and is classified as VALID in the ETRM 12.2.2 physical schema, which documents 44 columns. Its primary key, BOM_SUB_OPERATION_RESOURCES_PK, is composed of OPERATION_SEQUENCE_ID, SUBSTITUTE_GROUP_NUM, and RESOURCE_ID. Under the heuristic Data Vault classification derived from its foreign-key structure, the object is modeled as standalone, meaning it functions primarily as a self-contained detail table keyed by operation sequence and resource rather than as a pure hub, link, or satellite. The single documented foreign key references BOM_SETUP_TYPES through SETUP_ID, indicating that a substitute resource record may be tied to a setup type definition.

Key Information Stored

The table's identity is anchored by its three-part primary key and by the unique business-key candidate BOM_SUB_OPERATION_RESOURCES_U1, which spans OPERATION_SEQUENCE_ID, RESOURCE_ID, SUBSTITUTE_GROUP_NUM, REPLACEMENT_GROUP_NUM, BASIS_TYPE, and SCHEDULE_FLAG. The most significant columns include:

  • OPERATION_SEQUENCE_ID — The operation sequence on the routing to which the substitute applies; part of the primary key.
  • SUBSTITUTE_GROUP_NUM — Identifies the substitute group, allowing several substitute resources to be grouped; part of the primary key.
  • RESOURCE_ID — The substitute resource being defined; part of the primary key.
  • REPLACEMENT_GROUP_NUM — Distinguishes replacement groups within the substitute definition.
  • BASIS_TYPE — Indicates the basis on which the resource usage is calculated.
  • SCHEDULE_FLAG — Controls whether the substitute resource is considered during scheduling.
  • ASSIGNED_UNITS — The number of resource units assigned to the operation.
  • USAGE_RATE_OR_AMOUNT and USAGE_RATE_OR_AMOUNT_INVERSE — The usage rate or amount, and its inverse, applied to the substitute resource.
  • RESOURCE_OFFSET_PERCENT — The offset percentage applied when scheduling the resource.
  • AUTOCHARGE_TYPE and ACD_TYPE — Control automatic charging behavior for the resource.
  • STANDARD_RATE_FLAG and PRINCIPLE_FLAG — Flags governing rate and principle handling.
  • SETUP_ID — Foreign key to BOM_SETUP_TYPES, tying the record to a setup definition.
  • CHANGE_NOTICE and ORIGINAL_SYSTEM_REFERENCE — Support change control and source-system traceability.
  • Standard WHO columns (LAST_UPDATE_DATE, CREATED_BY, and related audit fields) plus ATTRIBUTE1–ATTRIBUTE15 provide audit and extensibility.

Common Use Cases and Queries

Manufacturing and cost analysts query this table to determine which alternate resources are available for an operation and how they are scheduled. A typical query joins substitute resources to their operation sequence to list all substitutes for a given routing:

  • SELECT operation_sequence_id, substitute_group_num, resource_id, basis_type, usage_rate_or_amount, schedule_flag FROM bom.bom_sub_operation_resources WHERE operation_sequence_id = :seq_id;
  • Reporting on scheduling behavior by filtering on SCHEDULE_FLAG or grouping by REPLACEMENT_GROUP_NUM.
  • Costing and rate analysis using USAGE_RATE_OR_AMOUNT, USAGE_RATE_OR_AMOUNT_INVERSE, and STANDARD_RATE_FLAG.
  • Change-control audits restricted by CHANGE_NOTICE or ORIGINAL_SYSTEM_REFERENCE.
  • Setup-type linkage analysis by joining SETUP_ID to BOM_SETUP_TYPES.

Related Objects

The following objects are most significant in relation to BOM_SUB_OPERATION_RESOURCES:

  • BOM_OPERATION_SEQUENCES — Parent routing operation referenced through OPERATION_SEQUENCE_ID.
  • BOM_SETUP_TYPES — Referenced via the documented foreign key SETUP_ID.
  • BOM_RESOURCES — Source of RESOURCE_ID and resource attribute definitions.
  • BOM_OPERATION_RESOURCES — Holds the primary resource assignment for the same operation sequence.
  • BOM_SUB_OPERATION_RESOURCES_PK — The primary key constraint over OPERATION_SEQUENCE_ID, SUBSTITUTE_GROUP_NUM, RESOURCE_ID.
  • BOM_SUB_OPERATION_RESOURCES_U1 — The unique business-key index used for validation.