Search Results ozf_na_rule_headers_b




Overview
Explore in AI Chat

Overview

The OZF_NA_RULE_HEADERS_B table is a core data structure within the Oracle E-Business Suite (EBS) Trade Management module (OZF). It serves as the primary repository for storing the header-level definition of Net Accrual Rule sets. In the context of trade promotions and funds management, a Net Accrual Rule set is a critical business object that defines the logic and parameters for calculating the net financial accruals or liabilities associated with promotional offers and trade deals. This table functions as the master entity, holding the unique identifier and control attributes for each rule set, which are then detailed by related child tables. Its role is foundational to the accurate financial accounting and settlement of trade promotions within the application.

Key Information Stored

The table's primary purpose is to uniquely identify and manage rule sets. The most critical column is the NA_RULE_HEADER_ID, which is the primary key (OZF_NA_RULE_HEADERS_B_PK) and serves as the unique identifier for each Net Accrual Rule set. This ID is the foreign key referenced by all dependent objects. While the provided ETRM metadata does not list other specific columns, typical header tables in this context would also store control attributes such as the rule set name, an active date range (START_DATE_ACTIVE, END_DATE_ACTIVE), an enabled flag, the creation and last update dates, and the user who created the rule. The transactional language-specific descriptions are stored in the related translation table, OZF_NA_RULE_HEADERS_TL.

Common Use Cases and Queries

This table is central to queries involving the setup and application of Net Accrual rules. Common use cases include auditing which rule sets are applied to specific offers, validating rule set configurations, and generating reports on rule usage. A fundamental query retrieves the header information for a rule set linked to a specific offer, often joining through the OZF_OFFERS table. For example:

  • Identifying the Net Accrual Rule for an Offer: SELECT o.offer_number, h.na_rule_header_id FROM ozf_offers o, ozf_na_rule_headers_b h WHERE o.na_rule_header_id = h.na_rule_header_id AND o.offer_id = :p_offer_id;
  • Listing all active rule sets: SELECT na_rule_header_id FROM ozf_na_rule_headers_b WHERE sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate+1) AND enabled_flag = 'Y';

Analytical reporting often involves aggregating data from this header table with its lines (OZF_NA_RULE_LINES) to understand the complete rule logic.

Related Objects

The OZF_NA_RULE_HEADERS_B table is a key parent entity with several important relationships, as documented in the ETRM metadata. The primary foreign key dependencies are:

  • OZF_NA_RULE_HEADERS_TL: Holds the translated, language-specific names and descriptions for the rule set, linked via NA_RULE_HEADER_ID.
  • OZF_NA_RULE_LINES: Contains the detailed line-level criteria and actions that constitute the rule set's logic. Each line is associated with a parent header through NA_RULE_HEADER_ID.
  • OZF_OFFERS: The central offers table references a Net Accrual Rule set via its NA_RULE_HEADER_ID column, applying the defined accrual logic to the promotion.

This structure ensures that a single, consistently defined rule set can be applied to multiple offers and is maintained in a normalized, multilingual-capable manner.

  • Table: OZF_NA_RULE_HEADERS_B 12.2.2

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_NA_RULE_HEADERS_B,  object_name:OZF_NA_RULE_HEADERS_B,  status:VALID,  product: OZF - Trade Management ,  description: Table To store the Net Accrual Rule sets ,  implementation_dba_data: OZF.OZF_NA_RULE_HEADERS_B , 

  • Table: OZF_NA_RULE_HEADERS_B 12.1.1

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_NA_RULE_HEADERS_B,  object_name:OZF_NA_RULE_HEADERS_B,  status:VALID,  product: OZF - Trade Management ,  description: Table To store the Net Accrual Rule sets ,  implementation_dba_data: OZF.OZF_NA_RULE_HEADERS_B , 

  • Table: OZF_NA_RULE_HEADERS_TL 12.1.1

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_NA_RULE_HEADERS_TL,  object_name:OZF_NA_RULE_HEADERS_TL,  status:VALID,  product: OZF - Trade Management ,  description: Table To store the translated Net Accrual Rule Sets ,  implementation_dba_data: OZF.OZF_NA_RULE_HEADERS_TL , 

  • Table: OZF_NA_RULE_HEADERS_TL 12.2.2

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_NA_RULE_HEADERS_TL,  object_name:OZF_NA_RULE_HEADERS_TL,  status:VALID,  product: OZF - Trade Management ,  description: Table To store the translated Net Accrual Rule Sets ,  implementation_dba_data: OZF.OZF_NA_RULE_HEADERS_TL , 

  • Table: OZF_NA_RULE_LINES 12.1.1

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_NA_RULE_LINES,  object_name:OZF_NA_RULE_LINES,  status:VALID,  product: OZF - Trade Management ,  description: Table to store the Deduction rules for a Net accrual Rule Set ,  implementation_dba_data: OZF.OZF_NA_RULE_LINES , 

  • Table: OZF_NA_RULE_LINES 12.2.2

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_NA_RULE_LINES,  object_name:OZF_NA_RULE_LINES,  status:VALID,  product: OZF - Trade Management ,  description: Table to store the Deduction rules for a Net accrual Rule Set ,  implementation_dba_data: OZF.OZF_NA_RULE_LINES , 

  • Table: OZF_OFFERS 12.2.2

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_OFFERS,  object_name:OZF_OFFERS,  status:VALID,  product: OZF - Trade Management ,  description: This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, peformance dates and lumpsum related offer types. ,  implementation_dba_data: OZF.OZF_OFFERS , 

  • Table: OZF_OFFERS 12.1.1

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_OFFERS,  object_name:OZF_OFFERS,  status:VALID,  product: OZF - Trade Management ,  description: This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, peformance dates and lumpsum related offer types. ,  implementation_dba_data: OZF.OZF_OFFERS ,