Search Results xtr_deals_interface




Overview
Explore in AI Chat

Overview

The XTR_DEALS_INTERFACE table is a Treasury (XTR) staging object within the Oracle E-Business Suite, owned by the XTR schema. Its documented purpose is to hold deal information that will be imported into Oracle Treasury, making it the primary inbound conduit for external deal data before validation and posting to the core Treasury deal tables. The table is registered as VALID and carries a documented physical schema of 96 columns in ETRM 12.2.2, applicable to both 12.1.1 and 12.2.2 environments.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a link classification. The table records associations between participating parties and bank accounts rather than acting as a pure reference hub or a descriptive satellite. Each row associates a deal with a from-bank branch, a to-bank branch, company-side bank account uses, and a counterparty account use, consistent with a transactional link connecting several business entities.

Key Information Stored

The table's business-key candidates are defined by the unique index XTR_DEALS_INTERFACE_U1 on the combination of DEAL_TYPE and EXTERNAL_DEAL_ID. These two columns together uniquely identify an inbound deal record and represent the natural key from the source system. No separate surrogate primary key column is documented in the physical schema listing; the unique index serves as the identity constraint.

Common Use Cases and Queries

Typical scenarios include monitoring unprocessed loads, diagnosing validation failures, and reconciling incoming deal feeds against posted Treasury records. A common query pattern checks records awaiting import:

  • SELECT external_deal_id, deal_type, load_status_code, validation_flag FROM xtr_deals_interface WHERE load_status_code IS NULL;
  • Joining to HZ_PARTIES via FROM_BANK_BRANCH_ID and TO_BANK_BRANCH_ID to resolve bank names for reporting.
  • Joining to CE_BANK_ACCT_USES_ALL on COMPANY_ACCT_A_USE_ID, COMPANY_ACCT_B_USE_ID, and CPARTY_ACCT_USE_ID to validate settlement account configuration.
  • Aggregating AMOUNT_A and AMOUNT_B by CURRENCY_A and CURRENCY_B for exposure summaries prior to posting.

Related Objects

The documented foreign keys tie this interface table to the following core entities:

  • HZ_PARTIES — referenced through FROM_BANK_BRANCH_ID and TO_BANK_BRANCH_ID.
  • CE_BANK_ACCT_USES_ALL — referenced through COMPANY_ACCT_A_USE_ID, COMPANY_ACCT_B_USE_ID, and CPARTY_ACCT_USE_ID.
  • EDR_PSIG_SECURITY — referenced through SECURITY_ID.

These relationships confirm that XTR_DEALS_INTERFACE acts as an integration link between Treasury deal processing, receivables party data, cash management bank account configuration, and securities reference data.