Results for “ce_cashpools_pk”

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

Overview

CE_CASHPOOLS is the header table for the Cash Pools feature within the Oracle Cash Management (CE) module. It stores the defining attributes of a cash pool — the construct that groups multiple bank accounts, concentration accounts, and legal entities so that automated cash sweeping, balancing, and intercompany leveling can be performed across the group. Each row represents one cash pool, identified by a surrogate primary key and qualified by a business-key uniqueness constraint.

Under the heuristic Data Vault classification mined from the foreign-key structure, CE_CASHPOOLS is hub-leaning. This suggests modeling CASHPOOL_ID as a hub key, with the individual descriptive columns (name, currency, type, effective dates, flags, and audit columns) treated as satellite attributes that change over time. Downstream transactional objects such as CE_PROPOSED_TRANSFERS and CE_LEVELING_MESSAGES would sit as link or satellite tables referencing the pool hub.

The table resides in the CE schema, is documented as VALID in ETRM for 12.2.2, and carries 21 physical columns. Its documented description is simply that it stores header information about the cash pool.

Key Information Stored

Only the columns documented in the ETRM metadata are addressed below.

• CASHPOOL_ID — surrogate primary key of the table and the target of CE_CASHPOOLS_PK. A unique index, CE_CASHPOOLS_U1, also exists on CASHPOOL_ID, marking it as the documented business-key candidate.
• NAME — the user-facing name of the cash pool.
• CURRENCY_CODE — the currency in which the pool operates and in which sweep amounts are denominated.
• TYPE — the pool type classification, distinguishing how the pool is structured for sweeping behavior.
• EFFECTIVE_DATE_FROM / EFFECTIVE_DATE_TO — the active window during which the pool definition is valid for processing.
• SWEEPS_FLAG — indicates whether automated cash sweeping applies to the pool.
• PARENT_CASHPOOL_ID — self-referencing hierarchy column that supports nested or parent-child pool structures.
• LEGAL_ENTITY_ID — the only documented outbound foreign key; it references FV_LEGAL_ENTITIES and ties the pool to its owning legal entity.
• PARTY_CODE — the party identifier associated with the pool.
• SINGLE_CONC_ACCOUNT_FLAG along with CONC_ACCOUNT_ID, INV_CONC_ACCOUNT_ID, and FUND_CONC_ACCOUNT_ID — identify the concentration accounts used by the pool and whether a single concentration account is used.
• TRXN_SUBTYPE_CODE_ID — transaction subtype classification for accounting and reporting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical reporting concentrates on active pools, their legal entities, and the accounts attached to them.

• Listing all currently effective pools:

  SELECT cashpool_id, name, currency_code, type FROM ce_cashpools WHERE SYSDATE BETWEEN NVL(effective_date_from, SYSDATE) AND NVL(effective_date_to, SYSDATE);

• Joining a pool to its legal entity for corporate reporting:

  SELECT cp.name, cp.currency_code, le.legal_entity_name FROM ce_cashpools cp, fv_legal_entities le WHERE cp.legal_entity_id = le.legal_entity_id;

• Identifying pool membership for a bank account by joining XTR_BANK_ACCOUNTS on CASHPOOL_ID, and enumerating sub-accounts through CE_CASHPOOL_SUB_ACCTS.
• Driving cash position and sweep reporting by joining CE_PROPOSED_TRANSFERS and CE_LEVELING_MESSAGES on CASHPOOL_ID to attribute proposed or leveled transfers to their originating pool.
• Resolving the user query "xtr_cashpool_attributes" by joining XTR_CASHPOOL_ATTRIBUTES to CE_CASHPOOLS on CASHPOOL_ID, which exposes pooled account attributes alongside the header definition.

Related Objects

The following objects depend on or reference CE_CASHPOOLS through documented foreign keys.

• CE_CASHPOOL_SUB_ACCTS — references CE_CASHPOOLS via CASHPOOL_ID; holds the subordinate accounts belonging to a pool.
• CE_LEVELING_MESSAGES — references CE_CASHPOOLS via CASHPOOL_ID; stores leveling or balancing messages generated for the pool.
• CE_PROPOSED_TRANSFERS — references CE_CASHPOOLS via CASHPOOL_ID; holds the transfers proposed by the pool engine.
• XTR_BANK_ACCOUNTS — references CE_CASHPOOLS via CASHPOOL_ID; the bank account records assigned to a pool.
• XTR_CASHPOOL_ATTRIBUTES — references CE_CASHPOOLS via CASHPOOL_ID; stores extended attributes for pooled bank accounts.
• FV_LEGAL_ENTITIES — the parent of LEGAL_ENTITY_ID; CE_CASHPOOLS references it.