Search Results as_forecast_worksheets




Overview
Explore in AI Chat

Overview

The AS_FORECAST_WORKSHEETS table is a core data object within the Oracle E-Business Suite (EBS) Sales Foundation module (AS). It functions as a header-level repository for forecast worksheets, which are critical tools for sales and revenue planning. Specifically, it stores the structural and contextual metadata for worksheets used to manage opportunity and product category forecasts. This table acts as a central hub, linking high-level forecast definitions to their detailed line items, thereby enabling the systematic entry, adjustment, and reporting of sales projections within the application.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships define its essential structure. The central column is FORECAST_WORKSHEET_ID, which serves as the unique identifier (Primary Key) for each worksheet record. Another critical column is FORECAST_ID, which links the worksheet to its parent forecast definition in the AS_INTERNAL_FORECASTS table. This establishes the worksheet within a specific forecasting cycle or plan. Other columns in the table header would typically store information such as the worksheet name, description, creation date, last update date, the responsible salesperson or manager, and its current status (e.g., Draft, Submitted, Approved).

Common Use Cases and Queries

This table is central to all forecast worksheet operations. A common use case is generating a report of all worksheets for a specific forecast period. A typical query would join AS_FORECAST_WORKSHEETS to AS_INTERNAL_FORECASTS to filter and report on worksheets. For example:

SELECT fw.forecast_worksheet_id, fw.name, f.forecast_name, fw.creation_date
FROM osm.as_forecast_worksheets fw,
     osm.as_internal_forecasts f
WHERE fw.forecast_id = f.forecast_id
AND f.forecast_name = 'Q1-2024 Sales Plan';

Another critical scenario involves data integrity checks or audits, where one might query worksheets that have header records but are missing associated detail lines by using outer joins to the AS_OPP_WORKSHEET_LINES or AS_PROD_WORKSHEET_LINES tables.

Related Objects

The AS_FORECAST_WORKSHEETS table has defined relationships with several key tables in the Sales Foundation schema, as documented in the metadata:

  • AS_INTERNAL_FORECASTS: The worksheet is a child of a forecast. The join is on AS_FORECAST_WORKSHEETS.FORECAST_ID = AS_INTERNAL_FORECASTS.FORECAST_ID.
  • AS_OPP_WORKSHEET_LINES: This table stores the detailed opportunity lines for a worksheet. It is a child of AS_FORECAST_WORKSHEETS, joined on AS_OPP_WORKSHEET_LINES.FORECAST_WORKSHEET_ID = AS_FORECAST_WORKSHEETS.FORECAST_WORKSHEET_ID.
  • AS_PROD_WORKSHEET_LINES: This table stores the detailed product category lines for a worksheet. It is also a child of AS_FORECAST_WORKSHEETS, joined on AS_PROD_WORKSHEET_LINES.FORECAST_WORKSHEET_ID = AS_FORECAST_WORKSHEETS.FORECAST_WORKSHEET_ID.

These relationships form the core data model for the worksheet functionality, separating header information from the two primary types of forecast line details.