Search Results ce_forecasts




Overview
Explore in AI Chat

Overview

The CE_FORECASTS table is a core data object within the Oracle E-Business Suite Cash Management (CE) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary transactional repository for individual cash forecast entries. Each record in this table represents a distinct forecast line item that is part of a larger forecast header, managed in the CE_FORECAST_HEADERS table. The table's role is to store the detailed financial data—such as amounts, dates, currencies, and associated project information—that constitutes a comprehensive cash flow projection. This data is essential for treasury and finance departments to analyze future cash positions, manage liquidity, and support strategic financial planning.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which dictate the critical data elements stored. The primary identifier for each forecast line is the FORECAST_ID. Each line is logically grouped under a specific forecast header via the FORECAST_HEADER_ID. The NAME column uniquely identifies a forecast within its header context. Financial data includes currency information: FORECAST_CURRENCY and SOURCE_CURRENCY store the currency codes for the forecasted and original transaction amounts, respectively, linked to FND_CURRENCIES. The EXCHANGE_RATE_TYPE column, referencing GL_DAILY_CONVERSION_TYPES, defines the rate type used for currency conversion. For project-centric forecasts, the PROJECT_ID column links to PA_PROJECTS_ALL, enabling detailed cash flow analysis at the project level.

Common Use Cases and Queries

This table is central to generating cash position reports and analyzing forecast accuracy. A common operational use case is reconciling forecasted cash flows against actual bank statement transactions. For reporting, analysts frequently query this table to summarize forecasted amounts by currency, project, or time period. A typical SQL pattern involves joining to the header table and currency tables to produce a readable report:

  • SELECT cf.name, cfh.forecast_name, fc.currency_code, cf.forecast_amount FROM ce_forecasts cf, ce_forecast_headers cfh, fnd_currencies fc WHERE cf.forecast_header_id = cfh.forecast_header_id AND cf.forecast_currency = fc.currency_code AND cfh.forecast_date BETWEEN :p_start_date AND :p_end_date;

Another critical use case is troubleshooting via the related CE_FORECAST_ERRORS table, where queries join on FORECAST_ID to identify and resolve data validation or processing issues for specific forecast lines.

Related Objects

The CE_FORECASTS table maintains integral relationships with several key EBS objects, as documented by its foreign key constraints. It is a child table of CE_FORECAST_HEADERS (via FORECAST_HEADER_ID), which provides the master forecast definition. It references FND_CURRENCIES twice (for FORECAST_CURRENCY and SOURCE_CURRENCY) and GL_DAILY_CONVERSION_TYPES (for EXCHANGE_RATE_TYPE) for currency management. For project accounting integration, it references PA_PROJECTS_ALL (via PROJECT_ID). Furthermore, it acts as a parent table to two important transactional tables: CE_FORECAST_CELLS (via FORECAST_ID), which stores the detailed period-based forecast amounts, and CE_FORECAST_ERRORS (via FORECAST_ID), which logs processing errors for the forecast line.