Search Results bom_resource_equipments_uk

Overview

BOM.BOM_RESOURCE_EQUIPMENTS is a Bills of Material (BOM) module table that stores equipment resource definitions in Oracle E-Business Suite 12.1.1 and 12.2.2. In Oracle Manufacturing, a resource represents any asset used to complete an operation — a machine, a person, or a piece of equipment. This table specifically associates equipment inventory items with those resources, enabling capacity planning, scheduling, and cost rollups on the shop floor. It is used by the Bills of Material and Work in Process (WIP) applications to determine which physical equipment assets back a given resource at a specific organization.

Each row links three identifiers — a resource, an inventory organization, and an inventory item — forming the composite primary key BOM_RESOURCE_EQUIPMENTS_PK on (RESOURCE_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID). The metadata's heuristic Data Vault classification is standalone, meaning no foreign key relationships were mined from the schema. From a modeling perspective, this object is best treated as a hub-like or reference structure whose business keys are the composite identifiers; it can be modeled as its own hub or as a dependent link if you decompose the relationship between resources and equipment items into separate entities.

Key Information Stored

The table contains 29 documented columns. The most significant business columns are:

• RESOURCE_ID — Identifies the manufacturing resource (equipment, machine, or labor) this record qualifies. Part of the primary key and business key.
• ORGANIZATION_ID — The inventory organization in which the equipment resource is defined. Part of the primary key and business key.
• INVENTORY_ITEM_ID — The inventory item representing the physical equipment asset. Part of the primary key and business key.
• INSTANCE_ID — Instance identifier; forms the unique index BOM_RESOURCE_EQUIPMENTS_UK.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — The standard Oracle EBS descriptive flexfield (DFF) columns, allowing clients to extend the table with site-specific equipment attributes without schema modification.

The surrogate/primary key is the composite (RESOURCE_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID), duplicated in unique index BOM_RESOURCE_EQUIPMENTS_U2. Standard EBS audit columns are present: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN. Concurrency-control columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE capture the concurrent program that last touched the row.

Common Use Cases and Queries

Typical scenarios include reporting which equipment items are assigned to resources in an organization, validating that a resource's equipment is properly defined before WIP scheduling, and extracting DFF attribute values for custom equipment dashboards.

A representative query joins the table to its resource and item masters:

• SELECT bre.resource_id, bre.organization_id, bre.inventory_item_id, bre.attribute_category FROM bom.bom_resource_equipments bre WHERE bre.organization_id = :org_id;
• Join to BOM_RESOURCES on RESOURCE_ID and ORGANIZATION_ID to retrieve resource codes and types.
• Join to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID to resolve the equipment item description and segment values.
• Filter by DFF columns (ATTRIBUTE_CATEGORY, ATTRIBUTE1..15) to isolate categorised equipment for cost or maintenance reporting.

Related Objects

The metadata classifies this table as standalone with no mined foreign keys, but in the EBS BOM data model it is functionally referenced by the following objects:

• BOM_RESOURCES — joined on RESOURCE_ID and ORGANIZATION_ID; the parent resource definition.
• BOM_RESOURCE_CHARGES — charges applied to the same resource.
• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID and ORGANIZATION_ID to resolve the equipment item.
• BOM_OPERATION_RESOURCES — links resources (and therefore their equipment) to routing operations.
• BOM_DEPARTMENTS — owning department for resources that consume this equipment.
• WIP_OPERATIONS and WIP_REQUIREMENT_OPERATIONS — consume resource/equipment definitions during production scheduling.