Search Results bom_resources

Overview

The BOM_RESOURCES table is a core master data table within the Oracle E-Business Suite Bills of Material (BOM) module. It serves as the central repository for defining all resources, overheads, material cost codes, and material overheads that can be assigned to manufacturing operations and departments. These definitions are fundamental for routing and work definition, as well as for cost collection and accounting within the Cost Management module. The table's integrity is enforced by multiple unique constraints, ensuring that resource codes are unique within an organization for a given cost code type, and it acts as a parent table for numerous transactional and setup entities across manufacturing, service, and costing applications.

Key Information Stored

The table's primary identifier is the system-generated RESOURCE_ID. The most critical business key is the combination of RESOURCE_CODE, ORGANIZATION_ID, and COST_CODE_TYPE, which uniquely identifies a resource entry. Key descriptive columns include DESCRIPTION and UNIT_OF_MEASURE. The COST_ELEMENT_ID links the resource to a cost element (e.g., Material, Material Overhead, Resource, Overhead, Outside Processing), defining its role in cost calculations. Critical accounting columns, such as ABSORPTION_ACCOUNT and RATE_VARIANCE_ACCOUNT, store references to general ledger code combinations. The table also holds flags like AUTOCHARGE_TYPE and DISABLE_DATE to control resource behavior and lifecycle.

Common Use Cases and Queries

A primary use case is validating and reporting on all active resources within a specific organization for operational planning. A typical query would be:

• SELECT resource_code, description, unit_of_measure, cost_element_id FROM bom_resources WHERE organization_id = :org_id AND disable_date IS NULL ORDER BY resource_code;

Another common scenario involves cost analysis, where resources are joined with their associated cost rates from the CST_RESOURCE_COSTS table. For troubleshooting data issues, identifying resources used on specific routings or work orders often requires joining BOM_RESOURCES to BOM_OPERATION_RESOURCES or WIP_OPERATIONS. Integration teams frequently query this table to extract resource master data for interfacing with external manufacturing execution systems (MES).

Related Objects

BOM_RESOURCES has extensive relationships across the EBS suite, as evidenced by its foreign keys. Key parent tables include MTL_PARAMETERS (for ORGANIZATION_ID validation), CST_COST_ELEMENTS (for COST_ELEMENT_ID), and GL_CODE_COMBINATIONS (for accounting flexfields). It is referenced as a parent by numerous critical child tables, including:

• BOM_DEPARTMENT_RESOURCES (RESOURCE_ID): Assigns resources to departments.
• CST_RESOURCE_COSTS (RESOURCE_ID): Stores cost rates for resources.
• CST_ITEM_COST_DETAILS (RESOURCE_ID, BASIS_RESOURCE_ID): Holds detailed item cost information.
• BOM_RESOURCE_SETUPS (RESOURCE_ID): Defines setup times for resources.
• AHL_OPERATION_RESOURCES (RESOURCE_ID): Links resources to service operations in the Complex Maintenance, Repair, and Overhaul (CMRO) application.
• CSD_REPAIR_ESTIMATE_LINES (RESOURCE_ID): Used in the Service Depot module for repair estimates.