Search Results bne_interfaces_vl




Overview
Explore in AI Chat

Overview

BNE_INTERFACES_VL is a standard translation (VL) view owned by the APPS schema in Oracle E-Business Suite. It is delivered as part of the BNE product, Web Applications Desktop Integrator (Web ADI), and is documented as VALID in ETRM for both 12.1.1 and 12.2.2. The view exposes interface definition metadata that Web ADI uses to describe the integrators, upload mechanisms, and parameter lists available to end users when they create or upload desktop integration documents.

Because BNE_INTERFACES_VL is a translation view, it presents the current session's language-specific descriptive text alongside the language-independent interface definition. It is the reporting and querying entry point for interface metadata: rather than joining the base and translation tables manually, developers and administrators select from this view to obtain interface names and codes in the user's language. The view is read-only in practice and is not intended for direct DML.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed through synonyms in the APPS schema:

  • BNE_INTERFACES_B — the base (language-independent) table holding application identifiers, interface codes, versioning and integrator attributes, upload configuration, and standard WHO audit columns.
  • BNE_INTERFACES_TL — the translation table holding the language-specific interface name (USER_NAME) keyed by APPLICATION_ID, INTERFACE_CODE, and LANGUAGE.

The join condition matches the base and translation rows on APPLICATION_ID and INTERFACE_CODE, with the translation restricted to the session language via USERENV('LANG'). The view text also carries ROWID from the base table as ROW_ID. This structure means one logical interface definition can surface multiple translated rows in the underlying tables, but the view returns only the row matching the current language environment.

Key Columns

Common Use Cases and Queries

Typical uses include inventorying Web ADI interfaces, tracing which parameter list an interface's upload uses, and building custom reports or validation logic around interface configuration.

List all interfaces with their upload parameter list:

  • SELECT interface_code, interface_name, upload_param_list_app_id, upload_param_list_code FROM bne_interfaces_vl ORDER BY interface_code;

Filter by a specific parameter list code, matching the user's search term:

  • SELECT interface_code, interface_name, upload_type, upload_param_list_code FROM bne_interfaces_vl WHERE upload_param_list_code = :p_code;

Join to the integrator to view interface context:

  • SELECT v.interface_code, v.interface_name, v.integrator_code FROM bne_interfaces_vl v WHERE v.integrator_code = :p_integrator;

Because the view filters by USERENV('LANG'), results reflect the language of the querying session; ensure NLS settings are set as expected when comparing output across environments.