Search Results bne_integrators_b




Overview
Explore in AI Chat

Overview

BNE_INTEGRATORS_B is the definition table for Integrators within the Oracle E-Business Suite Web Applications Desktop Integrator (BNE) module. An Integrator in EBS Desktop Integration is the metadata object that binds a spreadsheet-based interface to an Oracle Forms or OAF application, defining how a user creates, uploads, imports, and validates documents such as journals, invoices, or budgets. Each row in BNE_INTEGRATORS_B describes one supported integration, including which parameter lists drive the upload and import program calls, which Java classes resolve and verify layouts, and how date values are formatted in the generated workbook.

The table is owned by the BNE schema and is present and VALID in both 12.1.1 and 12.2.2. The documented 12.2.2 physical schema contains 29 columns and is protected by the primary key constraint BNE_INTEGRATORS_B_PK, defined on the compound business identifiers INTEGRATOR_CODE and APPLICATION_ID. A unique index, BNE_INTEGRATORS_B_UK1, additionally enforces uniqueness on APPLICATION_ID, INTEGRATOR_CODE, and ZD_EDITION_NAME, reflecting the multi-edition (ZD) support introduced in 12.2.x. From a Data Vault modeling perspective, the FK topology mined from the ETRM metadata classifies this object as hub-leaning: it owns the natural business key of an integrator while serving as the parent of numerous satellite-style detail tables.

Key Information Stored

The most consequential columns include:

Common Use Cases and Queries

Typical uses include enumerating active integrators for a given application, resolving the parameter lists that drive an upload, and auditing which Java handler classes are wired to a given integration. A representative query listing enabled integrators:

SELECT i.integrator_code, i.application_id, i.enabled_flag,
  i.uploader_class, i.import_type, i.date_format
FROM bne_integrators_b i
WHERE i.enabled_flag = 'Y'
ORDER BY i.application_id, i.integrator_code;

Joining to the parameter lists to inspect upload wiring:

SELECT i.integrator_code, p.param_list_code, p.param_list_app_id
FROM bne_integrators_b i, bne_param_lists_b p
WHERE i.upload_param_list_app_id = p.param_list_app_id
  AND i.upload_param_list_code = p.param_list_code;

Integration developers also reference this table when troubleshooting Desktop Integration failures, confirming that the correct resolver/verifier classes and parameter lists are registered for the document type in use.

Related Objects

BNE_INTEGRATORS_B is a parent to a broad set of dependent tables and a child of parameter list definitions:

Collectively these relationships establish BNE_INTEGRATORS_B as the central hub of Desktop Integrator configuration metadata.