Search Results bne_interface_cols_b_pk

Overview

BNE_INTERFACE_COLS_B is a core definition table in the Oracle E-Business Suite Web Applications Desktop Integrator (BNE) product, the module responsible for spreadsheet-based integration through Oracle Web ADI. The table stores the definition of the individual columns that make up a BNE Interface. Each row describes one column of a given interface, including its data type, validation behavior, display attributes, and mapping properties. The "_B" suffix denotes the base table in a table/view pair typical of Oracle EBS, with a corresponding "_TL" translation table where applicable.

From a data modeling perspective, the mined foreign key structure yields a heuristic Data Vault classification of satellite-leaning. The table depends heavily on BNE_INTERFACES_B as its parent and carries descriptive, versioned configuration attributes rather than acting as an independent hub or a pure transactional link. The primary key is BNE_INTERFACE_COLS_B_PK, composed of APPLICATION_ID, INTERFACE_CODE, and SEQUENCE_NUM. A unique index, BNE_INTERFACE_COLS_B_UK1, extends this with ZD_EDITION_NAME, reflecting the edition-based redefinition support introduced in Oracle Database 11gR2 and used by EBS 12.2.x.

Key Information Stored

The table contains 50 documented columns. The most significant are grouped below.

• Identity and ownership: APPLICATION_ID, INTERFACE_CODE, and SEQUENCE_NUM form the surrogate primary key and tie each column definition to a specific interface. OBJECT_VERSION_NUMBER supports optimistic locking, and ZD_EDITION_NAME supports editioning in 12.2.2.
• Column semantics: INTERFACE_COL_NAME and INTERFACE_COL_TYPE name the column and classify it, while DATA_TYPE and FIELD_SIZE define its storage characteristics. SEGMENT_NUMBER and GROUP_NAME place the column within the interface layout.
• Behavior flags: ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, and MAPPING_ENABLED_FLAG govern how the column behaves during spreadsheet download and upload.
• Validation configuration: VAL_TYPE, VAL_ID_COL, VAL_MEAN_COL, VAL_DESC_COL, VAL_OBJ_NAME, VAL_COMPONENT_APP_ID, VAL_COMPONENT_CODE, VAL_QUERY_APP_ID, and VAL_QUERY_CODE define validation components, lookups, and value-set queries.
• Flexfield support: OA_FLEX_CODE, OA_FLEX_NUM, OA_FLEX_APPLICATION_ID, and OA_CONCAT_FLEX support key and descriptive flexfield integration.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and LAST_UPDATE_DATE follow the standard EBS who-column convention.

Common Use Cases and Queries

Administrators and developers query this table to inspect or troubleshoot Web ADI interface definitions, understand validation logic, and verify column mappings. A typical query lists the enabled columns of a given interface in display order:

SELECT SEQUENCE_NUM, INTERFACE_COL_NAME, DATA_TYPE, FIELD_SIZE,
       REQUIRED_FLAG, DISPLAY_ORDER
FROM   BNE.BNE_INTERFACE_COLS_B
WHERE  APPLICATION_ID = :app_id
AND    INTERFACE_CODE = :iface_code
AND    ENABLED_FLAG = 'Y'
ORDER  BY SEQUENCE_NUM;

A second scenario identifies columns that carry validation components, which aids impact analysis before modifying a value set or component:

SELECT INTERFACE_CODE, INTERFACE_COL_NAME, VAL_TYPE,
       VAL_COMPONENT_APP_ID, VAL_COMPONENT_CODE
FROM   BNE.BNE_INTERFACE_COLS_B
WHERE  VAL_COMPONENT_CODE IS NOT NULL;

Reporting use cases include documenting interface metadata for audit, comparing column definitions across environments, and supporting migration of interface configurations between instances.

Related Objects

The following objects are the most significant dependencies, based on the documented FK relationships.

• BNE_INTERFACES_B — parent table; joined on APPLICATION_ID and INTERFACE_CODE.
• BNE_COMPONENTS_B — referenced via VAL_COMPONENT_APP_ID and VAL_COMPONENT_CODE for validation component definitions.
• BNE_DUP_INTERFACE_COLS — references this table through INTERFACE_APP_ID, INTERFACE_CODE, and INTERFACE_SEQ_NUM.
• BNE_INTERFACE_KEY_COLS — references this table through the same three keys, defining key columns for an interface.
• BNE_LAYOUT_COLS — references this table, defining the layout of interface columns.
• BNE_MAPPING_LINES — references this table, defining mapping relationships between source and target columns.

In addition, VAL_QUERY_APP_ID/VAL_QUERY_CODE and EXPANDED_SQL_QUERY_APP_ID/EXPANDED_SQL_QUERY_CODE reference query definitions stored elsewhere in the BNE schema, supporting value-list and expanded SQL validation for interface columns.