Search Results bne_interface_keys_pk

Overview

BNE_INTERFACE_KEYS is a metadata table in the BNE schema (Web Applications Desktop Integrator) that defines the logical keys applicable to an interface definition. Within Oracle EBS 12.1.1 and 12.2.2, it acts as the authoritative registry of key structures used by Web ADI integrators to identify, match, and upload records through a defined interface. Each row describes one logical key, identified by a composite of APPLICATION_ID and KEY_CODE, and ties that key to a specific interface via INTERFACE_APP_ID and INTERFACE_CODE.

From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification for BNE_INTERFACE_KEYS. The table carries a composite primary key (APPLICATION_ID, KEY_CODE) and references the parent interface definition in BNE_INTERFACES_B, which is consistent with a descriptive satellite attached to an interface-driven hub/link construct rather than a standalone hub.

Key Information Stored

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

• APPLICATION_ID — Part of the composite primary key (BNE_INTERFACE_KEYS_PK); identifies the owning application context for the key definition.
• KEY_CODE — The other half of the composite primary key; the user-facing identifier for the logical key.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/BC4J framework to manage concurrent updates.
• INTERFACE_APP_ID — Foreign key column pointing to BNE_INTERFACES_B; identifies the interface that owns this key.
• INTERFACE_CODE — Companion column to INTERFACE_APP_ID completing the reference to the parent interface.
• KEY_TYPE — Classifies the nature of the key (for example, primary or alternate).
• KEY_CLASS — Categorizes the key implementation class or purpose used during processing.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns recording row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording last modification.
• ZD_EDITION_NAME — Editioning column supporting Oracle EBS 12.2 online patching; part of the unique index BNE_INTERFACE_KEYS_UK1 along with APPLICATION_ID and KEY_CODE.

The surrogate primary key is the composite (APPLICATION_ID, KEY_CODE). The business-key candidate is captured by the unique index BNE_INTERFACE_KEYS_UK1 (APPLICATION_ID, KEY_CODE, ZD_EDITION_NAME), which mirrors the PK while accounting for editioning.

Common Use Cases and Queries

Typical usage centers on discovering and validating the keys associated with a Web ADI interface. A common query lists all keys for a given interface:

• SELECT key_code, key_type, key_class FROM bne_interface_keys WHERE interface_app_id = :app_id AND interface_code = :code;
• SELECT k.key_code, k.key_type FROM bne_interface_keys k WHERE k.application_id = :app_id AND k.key_code = :key;

Reporting scenarios include auditing which interfaces define logical keys, validating that an interface has at least one key before enabling uploads, and tracing the columns that compose a key through BNE_INTERFACE_KEY_COLS. Administrators investigating upload failures frequently join this table to BNE_INTERFACE_KEY_COLS to confirm that the expected key columns are registered, using the KEY_TYPE and KEY_CLASS values to determine whether the key is treated as primary during record matching.

Related Objects

The following objects are most significant in relation to BNE_INTERFACE_KEYS:

• BNE_INTERFACES_B — Parent interface definition; joined on INTERFACE_APP_ID = BNE_INTERFACES_B.INTERFACE_APP_ID and INTERFACE_CODE = BNE_INTERFACES_B.INTERFACE_CODE.
• BNE_INTERFACE_KEY_COLS — Child table holding the columns that compose each key; references BNE_INTERFACE_KEYS on APPLICATION_ID and KEY_CODE.
• BNE_INTERFACE_KEYS_PK — Primary key constraint over (APPLICATION_ID, KEY_CODE).
• BNE_INTERFACE_KEYS_UK1 — Unique index over (APPLICATION_ID, KEY_CODE, ZD_EDITION_NAME), enforcing business uniqueness under editioning.
• Web ADI integrator APIs and setup pages that read these metadata tables when building and validating an integrator definition.