Results for “xtr_cashpool_attributes”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_CASHPOOL_ATTRIBUTES is a Treasury (XTR) module configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the deal attribute setup that governs how cash pool deals are constructed, priced, and constrained for a given cash pool and counterparty. In practice, the table acts as the attribute-resolution layer for Treasury cash pooling: rather than hard-coding portfolio, product type, pricing model, day count, and limit attributes onto every deal, Treasury administrators define them once at the cash pool level, optionally overridden at the party level, and the cash pooling engine consumes the resulting rows when generating or processing cash pool deals.

Two attributes are typical of this design. First, the table carries both pool-level attribute columns (PORTFOLIO, PRODUCT_TYPE, PRICING_MODEL, ROUNDING_TYPE, DAY_COUNT_TYPE, FUND_LIMIT_CODE, INVEST_LIMIT_CODE) and party-level counterparts (PARTY_PORTFOLIO, PARTY_PRODUCT_TYPE, PARTY_PRICING_MODEL, PARTY_FUND_LIMIT_CODE, PARTY_INVEST_LIMIT_CODE), allowing a counterparty-specific override hierarchy. Second, the IAC_PORTFOLIO and IAC_PRODUCT_TYPE columns suggest integration with intra-agency/cash concentration processing.

From a Data Vault modeling perspective (a heuristic suggested by the mined foreign-key structure), XTR_CASHPOOL_ATTRIBUTES is best classified as a link entity. It sits between CE_CASHPOOLS and XTR_PARTY_INFO, resolving the many-to-many relationship of which parties participate in which cash pools and under what attribute regime.

Key Information Stored

The table contains 22 documented columns. The most significant are:

• CASHPOOL_ATTRIBUTE_ID — Surrogate primary key, enforced by XTR_CASHPOOL_ATTRIBUTES_PK and mirrored by unique index XTR_CASHPOOL_ATTRIBUTES_U1. This is the sole documented business-key candidate; all other uniqueness is expected to come from the composite of CASHPOOL_ID and PARTY_CODE.
• CASHPOOL_ID — Foreign key to CE_CASHPOOLS. Identifies the cash pool to which the attribute row belongs.
• PARTY_CODE — Foreign key to XTR_PARTY_INFO. Identifies the counterparty whose attributes are being overridden or defined.
• PORTFOLIO / PRODUCT_TYPE — Default portfolio and product classification applied to deals in the pool.
• IAC_PORTFOLIO / IAC_PRODUCT_TYPE — Portfolio and product type used for intra-agency cash concentration processing.
• PRICING_MODEL — Pricing convention applied to the pool's deals.
• ROUNDING_TYPE and DAY_COUNT_TYPE — Interest calculation conventions (rounding method and day-count basis).
• FUND_LIMIT_CODE / INVEST_LIMIT_CODE — Limit codes governing funding and investment exposure.
• PARTY_PORTFOLIO, PARTY_PRODUCT_TYPE, PARTY_PRICING_MODEL, PARTY_FUND_LIMIT_CODE, PARTY_INVEST_LIMIT_CODE — Counterparty-specific overrides of the pool-level defaults.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns for audit and concurrency tracking.

Common Use Cases and Queries

Typical uses include verifying attribute setup before processing cash pool deals, auditing limit-code assignments by counterparty, and reconciling pool-level versus party-level attribute drift.

• List all attributes configured for a given cash pool:

  SELECT a.cashpool_attribute_id, a.cashpool_id, a.party_code, a.portfolio, a.product_type, a.pricing_model FROM xtr.xtr_cashpool_attributes a WHERE a.cashpool_id = :p_cashpool_id;

• Find parties with a party-level pricing model overriding the pool default:

  SELECT cashpool_id, party_code FROM xtr.xtr_cashpool_attributes WHERE party_pricing_model IS NOT NULL AND party_pricing_model <> pricing_model;

• Join to cash pool definitions and counterparty details:

  SELECT c.cashpool_name, p.party_name, a.fund_limit_code, a.invest_limit_code FROM xtr.xtr_cashpool_attributes a, ce.ce_cashpools c, xtr.xtr_party_info p WHERE a.cashpool_id = c.cashpool_id AND a.party_code = p.party_code;

• Audit changes since a given date using LAST_UPDATE_DATE.

Reporting scenarios generally center on limit-code exposure, day-count and rounding convention consistency, and identifying pools that lack counterparty overrides.

Related Objects

• CE_CASHPOOLS — Parent cash pool definition; joined via XTR_CASHPOOL_ATTRIBUTES.CASHPOOL_ID = CE_CASHPOOLS.CASHPOOL_ID.
• XTR_PARTY_INFO — Counterparty master; joined via XTR_CASHPOOL_ATTRIBUTES.PARTY_CODE = XTR_PARTY_INFO.PARTY_CODE.
• XTR_CASHPOOL_ATTRIBUTES_PK / XTR_CASHPOOL_ATTRIBUTES_U1 — Primary key constraint and unique index on CASHPOOL_ATTRIBUTE_ID.
• Treasury Cashpool Deal setup and processing concurrent programs — Consume these attribute rows when generating and valuing cash pool deals.
• XTR_PARTY_PORTFOLIO / XTR_PARTY_LIMITS — Sibling setup tables that may further qualify the party-level attributes stored here.
• CE_CASHPOOL_DEALS (or the corresponding deal fact table) — Downstream consumer of the resolved attributes.