Search Results delete_groups

Overview

APPS.BOM_DELETE_GROUPS_API is a server-side PL/SQL package in Oracle EBS Applications (12.1.1 and 12.2.2) that supports the deletion of Oracle Bills of Material (BOM) entity groups and their associated child records. Its principal purpose is to provide a programmatic entry point for the mass removal of engineering and manufacturing structures—including bills of material, routings, operation sequences, and their dependent transaction and costing records—in a controlled and consistent manner. The package is classified as an API and is owned by the APPS schema, with a status of VALID in the referenced environments. It is referenced by the BOMPCMBM program (BOM deletion concurrent process) and by APPS.BOM_DELETE_GROUPS_API itself, indicating that it forms part of the standard BOM purge and delete infrastructure used to maintain data integrity when removing obsolete or erroneous structures.

Key Procedures and Functions

The documented interface exposes a single entry point:

• DELETE_GROUPS — Deletes a group of BOM entities (and their dependent sub-entities) as identified by the caller. The procedure orchestrates the deletion process across the related BOM and inventory tables and records errors and generated SQL against the supporting delete-tracking tables. It provides the mechanism by which the BOM deletion concurrent program removes a designated set of groups in one controlled operation.

No additional public procedures or functions are documented for this package in the ETRM metadata; the DELETE_GROUPS routine is the sole documented entry point.

Tables Accessed

The package reads from and writes to the following documented tables (via APPS synonyms):

• BOM_DELETE_ENTITIES, BOM_DELETE_SUB_ENTITIES, BOM_DELETE_ERRORS, BOM_DELETE_SQL_STATEMENTS — The working and audit tables for the deletion process, tracking entities, sub-entities, generated SQL, and any errors encountered.
• BOM_OPERATIONAL_ROUTINGS, BOM_OPERATION_SEQUENCES, BOM_PARAMETERS — Routing and parameter definitions associated with the structures being deleted.
• MTL_SYSTEM_ITEMS, MTL_PARAMETERS — Item master and organization parameter information used to validate and scope the deletion.
• MTL_MATERIAL_TRANSACTIONS, MTL_UNIT_TRANSACTIONS, MTL_TRANSACTION_ACCOUNTS, MTL_TRANSACTION_LOT_NUMBERS — Inventory transaction and accounting records linked to the affected items.
• WIP_COST_TXN_INTERFACE — Work in Process costing transaction interface used to handle costing consequences of the deletion.
• FND_ORACLE_USERID — Oracle user identity used for session/audit context.

Usage Notes

BOM_DELETE_GROUPS_API is typically invoked by the BOM deletion concurrent program (BOMPCMBM) rather than directly by end users. It may be called from custom PL/SQL when implementing controlled purge routines, but Oracle generally recommends using the standard BOM deletion concurrent program to preserve referential integrity and audit trails. Because the package manipulates transaction, costing, and routing data, it should be executed only within the supported deletion workflow, after appropriate validation and backup. The tables BOM_DELETE_ERRORS and BOM_DELETE_SQL_STATEMENTS should be reviewed following execution to confirm success and diagnose failures. Package dependencies on SYS.STANDARD reflect standard PL/SQL library usage; the package is not a public form-level API and is intended for batch and administrative use. As with all EBS deletion utilities, it operates under the APPS schema and is subject to standard application security and environment controls.