Search Results bom_std_sub_op_resources_u1

Overview

BOM.BOM_STD_SUB_OP_RESOURCES is a transactional table in the Oracle E-Business Suite Bills of Material schema that stores substitute resource information for a specific standard operation on a routing. Where a standard operation may consume more than one resource — labor, machine, or equipment — this table records alternative (replacement) resources that can be used in place of the primary resource, and the associated basis on which each is charged or scheduled. The table is populated and maintained through the routing and standard operation maintenance flows and is consumed downstream by costing, capacity planning, and shop floor execution processes.

Under an heuristic Data Vault classification inferred from the foreign key structure, BOM_STD_SUB_OP_RESOURCES is best modeled as a link — it resolves a many-to-many relationship between standard operations and the resources (including their substitutes) that satisfy them. It is not a descriptive satellite in the strict sense, because it carries its own measurable attributes (assigned units, usage rates, flags), but it functions structurally as an associative entity bridging BOM_RESOURCES and standard operations.

Key Information Stored

The table is identified primarily by five business-key columns, which together constitute the unique index BOM_STD_SUB_OP_RESOURCES_U1:

• STANDARD_OPERATION_ID — the standard operation to which the substitute resource belongs.
• RESOURCE_ID — the substitute resource; foreign key to BOM_RESOURCES.
• SUBSTITUTE_GROUP_NUM — identifies the substitute group within the operation.
• REPLACEMENT_GROUP_NUM — identifies the replacement group within the substitute group.
• BASIS_TYPE — the basis on which the resource usage rate is expressed and charged.

Note that the physical primary key constraint BOM_STD_SUB_OP_RESOURCES_PK is documented on four columns (RESOURCE_ID, STANDARD_OPERATION_ID, SUBSTITUTE_GROUP_NUM, REPLACEMENT_GROUP_NUM), while the unique index U1 adds BASIS_TYPE — the column of primary interest to a user searching for bom_std_sub_op_resources_u1. Operationally important non-key columns include:

• ASSIGNED_UNITS — 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 reciprocal.
• SCHEDULE_FLAG, SCHEDULE_SEQ_NUM — whether and in what sequence the resource is scheduled.
• STANDARD_RATE_FLAG — whether the standard rate applies for shop floor transactions.
• AUTOCHARGE_TYPE — autocharge behavior for shop floor moves.
• ACTIVITY_ID — foreign key to CST_ACTIVITIES.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield segments.
• Standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) and concurrent request columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE).

Common Use Cases and Queries

Typical reporting and integration scenarios include auditing substitute resource assignments on standard operations, validating assigned units and usage rates against the primary resource, and extracting routing data for capacity or cost simulation. A representative query joining to BOM_RESOURCES:

SELECT s.STANDARD_OPERATION_ID, s.RESOURCE_ID, s.SUBSTITUTE_GROUP_NUM, s.REPLACEMENT_GROUP_NUM, s.BASIS_TYPE, s.ASSIGNED_UNITS, s.USAGE_RATE_OR_AMOUNT FROM BOM.BOM_STD_SUB_OP_RESOURCES s, BOM.BOM_RESOURCES r WHERE s.RESOURCE_ID = r.RESOURCE_ID AND s.STANDARD_OPERATION_ID = :op_id;

To enumerate fully qualified substitute groups, filter on the U1 columns and order by the group numbers. Diagnostics for duplicate or orphan records should drive on the U1 index rather than the PK, because BASIS_TYPE participates in the uniqueness constraint.

Related Objects

• BOM.BOM_RESOURCES — referenced via RESOURCE_ID; the master resource definition.
• BOM.BOM_STD_OPERATIONS — parent standard operation referenced via STANDARD_OPERATION_ID.
• CST.CST_ACTIVITIES — referenced via ACTIVITY_ID for cost activity assignment.
• BOM.BOM_OPERATION_RESOURCES — the primary (non-substitute) resource assignment for the same operation.
• BOM.BOM_SUB_OP_RESOURCES — substitute resources used against non-standard / bill-specific operations.
• BOM_BILL_OF_MATERIALS / BOM routing views — read this table to resolve effective substitute resources on routings.
• BOM Routing APIs — create, update, and delete substitute resource rows through the standard operation resource interfaces.