Search Results ozf_forecast_products




Overview
Explore in AI Chat

Overview

The OZF_FORECAST_PRODUCTS table is a core data object within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a junction or eligibility table, central to the forecasting functionality. Its primary role is to define and maintain the association between a specific forecast version and the inventory items or products that are eligible to be included in that forecast. This table ensures that forecast calculations, analyses, and worksheets are scoped to a relevant and manageable set of products, enabling more accurate planning and budgeting for trade promotions and marketing activities.

Key Information Stored

While the provided ETRM excerpt does not list all columns, the documented structure reveals critical identifiers. The primary key, FORECAST_PRODUCT_ID, uniquely identifies each product-forecast association record. A central column is OBJ_ID, which acts as a foreign key linking the product eligibility list to its parent forecast definition. This OBJ_ID likely references a forecast header or version. Other columns, typical for such a table, would include identifiers for the product itself (e.g., INVENTORY_ITEM_ID, PRODUCT_ORG_ID), potentially a sequence number for ordering, and standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

The primary use case is to retrieve the list of products configured for a specific forecast, which is essential for generating forecast worksheets and running analytical reports. A common query pattern involves joining to inventory tables to get product details. For example, to list all eligible products for a forecast with a specific OBJ_ID:

  • SELECT mp.organization_code, msi.segment1 item_code, msi.description FROM ozf_forecast_products ofp, mtl_system_items_b msi, mtl_parameters mp WHERE ofp.obj_id = <forecast_obj_id> AND ofp.inventory_item_id = msi.inventory_item_id AND ofp.organization_id = msi.organization_id AND msi.organization_id = mp.organization_id ORDER BY ofp.sequence_number;

This table is also critical for validation, ensuring that transactions or worksheet entries are only created for authorized products, maintaining data integrity within the forecast.

Related Objects

The documented foreign key relationships explicitly define how OZF_FORECAST_PRODUCTS integrates with other core Trade Management tables. The OBJ_ID column is the key linking mechanism:

  • OZF_OFFERS: This relationship suggests that a forecast product list (via OBJ_ID) can be associated with a trade offer, potentially for budgeting or performance comparison against forecasted values.
  • OZF_WORKSHEET_HEADERS_B: This is a fundamental relationship. A forecast worksheet header (representing a user's forecast calculation instance) references a specific product eligibility list via OBJ_ID, ensuring the worksheet is populated only with the predefined set of forecast products.

These relationships position OZF_FORECAST_PRODUCTS as a shared master list of products that can be utilized by both planning (worksheets) and execution (offers) entities within the OZF module.