Search Results bne_interfaces_b




Overview
Explore in AI Chat

Overview

BNE_INTERFACES_B is the foundational definition table for interfaces within Oracle EBS Web Applications Desktop Integrator (BNE). Each row represents a single interface belonging to an Integrator — the logical container that groups the interface's columns, keys, layouts, mappings, and upload parameters. In the ETRM 12.2.2 schema the table resides in the BNE schema and is classified as VALID, comprising 17 documented columns. Primary key BNE_INTERFACES_B_PK is defined on (APPLICATION_ID, INTERFACE_CODE).

The heuristic Data Vault classification for this object is hub-leaning: it carries the durable business key (APPLICATION_ID, INTERFACE_CODE) that anchors interface identity and is referenced by many dependent satellites and link tables. This classification should be treated as a modeling suggestion rather than a physical constraint.

Key Information Stored

The most operationally significant columns are:

The unique index BNE_INTERFACES_B_UK1 on (APPLICATION_ID, INTERFACE_CODE, ZD_EDITION_NAME) reinforces that the business key is unique across editions and is the strongest candidate for logical key modeling.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include enumerating all interfaces for an Integrator, tracing upload configuration, and validating that interfaces have associated columns, keys, or layouts.

  • List interfaces by Integrator: SELECT interface_code, interface_name FROM bne_interfaces_b WHERE integrator_app_id = :app_id AND integrator_code = :code;
  • Find interfaces missing column definitions by left-joining to BNE_INTERFACE_COLS_B on (APPLICATION_ID, INTERFACE_CODE).
  • Report upload sequencing: order results by UPLOAD_ORDER within an Integrator.
  • Audit recent changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.

These patterns support Web ADI troubleshooting, integration inventory reporting, and impact analysis prior to patching interface definitions.

Related Objects

The most significant related objects, based on documented foreign key relationships, are:

Together these objects form the interface metadata model underpinning Web ADI integration and upload processing.