Search Results bom_parameters

Overview

The BOM_PARAMETERS table is a critical control table within the Oracle E-Business Suite Bills of Material (BOM) module. It functions as a repository for organization-level manufacturing and engineering parameters. Each record in this table defines the default behaviors, statuses, and control values for bill of material and engineering change order (ECO) transactions within a specific inventory organization. Its configuration directly influences the functionality of the BOM and Engineering modules, making it a foundational setup object for manufacturing implementations.

Key Information Stored

The table stores a single row of configuration parameters per inventory organization. While the full column list is extensive, key columns typically include ORGANIZATION_ID (the primary key), and various parameters controlling default behavior. Crucially, based on the provided metadata, it includes BOM_DELETE_STATUS_CODE. This column holds a status code that determines which item statuses are permitted for deletion of components from a bill. This code is validated against the MTL_ITEM_STATUS table via a foreign key constraint, directly linking BOM functionality to the item status control framework searched for by the user.

Common Use Cases and Queries

This table is primarily referenced during BOM and ECO transactions to validate actions against the organization's rules. A common use case is determining valid component deletion statuses, as indicated by the foreign key. Administrators or custom reports may query this table to audit or document the BOM setup for an organization. A typical query would join to HR_ORGANIZATION_UNITS to retrieve the organization name.

• Sample Query to View Parameters: SELECT bp.*, hou.NAME org_name FROM BOM.BOM_PARAMETERS bp, HR_ORGANIZATION_UNITS hou WHERE bp.ORGANIZATION_ID = hou.ORGANIZATION_ID;
• Use Case: Troubleshooting why a component cannot be deleted from a bill by checking the allowed status code against the item's current status.

Related Objects

The BOM_PARAMETERS table has defined relationships with several other EBS objects. As documented in the provided metadata, it has a primary key constraint (BOM_PARAMETERS_PK) on ORGANIZATION_ID. The explicitly listed foreign key relationship is:

• Foreign Key to MTL_ITEM_STATUS: The column BOM_PARAMETERS.BOM_DELETE_STATUS_CODE references the MTL_ITEM_STATUS table. This enforces that the status code configured for BOM component deletion must be a valid, predefined item status. This is the direct link to the object referenced in the user's search.

In practice, it is also commonly joined with MTL_PARAMETERS for comprehensive organization setup and is referenced by various BOM_* and ENG_* forms, reports, and APIs to enforce business rules.