Search Results as_internal_forecasts




Overview
Explore in AI Chat

Overview

The AS_INTERNAL_FORECASTS table is a core data repository within the Oracle E-Business Suite Sales Foundation module (AS). It serves as the primary table for storing summary-level forecast information. Its role is to act as the master record for a forecast entity, which can be defined for an individual sales representative (resource) or a sales group. This table holds the essential metadata and header information for a forecast, such as its name, category, owner, and status, forming the foundational record from which detailed forecast line items and worksheets are generated and managed. Its existence is critical for the application's forecasting and sales performance management functionalities.

Key Information Stored

While the full column list is not provided in the metadata, the primary and foreign key relationships indicate the critical data points stored. The central column is the FORECAST_ID, which is the unique primary key identifier for each forecast record. The table links to key master data across the application: the SALESFORCE_ID column references the specific sales resource (JTF_RS_RESOURCE_EXTNS), and the SALES_GROUP_ID column references a sales team (JTF_RS_GROUPS_B). It also categorizes forecasts via the FORECAST_CATEGORY_ID, linking to AS_FORECAST_CATEGORIES_B. A notable self-referencing relationship exists through the ORIGINAL_FORECAST_ID column, which allows for tracking revised or copied forecasts back to their source, supporting versioning or audit trails.

Common Use Cases and Queries

This table is central to reporting and data extraction for sales forecasting analysis. Common use cases include generating a list of all active forecasts for a sales manager's team, analyzing forecast categories in use, or identifying forecasts created from a specific original template. A typical query would join this table to resource and group tables to produce a readable forecast register. For example:

  • SELECT aif.forecast_id, aif.name, jrre.resource_name, jrgb.group_name FROM osm.as_internal_forecasts aif, jtf_rs_resource_extns jrre, jtf_rs_groups_b jrgb WHERE aif.salesforce_id = jrre.resource_id(+) AND aif.sales_group_id = jrgb.group_id(+);

Data from this table is also essential for reconciling summary forecast totals with the detailed line items stored in related worksheet tables.

Related Objects

The AS_INTERNAL_FORECASTS table has defined relationships with several other key EBS objects, as documented by its foreign keys:

  • AS_FORECAST_WORKSHEETS: A direct foreign key relationship where FORECAST_ID in AS_FORECAST_WORKSHEETS references FORECAST_ID in AS_INTERNAL_FORECASTS. This is a critical one-to-many link to the detailed forecast data.
  • JTF_RS_RESOURCE_EXTNS: Links via the SALESFORCE_ID column to associate a forecast with an individual salesperson.
  • JTF_RS_GROUPS_B: Links via the SALES_GROUP_ID column to associate a forecast with a sales team.
  • AS_FORECAST_CATEGORIES_B: Links via the FORECAST_CATEGORY_ID column for forecast classification.
  • Self-Reference: The table references itself through the ORIGINAL_FORECAST_ID column, pointing to the FORECAST_ID of a parent or source forecast record.