Search Results ozf_worksheet_lines




Overview
Explore in AI Chat

Overview

The OZF_WORKSHEET_LINES table is a core data structure within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the transactional repository for individual discount lines associated with a trade promotion worksheet. The table's primary role is to store the detailed, line-level components of a worksheet, which is a key tool for planning, analyzing, and managing promotional discounts and funds. Each record in this table represents a specific discount proposal or calculation tied to a parent worksheet header, enabling users to model complex trade deals with multiple line items.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary and foreign keys, the table's structure is designed to capture essential details for each worksheet line item. The primary identifier is the WORKSHEET_LINE_ID, a unique system-generated key. The critical foreign key column is WORKSHEET_HEADER_ID, which links each line to its parent document in the OZF_WORKSHEET_HEADERS_B table. Typically, other columns in such a table would store data points like the discount amount or percentage, the product or product hierarchy the discount applies to, the applicable currency, accrual or payout rates, and status flags. These columns collectively define the financial and operational parameters of a single promotional discount line within a worksheet.

Common Use Cases and Queries

This table is central to reporting and data extraction for trade promotion analysis. Common use cases include generating detailed listings of all discount lines for a specific worksheet or a set of worksheets, aggregating total proposed discount values by product category or customer, and auditing changes to worksheet line items over time. A typical query would join OZF_WORKSHEET_LINES to its parent header table to provide context. For example:

  • Retrieve all lines for a specific worksheet: SELECT * FROM ozf.ozf_worksheet_lines WHERE worksheet_header_id = <header_id>;
  • Join to header for a consolidated report: SELECT h.worksheet_number, l.* FROM ozf.ozf_worksheet_headers_b h, ozf.ozf_worksheet_lines l WHERE h.worksheet_header_id = l.worksheet_header_id AND h.status = 'APPROVED';

Data from this table feeds into analyses of promotion effectiveness, budget consumption, and fund liability.

Related Objects

The OZF_WORKSHEET_LINES table has defined dependencies within the OZF schema, primarily through its foreign key relationship. As documented:

  • Primary Key Constraint: OZF_WORKSHEET_LINES_PK on column WORKSHEET_LINE_ID.
  • Foreign Key Relationship: The column WORKSHEET_HEADER_ID references the OZF_WORKSHEET_HEADERS_B table. This is the fundamental parent-child relationship, ensuring every discount line is associated with a valid worksheet header. All data integrity and cascading operations between the header and its lines are governed by this constraint.

This table is also likely referenced by various Trade Management application forms, concurrent programs, and PL/SQL APIs within the OZF module for creating, updating, and processing worksheet lines, though these are not explicitly listed in the provided metadata.