Search Results bne_interface_cols_b_n3

Overview

BNE.BNE_INTERFACE_COLS_B is a transactional definition table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. It stores the definition of an individual column within an interface, providing the metadata layer that governs how the E-Business Suite Technology Reference Model (ETRM) components describe, validate, display, and map data for a given interface. Each row defines a single interface column, including its name, type, data type, size, validation behavior, and display characteristics.

The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10. Its live indexes are held in APPS_TS_TX_IDX. The object is owned by the BNE schema and is registered as FND Design Data under BNE.BNE_INTERFACE_COLS_B. Status is VALID.

Using the heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as satellite-leaning. It carries descriptive attributes that depend on the parent interface definition rather than acting as a standalone hub, and its relationships to interface components and validation elements reinforce its role as a dependent descriptive entity.

Key Information Stored

The primary key for this table is BNE_INTERFACE_COLS_B_PK, defined on the columns APPLICATION_ID, INTERFACE_CODE, and SEQUENCE_NUM. The most important business-key candidate is the unique index BNE_INTERFACE_COLS_B_UK1, defined on APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, and ZD_EDITION_NAME. This composite uniqueness ensures that a given interface column sequence cannot be duplicated within the same application and interface for a given edition.

Key columns include:

• APPLICATION_ID — the application identifier, a foreign key to FND_APPLICATIONS.APPLICATION_ID.
• INTERFACE_CODE — the code identifying the entity for the given APPLICATION_ID, with a foreign key to BNE_INTERFACES.INTERFACE_CODE.
• SEQUENCE_NUM — a unique number identifying the interface column.
• INTERFACE_COL_TYPE — interface column type; valid values are 1 for physical column and 2 for alias column.
• INTERFACE_COL_NAME — the name of the interface column, usually corresponding to an open interface table column.
• DATA_TYPE — the data type of the column; valid values are 1 for Number, 2 for String, and 3 for Date.
• FIELD_SIZE — the size of the column in the interface.
• ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, MAPPING_ENABLED_FLAG — behavioral flags governing enablement, upload requirement, display, read-only status, nullability, summarization, and text import mapping.
• DEFAULT_TYPE and DEFAULT_VALUE — default handling for the interface column.
• OBJECT_VERSION_NUMBER — the object version number used for optimistic locking.

The table contains 50 documented columns. Additional columns cover validation components, validation queries, flexfield configuration, LOV behavior, and display ordering, but the columns above represent the core definitional payload.

Common Use Cases and Queries

This table is typically queried when diagnosing interface configuration, column mappings, or load failures. A common pattern retrieves all enabled and required columns for an interface:

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

Reporting use cases include auditing interface column definitions across applications, verifying that a given open interface table column is correctly configured, and reviewing display order or LOV settings. Because the unique index BNE_INTERFACE_COLS_B_UK1 includes ZD_EDITION_NAME, queries focused on edition-aware environments should consider this column to avoid ambiguity between editions. Validation-related columns can be filtered through BNE_INTERFACE_COLS_B_N1, and query-based validation through BNE_INTERFACE_COLS_B_N2 and BNE_INTERFACE_COLS_B_N3.

Related Objects

The following related objects are significant when working with BNE_INTERFACE_COLS_B:

• BNE_INTERFACES_B — the parent interface definition, joined on APPLICATION_ID and INTERFACE_CODE through the foreign key from this table.
• BNE_COMPONENTS_B — referenced through VAL_COMPONENT_APP_ID and VAL_COMPONENT_CODE for validation component lookups.
• BNE_DUP_INTERFACE_COLS — references this table through INTERFACE_APP_ID.
• BNE_INTERFACE_KEY_COLS — references this table through INTERFACE_APP_ID.
• BNE_LAYOUT_COLS — references this table through INTERFACE_APP_ID.
• BNE_MAPPING_LINES — references this table through INTERFACE_APP_ID.

These relationships make BNE_INTERFACE_COLS_B a central definitional reference for interface layout, key columns, duplicate handling, and mapping behavior within the BNE schema.