Search Results ce_forecast_columns




Overview
Explore in AI Chat

Overview

The CE_FORECAST_COLUMNS 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 functions as the structural definition for the forecast periods within a cash forecast template. Each row in this table represents a single time-based column in a forecast, such as "Week 1," "Month 1," or "Q1," within a specific forecast template defined in the CE_FORECAST_HEADERS table. Its primary role is to establish the periodicity and sequence of the forecast, enabling the system to organize and store transactional forecast data on a period-by-period basis in related detail tables.

Key Information Stored

The table stores metadata that defines the forecast's columnar layout. The critical columns include FORECAST_COLUMN_ID, the unique primary key identifier for the column definition. The FORECAST_HEADER_ID is a foreign key linking the column to its parent forecast template in CE_FORECAST_HEADERS. The COLUMN_NUMBER is a sequential integer that dictates the display order and period sequence of the column within the template. While the provided ETRM excerpt lists these core structural columns, the table typically also contains descriptive columns such as COLUMN_NAME and attributes defining the period type and date range the column represents, which are essential for accurate forecasting calculations.

Common Use Cases and Queries

This table is central to any technical operation involving the extraction or analysis of forecast structure. Common use cases include generating a list of all periods for a specific forecast template for a data validation report, or determining the period sequence for programmatically populating forecast data. A typical query would join to the forecast headers table to retrieve a template's column structure.

  • Sample Query: Retrieving the column sequence for a forecast template.
    SELECT fc.column_number, fc.column_name
    FROM ce_forecast_columns fc, ce_forecast_headers fh
    WHERE fc.forecast_header_id = fh.forecast_header_id
    AND fh.forecast_name = '<Forecast_Name>'
    ORDER BY fc.column_number;
  • Reporting Use Case: Building a dynamic column header definition for BI publisher reports that must reflect the customizable periods of a cash forecast.

Related Objects

CE_FORECAST_COLUMNS sits at the center of the forecast data model, with defined relationships to key transactional and header tables. As per the provided metadata, its primary relationships are:

  • CE_FORECAST_HEADERS: The parent table. The foreign key on FORECAST_HEADER_ID enforces that every forecast column belongs to a valid template.
  • CE_FORECAST_CELLS: A key child table. The foreign key relationship indicates that individual data cells storing forecast amounts are stored per forecast column (period).
  • CE_FORECAST_TRX_CELLS: Another key child table. This relationship links the forecast column to the detailed transaction-level data that comprises the forecast for each period.

These relationships underscore the table's role: the column definitions in CE_FORECAST_COLUMNS provide the period context for all forecast amounts stored in the CELLS tables.