Results for “ozf_forecast_products”

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

Overview

OZF_FORECAST_PRODUCTS is a Trade Management (OZF) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores all products eligible for a specific version of a forecast. Within the Trade Management module, forecasts drive the planning, evaluation, and execution of trade promotions and offers; this table defines the product scope against which a forecast version is measured. Each row associates a forecast version with the products, pricing attributes, and pricing list lines that qualify for inclusion in that forecast.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is link. This is consistent with the table's role as an associative entity: it resolves relationships between a forecast version (through OBJ_ID and OBJ_TYPE pointing to OZF_WORKSHEET_HEADERS_B or OZF_OFFERS), pricing list lines (QP_LIST_LINES), products (FND_DM_PRODUCTS), and security groups (FND_SECURITY_GROUPS). Rather than describing an independent business entity, the table records which products participate in which forecast, making it a junction-style link table.

Key Information Stored

The table contains 16 documented columns. The most significant are:

• FORECAST_PRODUCT_ID — the surrogate primary key, enforced by OZF_FORECAST_PRODUCTS_PK and the unique index OZF_FORECAST_PRODUCTS_U1. This is the column most commonly referenced in queries and the value users search for when locating a specific forecast-product association.
• OBJ_ID and OBJ_TYPE — the polymorphic reference identifying the parent forecast context. OBJ_ID is documented as a foreign key to both OZF_OFFERS and OZF_WORKSHEET_HEADERS_B, so OBJ_TYPE distinguishes which parent the record belongs to.
• PRODUCT_ID — the foreign key to FND_DM_PRODUCTS, identifying the eligible product.
• LIST_LINE_ID — the foreign key to QP_LIST_LINES, tying the row to an Advanced Pricing list line.
• QP_LIST_HEADER_ID — the pricing list header associated with the product selection.
• PRICING_ATTRIBUTE_ID — references the pricing attribute that qualifies the product in the forecast context.
• PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE, and PRODUCT_ATTR_VALUE — a flexible descriptive flexfield-style triplet capturing additional product qualifying attributes.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, controlling data access.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — the standard EBS audit columns maintained by the application.

Because FORECAST_PRODUCT_ID is both the primary key and a unique-index candidate, it serves as the definitive business-key candidate for this table.

Common Use Cases and Queries

Typical scenarios include identifying all products associated with a given forecast version, resolving which pricing list lines drive forecast eligibility, and reporting product coverage across forecasts.

• Retrieve all products eligible for a forecast: SELECT PRODUCT_ID FROM OZF_FORECAST_PRODUCTS WHERE OBJ_ID = :forecast_id AND OBJ_TYPE = :obj_type;
• Locate a single association by surrogate key: SELECT * FROM OZF_FORECAST_PRODUCTS WHERE FORECAST_PRODUCT_ID = :forecast_product_id;
• Report product detail: join OZF_FORECAST_PRODUCTS.PRODUCT_ID = FND_DM_PRODUCTS.PRODUCT_ID to obtain product names.
• Audit pricing linkage: join OZF_FORECAST_PRODUCTS.LIST_LINE_ID = QP_LIST_LINES.LIST_LINE_ID to examine list line context.
• Security-filtered extracts: filter on SECURITY_GROUP_ID to enforce organization-level data access.

Related Objects

• OZF_OFFERS — referenced via OBJ_ID when the forecast context is an offer.
• OZF_WORKSHEET_HEADERS_B — referenced via OBJ_ID when the forecast context is a worksheet header.
• QP_LIST_LINES — referenced via LIST_LINE_ID for Advanced Pricing list lines.
• FND_DM_PRODUCTS — referenced via PRODUCT_ID for the product definition.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for access control.

Collectively these relationships confirm the table's function as the link between forecast versions, products, and pricing artifacts in Oracle Trade Management.