Results for “bom_reference_designators_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BOM_REFERENCE_DESIGNATORS is a component-level child table within the Oracle Bills of Material (BOM) module, owned by the BOM schema. It stores reference designator assignments for bill of material components, linking a specific component occurrence on an assembly to one or more printed-circuit-board style reference designators. Reference designators are the alphanumeric identifiers (such as R12, C45, or U3) used to mark where a particular component is placed on an assembled item, making this table central to electronics manufacturing and any environment where component placement tracking is required.

In Oracle E-Business Suite 12.1.1 and 12.2.2, the table participates directly in the component definition model: each row attaches a reference designator value to a component sequence, which is the unique identifier of a component line on a bill of material. The Data Vault classification mined from the foreign key structure is satellite-leaning: the table behaves primarily as a descriptive satellite hanging off BOM_COMPONENTS_B, carrying attributes and change context rather than defining independent business entities or representing a many-to-many relationship between hubs.

Key Information Stored

The physical schema documents 32 columns. The most operationally significant are the following.

• COMPONENT_REFERENCE_DESIGNATOR — the designator value itself (for example, a range or individual label). Part of the composite primary key and the business unique key.
• COMPONENT_SEQUENCE_ID — the foreign key to BOM_COMPONENTS_B identifying the component line to which the designator belongs. Part of the composite primary key and unique key.
• ACD_TYPE — the reference designator type/category qualifier. Part of the composite primary key and unique key.
• REF_DESIGNATOR_COMMENT — free-form commentary attached to the designator assignment.
• CHANGE_NOTICE — the engineering change order (ECO) reference under which the designator record was created or modified.
• ORIGINAL_SYSTEM_REFERENCE — source-system identifier used when the record originated from an external or legacy system.
• COMMON_COMPONENT_SEQUENCE_ID — correlation identifier linking the record to a common (shared) component sequence definition.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns populated when the row is created or updated through a batch process.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard who-columns providing audit traceability.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle flexfield descriptor and descriptive flexfield segment columns.

The surrogate primary key is BOM_REFERENCE_DESIGNATORS_PK, defined over (COMPONENT_REFERENCE_DESIGNATOR, COMPONENT_SEQUENCE_ID, ACD_TYPE). The unique index BOM_REFERENCE_DESIGNATORS_U1 covers the same three columns and therefore acts as the documented business-key candidate, guaranteeing that a given designator is assigned only once per component and type.

Common Use Cases and Queries

Typical uses include engineering reports that list every designator tied to a component, ECO impact analysis showing which designators changed under a given change notice, and integration extracts feeding placement or CAD systems.

A representative query joins the designators to their parent component:

SELECT r.component_reference_designator, r.acd_type, r.change_notice, c.component_item_id
FROM bom.bom_reference_designators r, bom.bom_components_b c
WHERE r.component_sequence_id = c.component_sequence_id
AND c.bill_sequence_id = :bill_sequence_id;

Auditing recently modified designators uses the who-columns:

SELECT component_reference_designator, component_sequence_id, change_notice, last_update_date, last_updated_by
FROM bom.bom_reference_designators
WHERE last_update_date >= :since_date;

Designator counts per component, filtered by type, support placement-density reporting:

SELECT component_sequence_id, acd_type, COUNT(*)
FROM bom.bom_reference_designators
GROUP BY component_sequence_id, acd_type;

Related Objects

• BOM_COMPONENTS_B — the primary parent table; joined via COMPONENT_SEQUENCE_ID. This is the sole documented foreign key target and the anchor of the satellite relationship.
• BOM_REFERENCE_DESIGNATORS_PK / _U1 — the primary key constraint and unique index enforcing designator uniqueness per component and type.
• BOM_BILL_OF_MATERIALS — the bill header chain reached through BOM_COMPONENTS_B, used to scope designators to a specific assembly.
• BOM_INVENTORY_COMPONENTS — the inventory-item view of component lines, frequently joined in reporting.
• ENG_ENGINEERING_CHANGES — the ECO master referenced by CHANGE_NOTICE for revision-controlled updates.
• BOM_ECDIS_CONFIGURATIONS / ECO-related APIs — change-order processing routines that insert and update designator rows.

Access is normally read-only for reporting and integration; inserts and updates should flow through the Bills of Material APIs and concurrent programs to keep the concurrent program context columns and audit trail consistent.