Search Results delete_group_sequence_id




Overview
Explore in AI Chat

Overview

The BOM_DELETE_GROUPS table is a core data structure within the Bills of Material (BOM) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master definition table for logical groupings of inventory and bill of material entities that are scheduled for deletion. Its primary role is to support the "Mass Change" and "Purge" functionalities, enabling users to organize and manage the deletion of multiple BOMs, routings, and associated inventory items in a controlled, batch-oriented manner. Each record in this table represents a unique delete group, which acts as a container for the specific entities marked for removal.

Key Information Stored

The table's structure is designed to uniquely identify and track each deletion group within a specific organizational context. The critical columns are defined by its primary and unique keys. The DELETE_GROUP_SEQUENCE_ID column is the system-generated, unique primary key (PK) identifier for each group. The combination of DELETE_GROUP_NAME and ORGANIZATION_ID forms a unique key (UK), ensuring that a group name is not duplicated within a single inventory organization. This design enforces data integrity and allows users to reference groups by a meaningful name within their operational unit. Other columns typically include standard WHO columns (CREATION_DATE, CREATED_BY, etc.) for auditing purposes.

Common Use Cases and Queries

The primary use case is the execution and monitoring of mass deletion processes. A user creates a delete group via the EBS interface, which inserts a record into this table. Entities are then added to the group via the related BOM_DELETE_ENTITIES table. Common queries involve auditing and reporting on pending deletion activities. For instance, to list all active delete groups in an organization, one might use:

SELECT DELETE_GROUP_NAME, CREATED_BY, CREATION_DATE
FROM BOM.BOM_DELETE_GROUPS
WHERE ORGANIZATION_ID = :org_id
ORDER BY CREATION_DATE DESC;

Another critical query joins BOM_DELETE_GROUPS with BOM_DELETE_ENTITIES to report on the contents of a specific group before finalizing the purge operation, ensuring the correct items and BOMs are targeted.

Related Objects

The BOM_DELETE_GROUPS table has a direct parent-child relationship with the BOM_DELETE_ENTITIES table, which holds the detailed list of items, BOMs, and other components assigned to a group. The documented foreign key relationship is:

  • BOM_DELETE_ENTITIES references BOM_DELETE_GROUPS via the column BOM_DELETE_ENTITIES.DELETE_GROUP_SEQUENCE_ID. This FK links each entity slated for deletion to its parent group definition.

This table is central to the purge workflow and is typically accessed through dedicated public APIs or the standard EBS forms, rather than via direct DML, to maintain business logic and data consistency.