Search Results ce_bal_util




Overview
Explore in AI Chat

Overview

CE_BAL_UTIL is a utility package body owned by APPS within the Oracle E-Business Suite Cash Management (CE) module. Its documented API classification is UTIL, indicating that it provides shared helper logic rather than a business-facing API. The package supplies date and balance retrieval routines used by Cash Management components that need to reconstruct bank account balance information across a span of dates. The implementation included in the source excerpt is dated 2005 and carries the header revision 120.2, confirming that this utility has been stable across the 12.1.1 and 12.2.2 releases.

Internally, the package references the profile option CE_DEBUG, which is the debug switch customers and support engineers toggle when diagnosing Cash Management data issues. The variable l_DEBUG is derived from FND_PROFILE.value('CE_DEBUG'), with a commented-out override line that forces debugging on. This is why searches for "ce_debug" surface CE_BAL_UTIL: it is one of the CE code units whose tracing behavior is governed by that profile.

Key Procedures and Functions

  • GET_DATE_RANGE — A pipelined function returning every day between a supplied start date and end date. It is used to generate a contiguous date axis so that callers can iterate over a period and request a balance for each day, even when no balance row exists for that date.
  • GET_BALANCE — A pipelined function returning balance records for a set of bank accounts supplied through a reference cursor. Documented behavior shows that when no balance row exists for the requested date, the function falls back to the most recent prior balance with a non-null value-dated balance, effectively carrying forward the last known balance.
  • GET_POOL_BALANCE — A pipelined function that returns aggregated balance information for a cash pool, resolving pool membership through the pool sub-account mapping and combining the underlying account balances.

Tables Accessed

  • CE_BANK_ACCT_BALANCES — The primary source of value-dated balance amounts. GET_BALANCE reads this table directly by bank account and balance date, and also queries it for the maximum prior balance date when an exact-date row is absent.
  • CE_CASHPOOL_SUB_ACCTS — The pool membership mapping table. GET_POOL_BALANCE reads it to determine which sub-accounts belong to a given cash pool before aggregating their balances.

Usage Notes

CE_BAL_UTIL is a server-side utility, so it is not invoked directly from a form. It is consumed by other Cash Management packages and by any custom code that needs a date series or carry-forward balance lookups. The metadata records that it is referenced by one other package, so its exposure is intentionally narrow. Because the functions are pipelined, they are best called from SQL (TABLE(ce_bal_util.get_balance(...))) or from PL/SQL that fetches from the pipelined result set.

Debug output is controlled by the CE_DEBUG profile option at the user or site level. Setting CE_DEBUG to 'Y' enables the package's trace statements, which is the standard step when investigating missing or stale bank balance figures. No documented initialization or commit semantics are associated with the package; it is read-only against the tables listed above and performs no DML, which makes it safe to call repeatedly within a reporting or reconciliation flow.