Search Results bom_interface_delete_groups_u1




Overview
Explore in AI Chat

Overview

BOM.BOM_INTERFACE_DELETE_GROUPS is a configuration and reference table within the Oracle E-Business Suite (EBS) Bills of Material (BOM) module, present through releases 12.1.1 and 12.2.2. The table stores the default delete group names applied by the Bill, Routing, and ECO Open Interfaces when those programs are instructed to delete bills, components, routings, or operations. Rather than mandating that a caller supply a delete group at execution time, the open interfaces resolve the appropriate group name from this table according to the entity being processed. The table therefore acts as a lightweight control mechanism that governs how interface records are grouped for deletion.

From a modeling perspective, the mined relationship data classifies this object as standalone, with no foreign key dependencies to or from other database objects. In Data Vault terms it may be modeled as a hub candidate, since ENTITY_NAME serves as the natural business key and no dependent descriptive history is decomposed into separate satellites in the supplied metadata. This is a modeling suggestion only; the physical table is a conventional EBS setup table.

Key Information Stored

The table is deliberately narrow, comprising only three documented columns, and its content is essentially static reference data seeded at implementation and maintained only when delete-group conventions change.

Because ENTITY_NAME is both the surrogate primary key and the unique-indexed business key, the table has a single-row-per-entity granularity with no composite keys to resolve.

Common Use Cases and Queries

Administrators and technical consultants consult this table when diagnosing why an open interface deletion selected, or failed to select, a given set of records, and when adjusting default grouping behavior before running the Bill, Routing, or ECO Open Interfaces. A standard reference query returns the complete configuration:

SELECT ENTITY_NAME, DELETE_GROUP_NAME, DESCRIPTION
FROM BOM.BOM_INTERFACE_DELETE_GROUPS;

A targeted lookup for a single entity is equally common, for example retrieving the delete group applied to inventory component deletions:

SELECT DELETE_GROUP_NAME
FROM BOM.BOM_INTERFACE_DELETE_GROUPS
WHERE ENTITY_NAME = 'BOM_INVENTORY_COMPS_INTERFACE';

Reporting use cases include auditing which entities have delete groups defined, validating that all four permitted entity types are represented, and cross-checking the configured names against the values actually written into the corresponding interface tables during a deletion run.

Related Objects

The ETRM metadata records no foreign key relationships for BOM_INTERFACE_DELETE_GROUPS, and the object neither references nor is referenced by other database objects. The following related objects are therefore identified functionally, based on the entity names stored in this table rather than on FK constraints.

  • BOM_BILL_OF_MTLS_INTERFACE — Bill of Material interface table; consumes the delete group for bill deletions.
  • BOM_INVENTORY_COMPS_INTERFACE — Component interface table; consumes the delete group for component deletions.
  • BOM_OP_ROUTINGS_INTERFACE — Routing interface table; consumes the delete group for routing deletions.
  • BOM_OP_SEQUENCES_INTERFACE — Operation sequence interface table; consumes the delete group for operation deletions.
  • BOM.BOM_INTERFACE_DELETE_GROUPS_U1 — Unique index on ENTITY_NAME that enforces the business key.

No public API or view is documented as depending on this table; its role is confined to supplying default delete group names to the BOM open interface programs.