Search Results bne_interface_key_cols_n1

Overview

BNE.BNE_INTERFACE_KEY_COLS is a metadata configuration table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, owned by the BNE schema. It stores the definition of logical key columns used by the ETRM (Enterprise Transaction Resource Model) integration framework. In practical terms, this table describes how the set of columns that uniquely identify a business entity or interface record is composed, allowing the ETRM interface engine to know which columns form the key for each interface and application.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is link. This suggests the table functions as a connecting structure, resolving associations between applications, key codes, interface columns, and sequence ordering rather than acting as an independent hub or a descriptive satellite. Its physical storage resides in the APPS_TS_TX_DATA tablespace, with associated indexes placed in APPS_TS_TX_IDX.

Key Information Stored

The table contains 13 documented columns. The most significant columns are described below:

• APPLICATION_ID (NUMBER 15) — Application identifier, forming the first component of the composite primary key and referencing FND_APPLICATIONS.APPLICATION_ID.
• KEY_CODE (VARCHAR2 30) — Unique code identifying the entity for a given APPLICATION_ID; the second component of the primary key.
• SEQUENCE_NUM (NUMBER 15) — Ordered sequence number of the key column; the third component of the primary key.
• INTERFACE_APP_ID (NUMBER 15) — The interface application identifier to which this key belongs.
• INTERFACE_CODE (VARCHAR2 30) — The interface code associated with the key definition.
• INTERFACE_SEQ_NUM (NUMBER 15) — Sequence number tied to the interface code.
• OBJECT_VERSION_NUMBER (NUMBER 15) — Standard object version number used for optimistic locking.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — Standard WHO audit columns capturing row creation and update metadata.
• ZD_EDITION_NAME — Editioning column documented in the 12.2.2 physical schema, supporting edition-based redefinition.

The surrogate primary key is BNE_INTERFACE_KEY_COLS_PK (APPLICATION_ID, KEY_CODE, SEQUENCE_NUM). The business-key candidate is the unique index BNE_INTERFACE_KEY_COLS_UK1 on (APPLICATION_ID, KEY_CODE, SEQUENCE_NUM, ZD_EDITION_NAME), which the user searched for directly. A non-unique index, BNE_INTERFACE_KEY_COLS_N1, exists on (INTERFACE_APP_ID, INTERFACE_CODE, INTERFACE_SEQ_NUM) to support interface-oriented lookups.

Common Use Cases and Queries

Typical use cases include diagnosing interface key definitions, verifying that a given interface is configured with the expected key columns, and auditing sequence ordering for composite keys. Developers and support analysts frequently query this table when troubleshooting ETRM integration failures caused by mismatched or missing keys.

A representative query retrieving key definitions for an application:

• SELECT APPLICATION_ID, KEY_CODE, SEQUENCE_NUM, INTERFACE_APP_ID, INTERFACE_CODE FROM BNE.BNE_INTERFACE_KEY_COLS WHERE APPLICATION_ID = :app_id ORDER BY KEY_CODE, SEQUENCE_NUM;
• SELECT * FROM BNE.BNE_INTERFACE_KEY_COLS WHERE INTERFACE_CODE = :iface_code;

Reporting scenarios include building a catalog of interface keys for documentation, cross-referencing key codes against active interfaces, and validating the integrity of the unique index BNE_INTERFACE_KEY_COLS_UK1.

Related Objects

The following objects are most significant in relation to this table:

• BNE.BNE_INTERFACE_KEYS — Referenced by BNE_INTERFACE_KEY_COLS.APPLICATION_ID; the parent definition of interface keys.
• BNE.BNE_INTERFACE_COLS_B — Referenced by BNE_INTERFACE_KEY_COLS.INTERFACE_APP_ID; holds interface column definitions.
• FND_APPLICATIONS — Source of APPLICATION_ID values.
• FND_USER — Referenced by CREATED_BY and LAST_UPDATED_BY.
• FND_LOGINS — Referenced by LAST_UPDATE_LOGIN.
• The BNE_INTERFACE_KEY_COLS_PK, BNE_INTERFACE_KEY_COLS_UK1, and BNE_INTERFACE_KEY_COLS_N1 indexes, which enforce and support access paths on this table.

Together these objects define how ETRM identifies and drives interface transactions within Oracle EBS.