Search Results xtr_cashpool_attributes




Overview
Explore in AI Chat

Overview

The XTR_CASHPOOL_ATTRIBUTES table is a core data object within the Oracle E-Business Suite Treasury (XTR) module, specifically for versions 12.1.1 and 12.2.2. It functions as the primary repository for configuration and setup details related to Cashpool Deal Attributes. In Treasury operations, a cash pool is a mechanism to aggregate balances from multiple subsidiary accounts (often across different legal entities or banks) into a single concentration account to optimize liquidity management and interest earnings. This table stores the specific attributes and rules that define how these complex treasury cash pooling deals are structured and managed within the system, serving as a critical link between high-level cash pool definitions and detailed party-specific parameters.

Key Information Stored

The table's structure is designed to hold setup information for cashpool deals. While the full column list is not detailed in the provided metadata, the existence of a primary key and foreign keys reveals its core data relationships. The primary key, CASHPOOL_ATTRIBUTE_ID, uniquely identifies each attribute record. Two critical foreign key columns establish essential links: the CASHPOOL_ID column references the CE_CASHPOOLS table, tethering each attribute to a specific master cash pool definition. The PARTY_CODE column references the XTR_PARTY_INFO table, associating the attributes with a specific treasury counterparty or entity involved in the cash pool arrangement. Typically, this table would store additional attribute columns defining parameters such as interest calculation methods, allocation rules, target balances, or participation percentages for each party within the cash pool.

Common Use Cases and Queries

This table is primarily accessed for treasury operational reporting, audit trails, and deal configuration analysis. Common use cases include generating a summary of all configured attributes for a specific cash pool to verify setup, or listing all parties and their specific terms within a pooling structure. A typical analytical query would join this table to its related master tables. For example, to report on cash pool setup:

  • SELECT cpa.*, cp.CASHPOOL_NAME, pi.PARTY_NAME FROM XTR_CASHPOOL_ATTRIBUTES cpa, CE_CASHPOOLS cp, XTR_PARTY_INFO pi WHERE cpa.CASHPOOL_ID = cp.CASHPOOL_ID AND cpa.PARTY_CODE = pi.PARTY_CODE ORDER BY cp.CASHPOOL_NAME;

Another critical use case is supporting the treasury processes that automatically calculate interest allocations or fund transfers based on the rules stored in this table.

Related Objects

The XTR_CASHPOOL_ATTRIBUTES table is centrally connected to other key Treasury and Cash Management objects. Its primary relationships, as documented, are:

  • CE_CASHPOOLS: This Cash Management (CE) table holds the master definition of the cash pool itself. The foreign key from XTR_CASHPOOL_ATTRIBUTES.CASHPOOL_ID to this table ensures every attribute record is associated with a valid pool.
  • XTR_PARTY_INFO: This core Treasury table stores information on banks, counterparties, and internal companies. The foreign key from XTR_CASHPOOL_ATTRIBUTES.PARTY_CODE links the cash pool's operational rules to a specific legal entity or counterparty.
  • The table is also likely referenced by various Treasury transaction processing and reporting views within the XTR schema, which consolidate deal attributes with live transaction data for operational and compliance reporting.