Results for “ozf_sys_parameters_all_pk”

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

Overview

OZF_SYS_PARAMETERS_ALL is a Trade Management (OZF) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the system-level parameters that govern how Trade Management claims, deductions, accruals, and promotional transactions are processed and interfaced to Oracle General Ledger. As the description states, its central purpose is to hold "system parameters for General Ledger interface," meaning that the accounting rules, transaction types, reason codes, and settlement options recorded here drive how trade management activity is posted to the ledger.

The table is multi-organization aware. Its unique index OZF_SYS_PARAMETERS_ALL_U1 is defined on (ORG_ID, SET_OF_BOOKS_ID), indicating that one parameter row is maintained per operating unit and ledger combination. The physical table contains 98 documented columns, comprising business configuration attributes alongside standard EBS audit columns (WHO columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and the ORACLE-style OBJECT_VERSION_NUMBER used for optimistic locking). From a modeling perspective, the heuristic Data Vault classification is satellite-leaning: the table primarily carries descriptive configuration attributes attached to ledger and operating unit keys rather than acting as a transaction hub or a link between entities.

Key Information Stored

The surrogate primary key is OZF_SYS_PARAMETERS_ALL_PK, defined on SET_OF_BOOKS_ID. The documented business-key candidate is the unique constraint OZF_SYS_PARAMETERS_ALL_U1 on (ORG_ID, SET_OF_BOOKS_ID). The most operationally significant columns include:

• SET_OF_BOOKS_ID — the ledger identifying the set of books for which parameters apply; the primary key.
• ORG_ID — the operating unit, forming the second component of the business key.
• POST_TO_GL and TRANSFER_TO_GL_IN — control whether and when trade management transactions are transferred to the GL interface.
• ACCOUNTING_METHOD_OPTION and GL_DATE_TYPE — determine the accounting basis and the date source used for GL posting lines.
• GL_ID_ROUNDING, GL_ID_DED_CLEARING, GL_ID_DED_ADJ, GL_ID_ACCR_PROMO_LIAB, and GL_ID_DED_ADJ_CLEARING — the GL account identifiers for rounding, deduction clearing, deduction adjustment, and accrual/promotion liability postings.
• CLAIM_TYPE_ID, REASON_CODE_ID, AUTOPAY_CLAIM_TYPE_ID, and AUTOPAY_REASON_CODE_ID — the default claim and reason classifications, including those applied by automatic payment processing.
• AUTOPAY_FLAG, AUTOPAY_PERIODICITY, and AUTOPAY_PERIODICITY_TYPE — govern whether claims are paid automatically and at what recurrence.
• ORDER_TYPE_ID — the order type used when trade management activity generates or references order-based transactions.
• EXCHANGE_RATE_TYPE — the rate type applied to foreign currency conversions during processing.
• BATCH_SOURCE_ID and PAYABLES_SOURCE — the batch source and payables source used for payable generation.

Additional columns support accrual flags, tolerance thresholds, quota units, credit matching, and adjustment type identifiers.

Common Use Cases and Queries

The table is most commonly queried to retrieve the GL interface configuration for a specific operating unit and ledger, to diagnose accounting outcomes, or to confirm that automatic claim payment is enabled. A representative lookup joins the table to FND_ORGANIZATION_UNITS or uses ORG_ID directly:

• Retrieve posting options and accounting method:
  SELECT org_id, set_of_books_id, post_to_gl, transfer_to_gl_in, accounting_method_option, gl_date_type FROM ozf_sys_parameters_all WHERE org_id = :p_org_id;
• Confirm autopayment configuration:
  SELECT autopay_flag, autopay_claim_type_id, autopay_reason_code_id, autopay_periodicity, autopay_periodicity_type FROM ozf_sys_parameters_all WHERE set_of_books_id = :p_ledger;
• Cross-check GL account mappings used for deductions and accruals:
  SELECT gl_id_rounding, gl_id_ded_clearing, gl_id_ded_adj, gl_id_accr_promo_liab, gl_id_ded_adj_clearing FROM ozf_sys_parameters_all WHERE org_id = :p_org_id AND set_of_books_id = :p_ledger;

Reporting scenarios include validating accrual and settlement postings, auditing whether automatic payment settings are consistent across operating units, and supplying default transaction attributes when claims are created programmatically.

Related Objects

The table participates in a defined set of foreign key relationships. The most significant related objects are:

• OZF_CLAIM_TYPES_ALL_B — referenced through CLAIM_TYPE_ID and AUTOPAY_CLAIM_TYPE_ID; supplies claim type definitions.
• OZF_REASON_CODES_ALL_B — referenced through REASON_CODE_ID and AUTOPAY_REASON_CODE_ID; supplies reason code definitions.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID; controls row-level security scope.
• SO_ORDER_TYPES_115_ALL — referenced through ORDER_TYPE_ID; supplies order type definitions used in order-linked trade transactions.
• OZF_CLAIMS_ALL — references this table through SET_OF_BOOKS_ID, meaning claims inherit the ledger context defined by these parameters.

These relationships confirm that OZF_SYS_PARAMETERS_ALL functions as a configuration satellite anchored to the ledger and operating unit keys, with dependent transaction data in OZF_CLAIMS_ALL inheriting its ledger scope.