Search Results bne_dup_interface_cols_uk1

Overview

BNE.BNE_DUP_INTERFACE_COLS is a transactional configuration table in the Oracle E-Business Suite Application Technology Layer, owned by the BNE (Business Intelligence/Application Object Library extensions) schema. It stores the definition of a duplicate upload profile for an interface column — that is, the mapping that determines how an interface column is handled when duplicate records are detected during interface upload processing. This table underpins the duplicate-resolution framework used by EBS interface programs, allowing administrators to assign a specific resolver to a given interface column so that collisions between incoming and existing data can be resolved deterministically.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, consistent with other reference and configuration data in the transactional data segment. From a Data Vault modeling perspective, the mined foreign key structure suggests a link classification: the table records associations between an interface column (via INTERFACE_APP_ID and INTERFACE_CODE) and a duplicate profile (via DUP_PROFILE_APP_ID and DUP_PROFILE_CODE), rather than representing an independent business entity. This is offered as a heuristic modeling suggestion, not a normative statement.

Key Information Stored

The primary key of the table is BNE_DUP_INTERFACE_COLS_PK, defined across INTERFACE_APP_ID, INTERFACE_CODE, INTERFACE_SEQ_NUM, DUP_PROFILE_APP_ID, and DUP_PROFILE_CODE. This composite key uniquely identifies each duplicate-profile assignment for an interface column.

• INTERFACE_APP_ID — Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID) identifying the application owning the interface.
• INTERFACE_CODE — Unique code identifying the interface entity for the given application.
• INTERFACE_SEQ_NUM — Sequence number further qualifying the interface entity.
• DUP_PROFILE_APP_ID — Application identifier of the duplicate profile applied to this interface column.
• DUP_PROFILE_CODE — Unique code identifying the duplicate profile for the given application.
• RESOLVER_CLASSNAME — Fully qualified Java class name of the resolver that handles columns lacking a specific resolver; this acts as the interface-level default resolution strategy.
• OBJECT_VERSION_NUMBER — Optimistic locking version column used by the framework to detect concurrent updates.
• CREATED_BY / CREATION_DATE — Standard WHO columns capturing the user and timestamp of row creation.
• LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard WHO columns capturing the last modification user, timestamp, and operating-system login.
• ZD_EDITION_NAME — Editioning column supporting EBS 12.2 online patching (Edition-Based Redefinition).

The unique index BNE_DUP_INTERFACE_COLS_UK1 enforces uniqueness on INTERFACE_APP_ID, INTERFACE_CODE, INTERFACE_SEQ_NUM, DUP_PROFILE_APP_ID, DUP_PROFILE_CODE, and ZD_EDITION_NAME, and serves as a business-key candidate alongside the primary key.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include identifying which duplicate profiles are attached to a given interface, tracing the resolver class responsible for default column resolution, and auditing profile reconfiguration over time.

• Listing all duplicate profile assignments for an interface:
  SELECT interface_code, interface_seq_num, dup_profile_code, resolver_classname FROM bne.bne_dup_interface_cols WHERE interface_app_id = :app_id ORDER BY interface_code, interface_seq_num;
• Finding interfaces that share a duplicate profile:
  SELECT interface_app_id, interface_code, interface_seq_num FROM bne.bne_dup_interface_cols WHERE dup_profile_app_id = :app_id AND dup_profile_code = :code;
• Auditing configuration changes using WHO columns:
  SELECT * FROM bne.bne_dup_interface_cols WHERE last_update_date >= :since;
• Resolving which interface columns fall back to the interface-level resolver, by filtering on RESOLVER_CLASSNAME IS NULL.

Related Objects

• BNE.BNE_DUP_INTERFACE_PROFILES — Referenced by the INTERFACE_APP_ID foreign key; holds the duplicate profile header information.
• BNE.BNE_INTERFACE_COLS_B — Referenced by the INTERFACE_APP_ID foreign key; defines the underlying interface columns to which duplicate profiles are attached.
• FND_APPLICATIONS — Source of INTERFACE_APP_ID and DUP_PROFILE_APP_ID values.
• FND_USER — Source of CREATED_BY and LAST_UPDATED_BY values.
• FND_LOGINS — Source of LAST_UPDATE_LOGIN values.
• BNE_DUP_INTERFACE_COLS_UK1 — Unique index supporting business-key lookups and edition-aware queries.