Results for “won_pipeline_amount”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AS_INTERNAL_FORECASTS table, owned by the OSM schema, is a core object within the Oracle EBS Sales Foundation (AS) product family. It stores the summary forecast information for individual sales representatives or for sales groups, capturing the consolidated forecast amounts that feed the internal forecasting and pipeline analysis functionality used by sales organizations. In Oracle EBS 12.1.1 and 12.2.2, this table underpins the Sales Forecasting feature set, where territory managers and sales representatives define, review, and compare forecast categories (such as worst case, forecast, best case, weighted pipeline, and quota) against actual pipeline and won opportunities.

From a Data Vault modeling perspective, the FK structure suggests that AS_INTERNAL_FORECASTS behaves as a satellite-leaning entity. It carries descriptive forecast measures, flags, and status attributes around a central forecast key (FORECAST_ID), and references several dimension-like parents such as resources, groups, categories, and currencies. This classification is offered as a modeling heuristic rather than a documented Oracle design principle.

Key Information Stored

The table contains 62 columns. The most operationally significant include:

• FORECAST_ID — Surrogate primary key, enforced by AS_INTERNAL_FORECASTS_PK and unique index AS_INTERNAL_FORECASTS_U1; the primary business-key candidate for identifying a forecast record.
• PERIOD_NAME and SUBMISSION_DATE — Identify the forecast period and the date the forecast was submitted.
• SALESFORCE_ID and EMPLOYEE_PERSON_ID — The sales resource and person associated with an individual-level forecast.
• SALES_GROUP_ID — The sales group associated with a group-level forecast.
• FORECAST_CATEGORY_ID — The forecast category definition.
• CURRENCY_CODE — Currency in which forecast amounts are expressed.
• WORST_FORECAST_AMOUNT, FORECAST_AMOUNT, BEST_FORECAST_AMOUNT — The core worst/forecast/best amount measures, each with a corresponding _FLAG column indicating inclusion.
• WEIGHTED_PIPELINE_AMOUNT, PIPELINE_AMOUNT, WON_PIPELINE_AMOUNT, QUOTA_AMOUNT — Pipeline-derived and quota measures, also flag-controlled.
• OPP_WORST_FORECAST_AMOUNT, OPP_FORECAST_AMOUNT, OPP_BEST_FORECAST_AMOUNT — Opportunity-scoped forecast amounts.
• ORIGINAL_FORECAST_ID — Self-referencing link to the originating forecast record.
• STATUS_CODE, ACTIVE_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE — Lifecycle and activation attributes.
• SECURITY_GROUP_ID — Used for multi-tenant/security grouping.
• OBJECT_VERSION_NUMBER and the standard WHO columns — Concurrency control and audit tracking.

The ATTRIBUTE1–ATTRIBUTE15 and ATTRIBUTE_CATEGORY columns provide the standard Oracle extensibility framework for customer-specific data.

Common Use Cases and Queries

Typical reporting scenarios include retrieving the latest forecast for a given period and sales representative, comparing forecast categories, and analyzing pipeline versus quota attainment.

Sample query — current forecast by representative and period:

• SELECT f.FORECAST_ID, f.PERIOD_NAME, f.SALESFORCE_ID, f.FORECAST_AMOUNT, f.BEST_FORECAST_AMOUNT, f.WORST_FORECAST_AMOUNT, f.QUOTA_AMOUNT FROM AS_INTERNAL_FORECASTS f WHERE f.PERIOD_NAME = :period AND f.ACTIVE_FLAG = 'Y' ORDER BY f.SALESFORCE_ID;

Sample query — group-level rollup joined to category:

• SELECT g.NAME, c.CATEGORY_NAME, f.FORECAST_AMOUNT FROM AS_INTERNAL_FORECASTS f, AS_FORECAST_CATEGORIES_B c, JTF_RS_GROUPS_B g WHERE f.FORECAST_CATEGORY_ID = c.CATEGORY_ID AND f.SALES_GROUP_ID = g.GROUP_ID AND f.PERIOD_NAME = :period;

Additional uses include reconciliations between summary forecasts and the detailed line-level data held in AS_FORECAST_WORKSHEETS, tracking forecast revisions via the ORIGINAL_FORECAST_ID self-join, and currency-normalized dashboards driven by CURRENCY_CODE.

Related Objects

• AS_FORECAST_WORKSHEETS — Child worksheet table; joins on FORECAST_ID (AS_FORECAST_WORKSHEETS.FORECAST_ID references AS_INTERNAL_FORECASTS.FORECAST_ID), holding the detailed line items that roll up into the summary.
• AS_FORECAST_CATEGORIES_B — Parent category definition; joins on FORECAST_CATEGORY_ID.
• JTF_RS_RESOURCE_EXTNS — Sales resource extension; joins on SALESFORCE_ID.
• JTF_RS_GROUPS_B — Sales group definition; joins on SALES_GROUP_ID.
• IGS_FI_CR_TYPES_ALL — Credit type reference; joins on CREDIT_TYPE_ID.
• FND_SECURITY_GROUPS — Security grouping; joins on SECURITY_GROUP_ID.
• AS_INTERNAL_FORECASTS (self-reference) — Parent/child revision chain via ORIGINAL_FORECAST_ID.