Search Results ce_cp_priorday




Overview
Explore in AI Chat

Overview

CE_CP_PRIORDAY is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Cash Positioning and Forecasting functionality within Oracle Cash Management. Its name reflects its principal purpose: generating and managing the "prior day" cash positioning worksheet, which is used by treasury and cash management personnel to compare an entity's bank-reported closing balances against the prior day's ending book balances. This comparison is a core control activity in the daily cash reconciliation cycle, allowing organizations to identify and investigate discrepancies between bank statements and internal records before they propagate into subsequent days.

The package operates in conjunction with the Cash Positioning worksheet infrastructure, drawing upon worksheet header records and balance data captured from bank feeds or manual entry. It is classified in ETRM as an "OTHER" object type, indicating it is not one of the primary public APIs of Oracle Cash Management but an internal utility package used by the cash positioning engine. The package status is VALID in the documented environment.

Key Procedures and Functions

The package exposes four documented procedures and functions:

  • GEN_PRIOR_DAY — The principal driver routine, responsible for generating prior-day cash positioning data. This procedure orchestrates the population of prior-day balance records based on the current worksheet context and associated bank data.
  • SET_PARAMETERS — Initializes or assigns the runtime parameters required by the package's processing logic, establishing the context (such as the worksheet or entity) under which prior-day generation executes.
  • SPEC_REVISION — Returns the package specification revision identifier, a standard versioning function used for configuration and patch-level tracking.
  • BODY_REVISION — Returns the package body revision identifier, complementary to SPEC_REVISION and used to confirm the deployed code level of the implementation.

No parameter lists are documented in the ETRM metadata; the descriptions above reflect each routine's named purpose.

Tables Accessed

The package references four tables through APPS synonyms:

  • CE_CP_WORKSHEET_HEADERS — Stores the header records defining each cash positioning worksheet, including entity, currency, and date range. The package reads these to establish processing context.
  • CE_CP_WORKSHEET_LINES — Holds the individual balance lines within a worksheet. Prior-day generation writes or updates these to reflect reconciled position lines.
  • CE_CP_PRIORDAY_BALANCES — The dedicated repository of prior-day balance figures; the package is the primary consumer and maintainer of records in this table.
  • FND_LOOKUP_VALUES — The standard Oracle Application Object Library lookup table, consulted to resolve seeded lookup codes (for example, status or type values) used during processing.

Usage Notes

CE_CP_PRIORDAY is not typically invoked directly by end users. It is called internally by the Cash Management cash positioning workflow, often as part of a concurrent program or as a subordinate call from the Cash Positioning form when a user requests prior-day worksheet generation. Because the package is referenced by zero other packages per ETRM metadata, it behaves as a leaf-level utility: it depends on worksheet headers and lookups but nothing else depends upon it. Customizations should not modify the package body directly; extensions should wrap or replicate its logic, as patching Oracle Cash Management will overwrite any non-standard changes. Developers diagnosing prior-day balance discrepancies should trace calls into GEN_PRIOR_DAY and inspect rows in CE_CP_PRIORDAY_BALANCES alongside the corresponding worksheet headers.