Search Results bne_duplicate_profiles_b_uk1

Overview

BNE.BNE_DUPLICATE_PROFILES_B is a transactional configuration table in the Oracle E-Business Suite BNE (Business Event / integrator) schema. It stores the definition of a duplicate upload profile, the reusable rule set that governs how the integrator detects and rejects previously processed interface records during inbound data loads. Each row defines one profile, scope-limited to a single Oracle application and identified by a user-assigned code.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its supporting indexes reside in APPS_TS_TX_IDX. It is registered as FND Design Data under BNE.BNE_DUPLICATE_PROFILES_B and carries a VALID status. In Data Vault modeling terms, the metadata's heuristic classification is satellite-leaning: the table hangs off the integrator definition and the owning application, carrying descriptive attributes rather than defining an independent business entity. The physical schema documents 11 columns, including the ZD_EDITION_NAME editioning column introduced in the 12.2.x architecture.

Key Information Stored

The composite primary key, BNE_DUPLICATE_PROFILES_B_PK, is formed from APPLICATION_ID and DUP_PROFILE_CODE. The unique index BNE_DUPLICATE_PROFILES_B_UK1 — the object of the user's search — covers APPLICATION_ID, DUP_PROFILE_CODE, and ZD_EDITION_NAME, enforcing uniqueness at the application-plus-profile-code grain within each edition. A second index, BNE_DUPLICATE_PROFILES_B_N1, is non-unique on INTEGRATOR_APP_ID and INTEGRATOR_CODE. The most significant columns are:

• APPLICATION_ID — numeric application identifier, foreign key to FND_APPLICATIONS. Part of the primary key; scopes the profile to one application.
• DUP_PROFILE_CODE — VARCHAR2(30) unique code identifying the entity for the given APPLICATION_ID. The user-facing business key.
• INTEGRATOR_APP_ID — application identifier of the integrator this profile serves; foreign key to BNE_INTEGRATORS_B.
• INTEGRATOR_CODE — VARCHAR2(30) integrator code of the integrator this profile serves.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the framework to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — the standard WHO audit columns (foreign keys to FND_USER and FND_LOGINS) recording row provenance and change history.

Common Use Cases and Queries

The primary operational use is diagnostic: identifying which duplicate upload profile governs a given integrator, and confirming profile configuration after a duplicate-rejection failure. Administrators query this table to enumerate profiles for an application, and reporting extracts join it to integrator definitions to produce a governance inventory of duplicate-check rules.

Basic retrieval follows the documented query text:

• SELECT APPLICATION_ID, DUP_PROFILE_CODE, INTEGRATOR_APP_ID, INTEGRATOR_CODE FROM BNE.BNE_DUPLICATE_PROFILES_B;
• SELECT * FROM BNE.BNE_DUPLICATE_PROFILES_B WHERE APPLICATION_ID = :app_id AND DUP_PROFILE_CODE = :code; — a single-profile lookup driven by the unique index.
• SELECT * FROM BNE.BNE_DUPLICATE_PROFILES_B WHERE INTEGRATOR_APP_ID = :app_id AND INTEGRATOR_CODE = :code; — resolves all profiles for one integrator via the N1 index.

Reporting joins typically link to BNE_INTEGRATORS_B on INTEGRATOR_APP_ID and INTEGRATOR_CODE to render integrator names alongside their duplicate profiles.

Related Objects

The most significant related objects, drawn from documented key relationships, are:

• BNE.BNE_INTEGRATORS_B — referenced by INTEGRATOR_APP_ID; supplies the integrator definition that each profile configures.
• BNE.BNE_DUP_INTERFACE_PROFILES — references this table through DUP_PROFILE_APP_ID; the child linkage associating concrete interfaces with a duplicate profile.
• FND_APPLICATIONS — source of APPLICATION_ID; identifies the owning application and profile number.
• FND_USER — referenced by CREATED_BY and LAST_UPDATED_BY for audit attribution.
• FND_LOGINS — referenced by LAST_UPDATE_LOGIN to record the operating-system session performing the last change.
• BNE_DUPLICATE_PROFILES_B_UK1 / BNE_DUPLICATE_PROFILES_B_N1 / BNE_DUPLICATE_PROFILES_B_PK — the indexes enforcing and supporting access to the profile definition.