Search Results xtr_deal_confo_types_u1

Overview

XTR.XTR_DEAL_CONFO_TYPES is a seed data table within the Oracle E-Business Suite ETRM (Enterprise Trade and Risk Management) module, owned by the XTR schema. It stores the set of deal confirmation types that drive the generation of confirmation letters and related documentation. Each row corresponds to a single confirmation type and carries a description of that type together with the high-level deal type with which the confirmation type is associated. The table resides in the APPS_TS_SEED tablespace, which is characteristic of reference and setup data shipped by Oracle and maintained through patching rather than transactional processing.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as hub-leaning. This classification is consistent with its structure: XTR_DEAL_CONFO_TYPES acts as a business-key reference dimension from which dependent confirmation action and detail records hang, functioning as the point of consolidation for confirmation-type semantics. The absence of inbound foreign keys referencing other tables reinforces its role as a source of classification rather than a transaction-bearing entity.

Key Information Stored

The documented physical schema defines four columns. The central business attribute is CONFO_TYPE, a VARCHAR2(50) value described as the deal confirmation action type. This column is the sole component of the primary key (XTR_DEAL_CONFO_TYPES_PK) and also serves, in combination with ZD_EDITION_NAME, as the unique business-key candidate captured by the unique index XTR_DEAL_CONFO_TYPES_U1. The presence of ZD_EDITION_NAME indicates the table is edition-enabled, meaning the uniqueness of a confirmation type is scoped to a specific edition.

• CONFO_TYPE — VARCHAR2(50), mandatory; the deal confirmation action type and the primary key of the table.
• DEAL_TYPE — VARCHAR2; code identifying the high-level deal type associated with the confirmation type.
• DESCRIPTION — VARCHAR2(200); textual description of the deal action, used for display and reporting.
• ZD_EDITION_NAME — VARCHAR2(30); edition identifier participating in the unique index XTR_DEAL_CONFO_TYPES_U1, supporting edition-based redefinition.

Because the table is seed data in nature, its cardinality is small and relatively static, but its values are referenced widely by dependent confirmation-processing tables.

Common Use Cases and Queries

Typical uses center on enumerating and validating confirmation types when building confirmation letters, filters, and layout where-clauses. A standard extraction query is:

SELECT CONFO_TYPE, DEAL_TYPE, DESCRIPTION, ZD_EDITION_NAME FROM XTR.XTR_DEAL_CONFO_TYPES;

Analysts frequently join this table to XTR_CONFIRMATION_ACTIONS or XTR_CONFIRMATION_DETAILS on ACTION_TYPE to translate stored action codes into descriptions for reporting. Confirmation letter template development also relies on this table to establish which confirmation types are valid for a given deal type, and where-clause configuration uses it to restrict the population of deals included in a generated confirmation.

Related Objects

Dependency metadata identifies three confirmed referencing tables, all joined through the ACTION_TYPE column that maps to CONFO_TYPE:

• XTR_CONFIRMATION_ACTIONS — references XTR_DEAL_CONFO_TYPES via ACTION_TYPE; records confirmation actions taken against deals.
• XTR_CONFIRMATION_DETAILS — references XTR_DEAL_CONFO_TYPES via ACTION_TYPE; holds line-level confirmation detail.
• XTR_LAYOUT_WHERE_CLAUSE — references XTR_DEAL_CONFO_TYPES via ACTION_TYPE; defines selection criteria for confirmation layouts.
• XTR_DEAL_CONFO_TYPES# — the editioning companion object maintained for the base table.

Together these objects form the confirmation-generation layer of ETRM, with XTR_DEAL_CONFO_TYPES serving as the reference point that anchors action, detail, and layout configuration.