Search Results bne_integrators_b_pk

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:

• INTEGRATOR_CODE and APPLICATION_ID — the compound business key identifying an integrator within its owning application.
• ENABLED_FLAG — controls whether the integrator is active and available to end users.
• UPLOAD_PARAM_LIST_APP_ID / UPLOAD_PARAM_LIST_CODE — the parameter list invoked when a document is uploaded back to the application.
• UPLOAD_SERV_PARAM_LIST_APP_ID / UPLOAD_SERV_PARAM_LIST_CODE — parameters for the server-side upload routine.
• IMPORT_PARAM_LIST_APP_ID / IMPORT_PARAM_LIST_CODE — parameters passed to the import program.
• CREATE_DOC_LIST_APP_ID / CREATE_DOC_LIST_CODE — parameters used when a new document is created.
• SESSION_PARAM_LIST_APP_ID / SESSION_PARAM_LIST_CODE — parameters for session-level initialization.
• UPLOADER_CLASS, LAYOUT_RESOLVER_CLASS, LAYOUT_VERIFIER_CLASS, and SESSION_CONFIG_CLASS — Java classes implementing upload, layout discovery, verification, and session behavior.
• IMPORT_TYPE, DATE_FORMAT, DISPLAY_FLAG, SOURCE, and NEW_SESSION_FLAG — operational attributes governing import execution, workbook formatting, visibility, origin, and session handling.
• OBJECT_VERSION_NUMBER and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE).

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:

• BNE_PARAM_LISTS_B — referenced four times via IMPORT_PARAM_LIST, UPLOAD_PARAM_LIST, UPLOAD_SERV_PARAM_LIST, and CREATE_DOC_LIST column pairs.
• BNE_LAYOUTS_B — layout definitions per integrator (INTEGRATOR_APP_ID, INTEGRATOR_CODE).
• BNE_MAPPINGS_B — column-to-interface mappings per integrator.
• BNE_INTERFACES_B — interface definitions associated with the integrator.
• BNE_IMPORT_PROGRAMS — import program registrations keyed on APPLICATION_ID and INTEGRATOR_CODE.
• BNE_CONTENTS_B, BNE_GRAPHS_B, BNE_MENUS_B, BNE_DUPLICATE_PROFILES_B, BNE_INTEGRATOR_VIEWERS, and BNE_ASYNC_UPLOAD_JOBS — all reference the integrator via INTEGRATOR_APP_ID and INTEGRATOR_CODE.

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