Search Results ozf_sys_parameters_all

Overview

The OZF_SYS_PARAMETERS_ALL table is a core setup and configuration entity within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary role is to store system-level parameters that govern the integration between Trade Management and the General Ledger. As a multi-organization table (indicated by the "_ALL" suffix), it holds configuration data specific to each operating unit, linked via the SET_OF_BOOKS_ID (Chart of Accounts ID). This table acts as a central control point for defining default claim types, reason codes, and other critical attributes used in the automated processing and accounting of trade promotions and claims.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships. The primary key, SET_OF_BOOKS_ID, uniquely identifies the configuration for a specific ledger. The most significant data points stored are foreign key references to other setup tables, which establish defaults for transactional processing. Based on the provided metadata, key columns include CLAIM_TYPE_ID and REASON_CODE_ID, which define standard defaults. Furthermore, the table stores parameters for automated payment processes via AUTOPAY_CLAIM_TYPE_ID and AUTOPAY_REASON_CODE_ID. While the specific descriptive parameter columns are not detailed in the excerpt, the table's defined purpose confirms it holds the necessary configuration to control the GL interface, such as default accounts and journal posting rules.

Common Use Cases and Queries

This table is primarily accessed during the initial implementation and maintenance of OZF to configure ledger-specific defaults. A common operational use case is the validation of setup; for instance, ensuring that the default claim type referenced is active. A typical diagnostic query would join to the referenced setup tables to review the configured values for a given ledger:

• SELECT ozf_spa.set_of_books_id, ozf_ctb.claim_type_name, ozf_rcb.reason_code_name FROM ozf_sys_parameters_all ozf_spa, ozf_claim_types_all_b ozf_ctb, ozf_reason_codes_all_b ozf_rcb WHERE ozf_spa.claim_type_id = ozf_ctb.claim_type_id AND ozf_spa.reason_code_id = ozf_rcb.reason_code_id AND ozf_spa.set_of_books_id = :ledger_id;

This table is also critical for background processes that generate accounting entries for claims, as these processes read the configured GL interface parameters to determine the correct accounting treatment.

Related Objects

The OZF_SYS_PARAMETERS_ALL table is centrally connected to several key Trade Management objects, as documented by its foreign key constraints.

• Referenced By (Incoming FK): The OZF_CLAIMS_ALL table references this table via SET_OF_BOOKS_ID, linking every claim to the system parameters of its ledger.
• References (Outgoing FKs): This table references two critical setup tables:
  • OZF_CLAIM_TYPES_ALL_B: Linked twice for CLAIM_TYPE_ID and AUTOPAY_CLAIM_TYPE_ID.
  • OZF_REASON_CODES_ALL_B: Linked twice for REASON_CODE_ID and AUTOPAY_REASON_CODE_ID.

These relationships enforce data integrity, ensuring that the default IDs configured in the parameters table are valid within their respective setup entities.