Search Results bom_cmp_usr_attr_interface




Overview
Explore in AI Chat

Overview

The BOM.BOM_CMP_USR_ATTR_INTERFACE table is an open-interface (staging) table within the Oracle Bills of Material module. It serves as the inbound collection point for user-defined component attribute values that are destined for the Bills of Material component records. Instead of writing directly into the production component tables, external systems, custom programs, or data-conversion routines populate this interface table, and the standard Bills of Material interface concurrent programs subsequently validate and import the staged rows into the base component attribute tables. The table therefore plays a pivotal role in integrations, bulk data loads, and conversions that must carry customer-specific component attributes into Oracle EBS 12.1.1 or 12.2.2 without disrupting referential integrity in the operational schema.

Applying a heuristic Data Vault classification to this object, the structure most closely resembles a satellite. The table holds descriptive attribute values (the string, numeric, and date variants of user attributes) plus audit and processing metadata, all keyed by a business key rather than acting as an independent hub or link. This classification is a modeling suggestion derived from the FK and index structure and should not be interpreted as an enforced design constraint.

Key Information Stored

The table contains 41 documented columns. The most significant are summarized below.

The table has no documented surrogate primary key column; the unique index BOM_CMP_USR_ATTR_INTERFACE_U1 covers (DATA_SET_ID, ROW_IDENTIFIER, ATTR_INT_NAME, ASSEMBLY_ITEM_NUMBER, ITEM_NUMBER, ATTR_GROUP_INT_NAME, ORGANIZATION_ID) and acts as the business-key candidate.

Common Use Cases and Queries

Typical usage centers on validating and monitoring staged data before and after interface execution. A common query checks the processing state of a load batch:

  • SELECT DATA_SET_ID, PROCESS_STATUS, COUNT(*) FROM BOM.BOM_CMP_USR_ATTR_INTERFACE GROUP BY DATA_SET_ID, PROCESS_STATUS;
  • SELECT * FROM BOM.BOM_CMP_USR_ATTR_INTERFACE WHERE PROCESS_STATUS = 'ERROR' AND DATA_SET_ID = :dataset;
  • Correlating rows with the parent concurrent request using REQUEST_ID to diagnose import failures.

Reporting use cases include auditing which user attribute values were supplied for a given assembly/component combination, and reconciling source-system references (COMP_SOURCE_SYSTEM_REFERENCE, SOURCE_SYSTEM_ID) against the source extract.

Related Objects

The primary documented relationship is the foreign key from STRUCTURE_TYPE_ID to BOM_STRUCTURE_TYPES_B, which defines the bill structure type. Interface programs also write to and read from the base component attribute and component tables, and the standard Bill of Materials open interface concurrent programs orchestrate the import. Significant related objects include BOM_STRUCTURE_TYPES_B (structure type lookup), the Bill of Materials component interface tables, the component user-attribute base tables, and the open-interface concurrent programs that validate PROCESS_STATUS and TRANSACTION_TYPE. Because the table is classified as standalone in the mined relationship data, most joins are made on business columns (ASSEMBLY_ITEM_NUMBER, ITEM_NUMBER, ORGANIZATION_ID) rather than on enforced foreign keys.