Results for “bom_delete_status_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BOM_PARAMETERS is a reference configuration table in the Oracle Bills of Material (BOM) module, owned by the BOM schema. It stores the organization-level parameter settings that control how bills of material, routings, configurations, and related supply chain rollups are processed within Oracle E-Business Suite 12.1.1 and 12.2.2. Rather than holding transactional structure lines, the table acts as a control record: one row per inventory organization defines default behavior for BOM processing, configuration numbering, deletion status handling, and phantom routing treatment.

Because the table stores descriptive, per-organization behavioral settings keyed to an inventory organization, it is best modeled as a satellite entity in Data Vault terms. Each record depends on an organization hub, and the table carries no independent many-to-many resolution role, which supports the satellite-leaning classification suggested by the foreign key structure.

Key Information Stored

The table contains 56 columns in the documented 12.2.2 schema. The most operationally significant fields are:

• ORGANIZATION_ID — The sole primary key column within BOM_PARAMETERS_PK, identifying the inventory organization whose parameters are defined. It is also the business-key candidate exposed through the unique index BOM_PARAMETERS_U1.
• MAXIMUM_BOM_LEVEL — Defines the maximum allowable depth for a bill of material structure, controlling explosion and rollup behavior.
• CONFIG_SEGMENT_NAME — Specifies the segment used when generating configuration item numbers.
• CONFIG_NUMBER_METHOD_TYPE — Determines the numbering method applied to configured items.
• BOM_DELETE_STATUS_CODE — Foreign key referencing MTL_ITEM_STATUS, governing the item status applied when BOM components are deleted.
• CREATE_CONFIG_BOM — Controls whether a configuration BOM is automatically created.
• INCLUDE_MODELS_IN_ROLLUP — Indicates whether model items participate in cost rollups.
• USE_PHANTOM_ROUTINGS and INHERIT_PHANTOM_OP_SEQ — Govern phantom routing usage and operation sequence inheritance.
• ENABLE_LOWER_LEVEL_SUPPLY — Enables lower-level supply sourcing behavior.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15, GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1–20 — Descriptive flexfield storage.

Common Use Cases and Queries

Typical usage centers on validating or auditing organization-level BOM configuration. Reporting queries retrieve parameter settings for a given organization, often joined to MTL_PARAMETERS or ORG_ORGANIZATION_DEFINITIONS for context.

• Retrieve BOM parameters for a specific organization:

  SELECT organization_id, maximum_bom_level, config_segment_name, bom_delete_status_code FROM bom.bom_parameters WHERE organization_id = :org_id;

• Audit configuration control flags across organizations:

  SELECT organization_id, create_config_bom, include_models_in_rollup, use_phantom_routings FROM bom.bom_parameters;

• Resolve the item status applied on BOM deletion by joining to MTL_ITEM_STATUS on BOM_DELETE_STATUS_CODE.
• Detect organizations lacking a parameter row as part of implementation health checks.

Related Objects

• MTL_ITEM_STATUS — Referenced by BOM_PARAMETERS.BOM_DELETE_STATUS_CODE; provides the item status definition applied during BOM deletion.
• MTL_PARAMETERS — Shares the ORGANIZATION_ID key and supplies complementary inventory organization defaults.
• ORG_ORGANIZATION_DEFINITIONS — Resolves ORGANIZATION_ID to organization name and code.
• BOM_BILL_OF_MATERIALS — Consumes the maximum level and rollup parameters defined here.
• BOM_STRUCTURES_B — Affected by phantom and delete-status parameters.
• BOM_ROUTINGS_B — Influenced by phantom routing parameters.
• CST_ROLLUP_GROUPS / CST_ITEM_COSTS — Dependent on rollup-related parameter flags.