Search Results xtr_deal_confo_types




Overview
Explore in AI Chat

Overview

XTR_DEAL_CONFO_TYPES is a Treasury (XTR) module reference table in Oracle E-Business Suite 12.1.1 and 12.2.2 that defines the valid deal confirmation types available when generating confirmation letters. Confirmation letters are the formal documents exchanged between counterparties to verify the commercial terms of a treasury deal — foreign exchange contracts, interest rate swaps, forward rate agreements, and similar instruments. Each row in XTR_DEAL_CONFO_TYPES represents one such confirmation category, and the table acts as the controlling lookup list that governs which confirmation types can be assigned to confirmation actions, confirmation details, and layout where-clause definitions.

From a Data Vault modeling perspective, the mined relationship data classifies this object as hub-leaning. This is a reasonable modeling suggestion: the table behaves as a durable, relatively stable list of business concepts (confirmation types) that other tables reference by a business identifier, rather than as a transactional or descriptive satellite. Its primary key XTR_DEAL_CONFO_TYPES_PK is defined on the CONFO_TYPE column, establishing the business key that downstream Treasury objects resolve through foreign key relationships.

Key Information Stored

The documented physical schema for the ETRM 12.2.2 release contains four columns, with the following being most significant:

  • CONFO_TYPE — The confirmation type identifier. This is both the primary key column (via XTR_DEAL_CONFO_TYPES_PK) and the leading column of the unique business-key index XTR_DEAL_CONFO_TYPES_U1. It is the value that all three dependent Treasury tables store and join against.
  • DEAL_TYPE — Associates the confirmation type with the category of treasury deal it applies to, allowing the confirmation framework to distinguish how different instrument families are documented.
  • DESCRIPTION — The human-readable label for the confirmation type, used in confirmation letter templates, list-of-values, and reporting.
  • ZD_EDITION_NAME — The editioning column that supports Oracle EBS 12.2 online patching (Edition-Based Redefinition). It forms the second column of the XTR_DEAL_CONFO_TYPES_U1 unique index together with CONFO_TYPE, so the effective business key is edition-scoped.

Note that CONFO_TYPE serves simultaneously as the surrogate primary key and as a business-key candidate; the unique index adds ZD_EDITION_NAME to preserve edition isolation rather than introducing a separate surrogate column.

Common Use Cases and Queries

Typical scenarios include validating which confirmation types are configured before running confirmation letter generation, joining confirmation action records back to their type description for reporting, and auditing the layout where-clause rules applied to each confirmation type.

  • Listing all configured confirmation types for a deal category: 
    SELECT confo_type, deal_type, description
FROM   xtr.xtr_deal_confo_types
WHERE  deal_type = :p_deal_type
AND    zd_edition_name = 'SET1';
  • Resolving confirmation actions to their type description: 
    SELECT a.action_type, t.description
FROM   xtr.xtr_confirmation_actions a,
       xtr.xtr_deal_confo_types t
WHERE  a.action_type = t.confo_type
AND    t.zd_edition_name = 'SET1';
  • Identifying confirmation types that have layout where-clause rules defined: 
    SELECT w.action_type, t.description
FROM   xtr.xtr_layout_where_clause w,
       xtr.xtr_deal_confo_types t
WHERE  w.action_type = t.confo_type;

Because the table is a small reference list, it is frequently extracted into reporting datasets, included in setup migration scripts between environments, and used to drive list-of-values definitions in Treasury confirmation setup forms.

Related Objects

All documented relationships are inbound foreign keys: dependent Treasury tables point to XTR_DEAL_CONFO_TYPES through the CONFO_TYPE business key.

  • XTR_CONFIRMATION_ACTIONS — references XTR_DEAL_CONFO_TYPES via ACTION_TYPE, defining the confirmation actions performed for each type.
  • XTR_CONFIRMATION_DETAILS — references XTR_DEAL_CONFO_TYPES via ACTION_TYPE, holding the detailed confirmation content associated with each type.
  • XTR_LAYOUT_WHERE_CLAUSE — references XTR_DEAL_CONFO_TYPES via ACTION_TYPE, storing the layout filtering rules applied per confirmation type.
  • XTR_DEAL_CONFO_TYPES_PK — the primary key constraint enforcing uniqueness of CONFO_TYPE.
  • XTR_DEAL_CONFO_TYPES_U1 — the unique index on (CONFO_TYPE, ZD_EDITION_NAME) supporting editioned lookups.

Together these objects form the confirmation letter configuration layer in the Treasury module, with XTR_DEAL_CONFO_TYPES operating as the central reference point from which actions, details, and layout rules are resolved.