Search Results insert_fcast_cell

Overview

CE_CSH_FCST_POP is a PL/SQL package in the APPS schema that supports the Oracle Cash Management cash forecasting engine. Its name, reflecting "Cash Forecast Populate," indicates that its principal responsibility is the population of forecast data structures used by the Cash Forecasting feature. The package serves as the calculation and data-loading layer that transforms raw receivables, payment terms, bank account, and currency information into the forecast cells displayed to users in the Cash Management forecasting workbench.

The package header carries a revision string and global variables including source_view, G_calendar_start, G_calendar_end, G_sub_accounts_complete, and G_spec_revision. These globals indicate that the package operates over a date-range calendar window and tracks state relating to sub-account completeness during a forecast run. The documented API classification is OTHER, meaning it is an internal engine package rather than a public, supported integration API.

Key Procedures and Functions

• SPEC_REVISION — Returns the package specification revision string, used for version identification and diagnostics.
• BODY_REVISION — Returns the package body revision string, complementing the specification revision for support and patching purposes.
• POPULATE_CELLS — The central driver that populates forecast cells for the active forecast and calendar range, drawing on the forecast column, transaction, and extended view definitions.
• ZERO_FILL_CELLS — Ensures forecast cells with no computed amounts are initialized to zero, providing a complete and consistent grid for display and aggregation.
• INSERT_FCAST_CELL — Inserts an individual forecast cell for a given reference, currency, organization, transaction date, bank account, and forecast column, carrying both the forecast amount and the underlying transaction amount.
• POPULATE_OPENING_BAL — Computes and loads opening balances for the forecast, working with the CE_FORECAST_OPENING_BAL tables.
• GET_AVERAGE_PAYMENT_DAYS — Returns the average number of days taken by a customer, site use, and currency combination over a selected period. This function supports the payment-days assumption used in forecasting collections. It is the object most commonly searched for by name, as it exposes the payment-behavior calculation central to accurate cash inflow prediction.

Tables Accessed

The package reads Oracle Receivables data through AP_TERMS_LINES, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL to derive payment terms and actual customer payment timing, which underpins GET_AVERAGE_PAYMENT_DAYS. Bank account information is drawn from CE_BANK_ACCOUNTS and CE_BANK_ACCT_USES_ALL, while CE_CURRENCY_RATES_TEMP supplies rates needed to express forecast amounts consistently. Forecast configuration and output are read from and written to CE_FORECASTS, CE_FORECAST_COLUMNS, CE_FORECAST_TRX_CELLS, CE_FORECAST_OPENING_BAL, and CE_FORECAST_OPENING_BAL_S. Supporting structures include CE_FORECAST_EXT_TEMP, CE_FORECAST_EXT_VIEWS, CE_GL_ACCOUNTS_CCID, and FND_NEW_MESSAGES for messaging.

Usage Notes

CE_CSH_FCST_POP is a internal engine package invoked by the Cash Management forecasting process rather than called directly from forms or external integrations. It is referenced by one other package, confirming its role as a supporting component within the forecasting framework. GET_AVERAGE_PAYMENT_DAYS may be invoked from custom reporting or analytical code to retrieve historical average payment days, but because the package is classified OTHER, Oracle does not guarantee its signature across releases. Customizations should avoid modifying or overloading its procedures and should rely only on documented behavior.