Search Results ce_cashpool_sub_accts




Overview
Explore in AI Chat

Overview

The CE_CASHPOOL_SUB_ACCTS table is a core data repository within Oracle E-Business Suite Cash Management (CE) module. It serves as the master table for storing detailed configuration and relationship data for all sub-accounts that are members of a cash pool. A cash pool is a Cash Management structure used to aggregate balances from multiple bank accounts (sub-accounts) into a single concentration (header) account for optimized liquidity management. This table is therefore essential for the system to track which specific bank accounts participate in which pooling arrangements, forming the operational backbone of the cash pooling functionality in releases 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships indicate the critical data points. The table's primary key, CASHPOOL_SUB_ACCT_ID, uniquely identifies each sub-account-to-pool assignment record. The most significant foreign key is CASHPOOL_ID, which links each sub-account record to its parent cash pool defined in the CE_CASHPOOLS table. Other typical columns in this table, based on its functional purpose, would include identifiers for the specific bank account (likely referencing CE_BANK_ACCOUNTS), the effective dates for the pool membership, the sub-account's role within the pool (e.g., zero-balance account), and ranking or percentage allocation rules for fund distribution or sweeping.

Common Use Cases and Queries

This table is central to inquiries and reports regarding cash pool composition and bank account utilization. Common operational and audit scenarios include generating a list of all bank accounts belonging to a specific cash pool, identifying all cash pools a particular bank account is associated with, and validating configuration during period-end close. A typical query would join CE_CASHPOOL_SUB_ACCTS to CE_CASHPOOLS for pool details and to CE_BANK_ACCOUNTS for account specifics.

  • Sample Query: To list all sub-accounts for a given cash pool name:
    SELECT cpsa.* FROM ce_cashpool_sub_accts cpsa, ce_cashpools cp WHERE cpsa.cashpool_id = cp.cashpool_id AND cp.name = '&POOL_NAME';
  • Reporting Use Case: Creating a master report showing all active cash pools with their member sub-accounts, account numbers, and effective dates for treasury oversight.

Related Objects

The table maintains defined foreign key relationships with other core Cash Management tables, ensuring referential integrity. The primary documented relationship is a foreign key constraint linking CE_CASHPOOL_SUB_ACCTS.CASHPOOL_ID to the CE_CASHPOOLS table. This enforces that every sub-account record must be associated with a valid, pre-defined cash pool. While not explicitly listed in the provided excerpt, it is architecturally certain that this table also references the CE_BANK_ACCOUNTS table to identify the specific bank account acting as the sub-account. This table is also a likely parent to transaction or sweep execution detail tables within the CE schema that log the actual fund movements between the sub-accounts and the header account of the pool.