Search Results xtr_cash_fcst




Overview
Explore in AI Chat

Overview

XTR_CASH_FCST is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Treasury (XTR) product family and supports the cash forecasting functionality delivered through the Treasury/Enterprise Cash Management modules. Cash forecasting in Oracle EBS relies on the CE_FORECASTS schema, which stores forecast headers, forecast rows, currencies, and error information used to project future cash positions across legal entities, bank accounts, and internal organizations.

The package is classified as OTHER in the ETRM metadata, indicating that it is not a formalized public API but rather an internal implementation unit invoked by other Treasury components. It depends on standard Oracle General Ledger and Application Object Library tables for currency definitions, period definitions, and exchange rate lookup, and on XTR-specific tables for party information, external cash flows, and forecast period configuration. Its principal responsibility is to construct and generate a cash forecast report based on run-time parameters supplied by the caller, resolving row-level forecast data against the underlying forecast definition and reconciling the result with external cash flow records.

Key Procedures and Functions

The package exposes four documented program units:

  • SET_PARAMETERS — Initializes the package-level global variables that drive forecast execution, including forecast header identifier, forecast run name, start period and date, forecast currency, source currency type and source currency, exchange type, row range (from and to), calendar name, legal entity identifier, sub-request identifier, and organization identifiers. These globals are declared at package scope and are consumed by the remaining routines.
  • FORECAST — The core forecast computation routine. The header comment identifies the intended call context as XTR_CASH_FCST.Forecast. It processes forecast rows against the header definition, applying aging type, overdue transaction handling, and period set information to produce the projected cash position. It is the entry point that orchestrates the underlying data retrieval and calculation logic.
  • CREATE_FORECAST — Responsible for persisting a forecast definition or its resulting rows into the CE_FORECASTS, CE_FORECAST_HEADERS, and CE_FORECAST_ROWS tables, and for recording any errors encountered during generation into CE_FORECAST_ERRORS.
  • PRINT_REPORT — Produces the formatted output of a completed forecast run, drawing on the row information type (RowInfoRec/RowInfoTab) and the header and run-time globals populated earlier in the execution flow.

Tables Accessed

The package references the following tables through APPS synonyms:

Usage Notes

XTR_CASH_FCST is an internal package rather than a published API. It is referenced by two other packages within the Treasury module and is typically invoked indirectly through the Cash Forecasting concurrent programs or Treasury forms rather than called directly from custom code. Customizations that need to generate or reprint a cash forecast should ideally invoke the standard concurrent program submission rather than calling XTR_CASH_FCST directly, because the package relies on package-level global state initialized by SET_PARAMETERS and assumes the caller has already populated the run-time context. The header comment shows the version stamp xtrcshfs.pls 120.1, indicating the source is an original release file maintained at the 12.1.1 level and carried forward into 12.2.2.