Results for “xtr_confirmation_setup_v”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_CONFIRMATION_SETUP_V is a Treasury (XTR) module view in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the confirmation generation setup maintained for treasury deals — the configuration that determines which confirmation groups are used, which deal types they apply to, and through which delivery channels (fax, post, email, or SWIFT) confirmations are dispatched. In practice, the view functions as a reporting and integration layer over the confirmation setup table, allowing external interfaces, concurrent programs, and custom reports to read the channel configuration for a given deal type without directly referencing the base table. The ETRM documentation lists no PL/SQL implementation dependency for this view; the DBA excerpt records that it is "not implemented in this database," indicating that the view is defined as a stored SQL statement over the confirmation setup table rather than as a package-backed construct.
Underlying Base Objects
The view text is a straightforward projection over a single base object, XTR_CONFIRMATION_SETUP:
- XTR_CONFIRMATION_SETUP — the Treasury table that stores confirmation group definitions, associated deal types, group descriptions, and channel flags. The view selects all of its rows without a WHERE predicate.
No additional base tables, lookups, or joined objects are documented in the ETRM metadata, so the view should be regarded as a flat, one-to-one projection. Because the view is read-only and unfiltered, row-level security and any business filtering (for example, restricting rows to active confirmation groups) must be applied by the calling code or query, not by the view itself. The absence of documented base objects beyond XTR_CONFIRMATION_SETUP means any join to deal types or party information must be constructed explicitly by the developer.
Key Columns
- CONFO_GROUP_CODE — the identifier of the confirmation group; the primary grouping key used when generating confirmations for a set of deals.
- DEAL_TYPE — the treasury deal type to which the confirmation group applies, linking the setup to the specific instrument category.
- GROUP_DESC — the descriptive name of the confirmation group, used in reports and on printed confirmations.
- FAX — channel flag indicating whether confirmations for the group are delivered by fax.
- POST — channel flag indicating whether postal delivery is used.
- EMAIL — channel flag indicating whether electronic mail delivery is used.
- SWIFT — channel flag indicating whether the confirmation is transmitted over the SWIFT network; this is the column most relevant to SWIFT-related inquiries such as the user's "swift advice 10840" search.
- DEAL_OR_SETTLEMENT — indicates whether the setup applies at the deal level or the settlement level, determining the timing and target of confirmation generation.
Common Use Cases and Queries
Typical uses include auditing which deal types route confirmations through SWIFT, identifying groups that still rely on fax or post, and driving downstream interfaces that need channel routing metadata. A simple listing of all confirmation setup rows is:
SELECT confo_group_code, deal_type, group_desc, fax, post, email, swift, deal_or_settlement FROM xtr_confirmation_setup_v;
To isolate SWIFT-enabled groups for a particular deal type:
SELECT confo_group_code, group_desc, deal_or_settlement FROM xtr_confirmation_setup_v WHERE deal_type = :deal_type AND swift = 'Y';
To report channel mix across all groups:
SELECT deal_type, SUM(DECODE(swift,'Y',1,0)) swift_cnt, SUM(DECODE(fax,'Y',1,0)) fax_cnt, SUM(DECODE(email,'Y',1,0)) email_cnt, SUM(DECODE(post,'Y',1,0)) post_cnt FROM xtr_confirmation_setup_v GROUP BY deal_type;
-
Not implemented in this database·Explore XTR module →
-
Not implemented in this database·Explore XTR module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2