Results for “bom_alternate_designators”

50+ results




Overview
Explore in AI Chat

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

Overview

BOM_ALTERNATE_DESIGNATORS is a reference table in the Oracle Bills of Material (BOM) schema that defines the alternate designators available for a given organization. An alternate designator is a short code (for example, "ALTERNATE1" or a user-defined value like "SUB") that allows a single item to carry more than one bill of material, routing, or component specification. In Oracle EBS 12.1.1 and 12.2.2, this construct is central to managing alternate BOMs and alternate routings, where the same assembly must be built or costed using different structures depending on plant, volume, or process conditions. This table also enables component substitution on a bill by tagging component lines with an alternate designator so that an alternate component is used only when the corresponding alternate is selected.

The table is owned by the BOM schema and is marked VALID across both releases. It contains 32 documented columns in the 12.2.2 physical schema. Under a heuristic Data Vault classification, this object is hub-leaning: it holds a stable, uniquely identified set of alternate designator definitions with limited mutability, which suggests modeling it as a hub keyed on the business identifier (the alternate designator code plus organization).

Key Information Stored

The primary key is BOM_ALTERNATE_DESIGNATORS_PK, defined on ALTERNATE_DESIGNATOR_CODE and ORGANIZATION_ID. A second unique index, BOM_ALTERNATE_DESIGNATORS_U1, spans ALTERNATE_DESIGNATOR_CODE, ORGANIZATION_ID, and ZD_EDITION_NAME, reflecting the multi-tenant editioning column introduced in 12.2. Together these columns act as the business-key candidate; there is no separate surrogate key documented, so the two-part composite is itself the identifying key.

  • ALTERNATE_DESIGNATOR_CODE — the user-visible alternate designator (part of the primary key).
  • ORGANIZATION_ID — the inventory organization to which the designator applies; alternate designators are organization-specific.
  • DESCRIPTION — free-text description of the alternate designator's purpose.
  • DISABLE_DATE — the date the alternate designator becomes inactive, supporting lifecycle control without deletion.
  • STRUCTURE_TYPE_ID — foreign key to BOM_STRUCTURE_TYPES_B, indicating the structure type (such as BOM or routing) the designator applies to.
  • IS_PREFERRED — flag marking the default or preferred alternate designator for the organization.
  • ZD_EDITION_NAME — the edition used for online patching and multi-tenant support in 12.2.
  • Standard WHO/audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN track the record's history.
  • Concurrent request columns — REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE identify the concurrent program that created or last modified the record.

Common Use Cases and Queries

Typical uses include listing valid alternate designators per organization, resolving the code referenced by a BOM or routing, and reporting on active versus disabled designators. A common query joins to MTL_PARAMETERS to confirm the organization, or filters by DISABLE_DATE to exclude retired entries:

  • SELECT a.alternate_designator_code, a.description, a.disable_date FROM bom.bom_alternate_designators a WHERE a.organization_id = :org_id AND (a.disable_date IS NULL OR a.disable_date > SYSDATE);
  • SELECT b.bill_sequence_id, b.alternate_bom_designator FROM bom.bom_bill_of_materials b WHERE b.organization_id = :org_id AND b.alternate_bom_designator IS NOT NULL;
  • Identify the preferred designator: WHERE is_preferred = 'Y'.

Because the table is a low-volume reference set, it is frequently used as a lookup source for BI Publisher reports and existing SRS concurrent program outputs that present alternate BOM and routing structures.

Related Objects

The following depend on or reference BOM_ALTERNATE_DESIGNATORS, matched on ALTERNATE_DESIGNATOR_CODE and ORGANIZATION_ID where the metadata specifies:

Together these relationships position BOM_ALTERNATE_DESIGNATORS as a foundational reference hub for alternate BOM and routing functionality across the BOM and Flow Manufacturing modules.