Search Results bom_resource_changes

Overview

The BOM_RESOURCE_CHANGES table is a core transactional data object within the Oracle E-Business Suite Bills of Material (BOM) module. It serves as the central repository for recording planned modifications to resource capacity and availability. In the context of manufacturing and production planning, resources represent machines, labor, or other assets with finite capacity. This table enables planners to model temporary changes to standard operating schedules—such as adding overtime, scheduling downtime for maintenance, or simulating alternative shift patterns—without permanently altering the base resource definitions. Its primary role is to support capacity planning and "what-if" simulations, allowing businesses to assess the impact of resource availability changes on production schedules and material requirements.

Key Information Stored

The table's structure is designed to precisely define the scope and nature of a resource modification. The primary key columns establish the unique identifier for each change record: DEPARTMENT_ID, RESOURCE_ID, and SHIFT_NUM pinpoint the specific resource and its standard shift. The temporal boundaries are defined by FROM_DATE, TO_DATE, FROM_TIME, and TO_TIME, allowing for changes applicable to specific dates and times of day. The ACTION_TYPE column is critical, indicating the nature of the modification (e.g., adding capacity, reducing it, or setting it to zero). Finally, the SIMULATION_SET column groups changes together for analysis, allowing multiple hypothetical scenarios to coexist without affecting live production data until a chosen set is implemented.

Common Use Cases and Queries

A primary use case is capacity planning, where a planner needs to view all scheduled overtime for a resource in an upcoming period. A typical query would filter by RESOURCE_ID, a future FROM_DATE, and a relevant ACTION_TYPE. Another common scenario is simulation analysis, where a planner creates a set of changes (a SIMULATION_SET) to model the impact of a potential machine upgrade or a temporary labor shortage. Reporting often involves joining this table to BOM_DEPARTMENTS and BOM_RESOURCES to get descriptive names. A fundamental query pattern is to retrieve effective changes for a given resource and date:

• SELECT * FROM bom.bom_resource_changes WHERE resource_id = 100 AND simulation_set = 'UPGRADE_SIM_01' AND from_date <= SYSDATE AND to_date >= SYSDATE;

This table is also integral to the Capacity Planning and Master Production Scheduling (MPS) processes, where its data feeds calculations for available capacity.

Related Objects

The BOM_RESOURCE_CHANGES table has a direct foreign key relationship to the BOM_RESOURCE_SHIFTS table, which holds the standard, baseline shift definitions for resources. This enforces referential integrity, ensuring changes are only defined for valid resource-shift combinations. Key related APIs, such as those in the BOM capacity planning packages, likely read from and write to this table to manage simulation data. For reporting and user interfaces, this transactional table may be sourced by various views within the BOM and MRP (Material Requirements Planning) schemas that present aggregated capacity information to planners. Its data ultimately influences the detailed capacity calculations performed within the Manufacturing Scheduling engine.