Search Results bom_interface_delete_groups

Overview

BOM_INTERFACE_DELETE_GROUPS is a reference table in the Oracle Bills of Material (BOM) module. It stores the delete group names used by the Bill, Routing, and Engineering Change Order (ECO) Open Interfaces. When interface data is loaded through the BOM Open Interfaces, the interface processes need a controlled way to identify and subsequently remove batches of records that have already been processed, purged, or rolled back. This table provides the naming registry that those delete operations reference, ensuring that deletion requests are consistently grouped and traceable.

The table resides in the BOM schema and is classified as VALID in the ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2. Its documented physical schema shows three columns and a single-column primary key. ETRM's heuristic Data Vault classification places this object as standalone, meaning it is modeled as an independent hub-like entity rather than a link or satellite. This classification is a modeling suggestion: the table does not participate in foreign-key relationships with other documented objects, and its business identity is captured entirely within its own primary key column, ENTITY_NAME.

Key Information Stored

The documented metadata identifies exactly three columns in BOM_INTERFACE_DELETE_GROUPS. The most important are:

• ENTITY_NAME — The primary key column, defined by the constraint BOM_INTERFACE_DELETE_GROUPS_PK. It also serves as the business-key candidate through the unique index BOM_INTERFACE_DELETE_GROUPS_U1. ENTITY_NAME identifies the interface entity type (for example, a Bill, Routing, or ECO interface) to which a given delete group applies.
• DELETE_GROUP_NAME — The name of the delete group associated with the entity. This is the value supplied to the interface deletion logic to select the set of interface records to remove.
• DESCRIPTION — A descriptive label for the entity or delete group, used for documentation and reporting purposes.

Because ENTITY_NAME is both the primary key and the sole unique-index business key, there is no separate surrogate key column in the documented schema. The primary key is the business key, which reinforces the standalone classification: identity is intrinsic to the entity name, not generated.

Common Use Cases and Queries

The table is typically accessed during interface administration and troubleshooting. A common scenario is verifying which delete groups exist before invoking a purge of Bill, Routing, or ECO interface data. A simple lookup returns the available groups:

SELECT entity_name, delete_group_name, description FROM bom.bom_interface_delete_groups ORDER BY entity_name;

A more targeted query retrieves the delete group for a specific entity:

SELECT delete_group_name FROM bom.bom_interface_delete_groups WHERE entity_name = :p_entity_name;

Because the primary key is ENTITY_NAME, joins to interface tables are performed on the entity name or on the delete group name rather than through a foreign key. Reporting use cases include auditing which delete groups have been defined, confirming naming conventions across environments, and documenting the interface entities configured in a given instance. The table is generally small and read-mostly; it is populated by Oracle setup or upgrade scripts and consulted at runtime by the Open Interface concurrent programs.

Related Objects

ETRM documents no foreign-key relationships for BOM_INTERFACE_DELETE_GROUPS; the relationship data explicitly marks it as standalone. The objects most commonly associated with it are the interface and Open Interface entities whose delete groups it names, together with the BOM Open Interface tables and the concurrent programs that consume the delete group values. Practically, the dependent objects include:

• The Bill of Material Open Interface tables (for example, BOM_BILL_OF_MATERIALS_INTERFACE and BOM_INVENTORY_COMPONENTS_INTERFACE), whose records are deleted by group.
• The Routing Open Interface tables used by the routing load and purge processes.
• The ECO (Engineering Change Order) Open Interface tables.
• The BOM Open Interface concurrent programs and their parameter lists, which accept an entity or delete group name matching ENTITY_NAME or DELETE_GROUP_NAME.

No view or synonym dependencies are documented in the ETRM excerpt. Administrators should treat this table as a configuration reference rather than a transactional interface table, and should avoid direct DML unless instructed by Oracle support.