Search Results as_prod_worksheet_lines




Overview
Explore in AI Chat

Overview

The AS_PROD_WORKSHEET_LINES table is a core data repository within the Oracle E-Business Suite Sales Foundation (AS) module. It functions as the primary storage entity for detailed forecast and quota information across all potential product categories. Its role is to capture granular planning data, enabling sales managers and representatives to forecast revenue and set targets either for individual salespeople or for entire sales groups. This table is integral to the sales performance management and forecasting workflows in both Oracle EBS 12.1.1 and 12.2.2, providing the line-level detail that feeds into higher-level summaries and analytical reports.

Key Information Stored

The table's primary key is the PROD_WORKSHEET_LINE_ID, a unique identifier for each forecast line item. As indicated by its foreign key relationships, the table stores several critical pieces of information that link it to other master data entities. Each record is associated with a specific forecast worksheet (via FORECAST_WORKSHEET_ID), a defined sales quota (via SALES_QUOTA_ID), and a particular product or sales category (via FST_SALES_CATEGORY_ID). While the provided metadata does not list all columns, the table's purpose implies it holds quantitative forecast data—such as projected revenue, units, or probability—for the specified category within the context of the linked worksheet and quota.

Common Use Cases and Queries

This table is central to generating detailed forecast versus quota performance reports. A common use case involves analyzing forecast accuracy by comparing worksheet line items against actual sales or finalized quota targets. Administrators may also query this table to audit or adjust forecast submissions. A typical reporting query would join this table to its related master tables to provide context. For example:

  • SELECT wl.prod_worksheet_line_id, wl.forecast_worksheet_id, sq.quota_name, cat.name, wl.forecast_amount FROM osm.as_prod_worksheet_lines wl, osm.as_sales_quotas sq, osm.as_fst_sales_categories cat WHERE wl.sales_quota_id = sq.sales_quota_id AND wl.fst_sales_category_id = cat.fst_sales_category_id AND sq.quota_period = 'JAN-2024';

This would retrieve forecast line details for a specific quota period, showing the associated quota and category names.

Related Objects

The AS_PROD_WORKSHEET_LINES table maintains documented foreign key relationships with three key master data tables in the Sales Foundation schema, establishing its position in the data model:

  • AS_SALES_QUOTAS: Linked via AS_PROD_WORKSHEET_LINES.SALES_QUOTA_ID. This relationship ties each forecast line to a formal sales target or quota definition.
  • AS_FORECAST_WORKSHEETS: Linked via AS_PROD_WORKSHEET_LINES.FORECAST_WORKSHEET_ID. This connects the line items to the parent forecast worksheet or planning document.
  • AS_FST_SALES_CATEGORIES: Linked via AS_PROD_WORKSHEET_LINES.FST_SALES_CATEGORY_ID. This associates each forecasted amount with a specific product or sales category within the forecasting hierarchy.