Search Results ozf_worksheet_headers_b




Overview
Explore in AI Chat

Overview

The OZF_WORKSHEET_HEADERS_B table is a core data object within the Oracle E-Business Suite (EBS) Trade Management module (OZF). It serves as the primary repository for header-level information for worksheets, which are fundamental tools for planning, forecasting, and managing trade promotions and funds. This table acts as the central parent record, uniquely identifying each worksheet and providing its structural and contextual metadata. Its integrity is critical for the downstream processes of trade promotion budgeting, forecasting, and performance analysis across both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as WORKSHEET_HEADER_ID. This unique identifier is the central reference point for all related data. Based on its role as a header table in the OZF schema, it typically stores attributes that define the worksheet's purpose and lifecycle. Common columns in such a structure would include creation and last update dates, the creating user, the worksheet's status (e.g., Draft, Submitted, Approved), its type (e.g., Forecast, Budget), associated period or fiscal information, and references to the organizational context, such as ORG_ID. The header record establishes the framework for the detailed line items stored in child tables.

Common Use Cases and Queries

This table is central to reporting and data extraction for trade management analytics. A primary use case involves generating a list of all worksheets within a specific date range or organizational unit for audit or review purposes. Another common scenario is joining the header to its lines to analyze aggregated forecast or budget data. For instance, a query to summarize worksheet statuses by organization would leverage this table. Sample SQL patterns often involve filtering on status and creation date, and joining to the translated table (OZF_WORKSHEET_HEADERS_TL) for descriptive name retrieval:

  • SELECT wh.WORKSHEET_HEADER_ID, wht.NAME, wh.STATUS, wh.CREATION_DATE FROM OZF_WORKSHEET_HEADERS_B wh, OZF_WORKSHEET_HEADERS_TL wht WHERE wh.WORKSHEET_HEADER_ID = wht.WORKSHEET_HEADER_ID AND wh.ORG_ID = :p_org_id;

Related Objects

The OZF_WORKSHEET_HEADERS_B table has extensive relationships within the Trade Management schema, as documented by its foreign key constraints. It is the parent table for several key transactional and setup entities: