Search Results bom_std_sub_op_resources_pk

Overview

BOM_STD_SUB_OP_RESOURCES is a Bills of Material (BOM) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas. It stores substitute resource information for a particular operation within a standard routing. In discrete and process manufacturing environments, a primary resource (such as a machine, department, or labor crew) may be unavailable or subject to alternate scheduling; this table defines the replacement resources that may be used in its place, together with the usage rates and basis rules that govern the substitution.

The object resides in the BOM schema and is classified as VALID. With two documented foreign keys pointing outward to BOM_RESOURCES and CST_ACTIVITIES, the table functions as an associative structure linking resources to standard operations. Under the heuristic Data Vault classification supplied in the metadata, this object is best modeled as a link: it resolves a many-to-many relationship between standard operations and the resources (including substitute resources) that may perform them, rather than serving as a standalone hub or a descriptive satellite.

Key Information Stored

The documented physical schema for 12.2.2 comprises 38 columns. The most significant are:

• STANDARD_OPERATION_ID and RESOURCE_ID — identify the standard operation and the substitute resource; RESOURCE_ID is a foreign key to BOM_RESOURCES.
• SUBSTITUTE_GROUP_NUM and REPLACEMENT_GROUP_NUM — group substitute resources and their replacements so that an entire set of resources can be swapped as a unit.
• ACTIVITY_ID — foreign key to CST_ACTIVITIES, tying the resource usage to a costing activity.
• ASSIGNED_UNITS, USAGE_RATE_OR_AMOUNT, and USAGE_RATE_OR_AMOUNT_INVERSE — quantify how much of the resource is consumed or charged per unit of production, and the inverse rate.
• BASIS_TYPE — determines whether usage is expressed per item, per lot, or on a fixed basis.
• STANDARD_RATE_FLAG, SCHEDULE_FLAG, and SCHEDULE_SEQ_NUM — control whether standard rates apply, whether the resource is scheduled, and the scheduling sequence.
• AUTOCHARGE_TYPE — governs automatic charging behaviour for the resource.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard Oracle descriptive flexfield columns.
• Audit columns including CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and the concurrent program columns (REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE).

The primary key BOM_STD_SUB_OP_RESOURCES_PK is composed of RESOURCE_ID, STANDARD_OPERATION_ID, SUBSTITUTE_GROUP_NUM, and REPLACEMENT_GROUP_NUM. A separate unique index, BOM_STD_SUB_OP_RESOURCES_U1, adds BASIS_TYPE to the same four columns plus STANDARD_OPERATION_ID, RESOURCE_ID, SUBSTITUTE_GROUP_NUM, and REPLACEMENT_GROUP_NUM, making it the strongest business-key candidate.

Common Use Cases and Queries

Typical reporting scenarios include listing the substitute resources defined for a routing, auditing usage rates for costing, and validating that substitute groups are complete. A common query joins the table to BOM_RESOURCES to resolve resource names:

• Substitute resources per operation: SELECT s.standard_operation_id, s.resource_id, s.substitute_group_num, s.replacement_group_num, s.usage_rate_or_amount FROM bom.bom_std_sub_op_resources s WHERE s.standard_operation_id = :op_id;
• Resource description lookup: join RESOURCE_ID to BOM_RESOURCES.RESOURCE_ID to obtain resource codes and descriptions.
• Costing analysis: join ACTIVITY_ID to CST_ACTIVITIES to correlate substitute resources with activity rates used in cost rollups.
• Basis validation: group by BASIS_TYPE to detect inconsistent usage rate definitions across substitute groups.

Related Objects

• BOM_RESOURCES — referenced via BOM_STD_SUB_OP_RESOURCES.RESOURCE_ID; supplies the substitute resource definition.
• CST_ACTIVITIES — referenced via BOM_STD_SUB_OP_RESOURCES.ACTIVITY_ID; supplies costing activity data.
• BOM_STD_OPERATIONS / BOM_OPERATION_RESOURCES — parent routing operation and primary resource tables that the substitute rows complement.
• BOM_ROUTINGS / BOM_OPERATIONAL_ROUTINGS — routing headers under which standard operations are defined.
• BOM_RESOURCE_CHARGES — related resource charge definitions used during costing.
• WIP and CST costing views — consume substitute resource usage when scheduling and costing work orders.
• BOM resource APIs — PL/SQL packages that insert and maintain substitute resource rows.