Search Results bne_interface_cols_b




Overview
Explore in AI Chat

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.

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.