Search Results bom_reference_designators

Overview

The BOM_REFERENCE_DESIGNATORS table is a core data object within the Bills of Material (BOM) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves the critical function of storing reference designators for components within a bill of material. A reference designator is a specific identifier, often an alphanumeric code, that denotes the precise physical location or mounting point of a component on an assembly or printed circuit board (PCB). This table enables detailed manufacturing and engineering documentation by linking components to their specific positions, which is essential for assembly instructions, quality control, and repair operations.

Key Information Stored

The table's structure is designed to associate reference designators with their corresponding bill of material component lines. Its primary key, BOM_REFERENCE_DESIGNATORS_PK, is a composite key based on the columns COMPONENT_REFERENCE_DESIGNATOR, COMPONENT_SEQUENCE_ID, and ACD_TYPE. This ensures uniqueness for each designator linked to a specific component instance. The COMPONENT_SEQUENCE_ID is a foreign key that links directly to the BOM_COMPONENTS_B table, establishing the parent-child relationship between a component and its designators. The ACD_TYPE column typically indicates whether the record is for an actual component or a substitute. Other columns in the full table (implied by standard EBS data models) would store audit information such as creation date and last update date.

Common Use Cases and Queries

This table is primarily accessed for generating assembly documentation, troubleshooting, and component traceability. A common reporting requirement is to list all reference designators for components on a specific assembly or bill. A typical SQL query would join BOM_REFERENCE_DESIGNATORS to BOM_COMPONENTS_B and the primary bill tables (BOM_BILL_OF_MATERIALS, BOM_INVENTORY_COMPONENTS) to produce a pick list or assembly drawing report. For example, to find designators for a specific assembly item and revision, one would filter through the component sequence IDs. Data in this table is typically maintained via the Oracle EBS user interface forms for Bills of Material, where reference designators are entered on the component details.

Related Objects

The BOM_REFERENCE_DESIGNATORS table has a fundamental dependency on the BOM_COMPONENTS_B table, as enforced by its foreign key constraint. This relationship is central to its function. Key related objects include:

• BOM_COMPONENTS_B: The primary table for bill of material component details. The COMPONENT_SEQUENCE_ID in BOM_REFERENCE_DESIGNATORS references this table's primary key.
• BOM_BILL_OF_MATERIALS: The master table defining a bill of material header, which is the ultimate parent of the component data.
• MTL_SYSTEM_ITEMS_B: The master item table, which defines the inventory items used as components and assemblies.
• Standard BOM APIs: Such as BOM_BO_PUB, which may include procedures for processing component data including reference designators during bill import or maintenance.