Search Results ce_cashpools




Overview
Explore in AI Chat

Overview

The CE_CASHPOOLS table is a core data structure within the Oracle E-Business Suite (EBS) Cash Management (CE) module, specifically for releases 12.1.1 and 12.2.2. It functions as the primary repository for header-level information defining a cash pool. A cash pool is a logical grouping of bank accounts used to optimize liquidity management, enabling centralized cash visibility and facilitating automated fund transfers, such as sweeping or leveling, between a concentration account and its subordinate member accounts. The table's role is foundational; it stores the master definition of each cash pool, which is then referenced by numerous other transactional and setup tables within Cash Management and related modules like Treasury (XTR).

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as CASHPOOL_ID, a unique system-generated identifier for each cash pool. Based on its role as a header table, it typically stores descriptive and control attributes for the pool. Common columns in such a structure include the cash pool name, description, status (e.g., Active, Inactive), the identifier for the primary concentration account, pooling method (e.g., physical sweeping, notional pooling), effective dates, and various control flags governing the pool's behavior for automated cash positioning and forecasting processes. The CASHPOOL_ID column is the critical foreign key link to all related subordinate tables.

Common Use Cases and Queries

This table is central to any process involving cash pool configuration, inquiry, or reporting. Implementation consultants use it to validate setup, while business users and custom reports query it to list active pools. A typical use case is generating a master list of all configured cash pools for audit or analysis purposes. A common SQL pattern involves joining CE_CASHPOOLS to related tables to get a comprehensive view. For example, to list all cash pools with their associated concentration accounts, one might query:

Another critical use case is troubleshooting the cash positioning engine, where the pool definitions in CE_CASHPOOLS are examined to understand the hierarchy and rules driving proposed fund transfers.

Related Objects

The CE_CASHPOOLS table has extensive relationships within the EBS schema, as indicated by its foreign keys. Key dependent tables include:

These relationships underscore that CE_CASHPOOLS is the authoritative source for cash pool definitions, integrated with both operational cash management and strategic treasury functions.