Search Results ozf_rule_based_log_s

Overview

OZF_CLAIM_UTILITY_PVT is a private (PVT) PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified within the Oracle Trade Management (formerly Oracle Channel Revenue Management / OZF) module. The package provides shared internal utilities that support claim processing, claim access validation, customer and credit reference normalization, and the initiation of rule-based claim settlement. It is not a public API and is not referenced by any other database object at the top level; instead, it acts as a supporting library invoked by the claim-related public packages such as OZF_CLAIM_PVT, OZF_CLAIM_LINE_PVT, and OZF_CLAIM_ACCRUAL_PVT. The presence of OZF_RULE_BASED_LOG and its sequence OZF_RULE_BASED_LOG_S among its dependencies confirms its role in writing diagnostic and audit records whenever rule-based settlement logic executes, which is directly relevant to the user search term "ozf_rule_based_log_s."

Key Procedures and Functions

The documented package exposes five procedures/functions:

• CHECK_CLAIM_ACCESS — Validates whether the current user has the required access privileges to a given claim, typically by evaluating responsibility and profile-based security through AMS_ACCESS_PVT and FND_GLOBAL.
• NORMALIZE_CUSTOMER_REFERENCE — Standardizes customer identifier data, reconciling values against the TCA model (HZ_CUST_ACCT_RELATE_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL) so that claim records store consistent customer references.
• NORMALIZE_CREDIT_REFERENCE — Similarly normalizes credit/transaction references, using AR_PAYMENT_SCHEDULES_ALL, RA_CUSTOMER_TRX_ALL, and RA_CUST_TRX_TYPES_ALL to align claim credit data with receivables records.
• START_RULE_BASED_SETTLEMENT — Initiates the rule-based settlement process for a claim, orchestrating the evaluation of offer rules (OZF_OFFERS) and writing results to OZF_RULE_BASED_LOG via the CREATE_LOG routine.
• CREATE_LOG — Inserts a diagnostic or audit row into OZF_RULE_BASED_LOG, relying on the OZF_RULE_BASED_LOG_S sequence for the primary key, and records settlement or evaluation activities for troubleshooting and traceability.

Tables Accessed

The package reads and writes claim data through OZF_CLAIMS_ALL and OZF_CLAIM_LINES_ALL, and accesses utility line data in OZF_CLAIM_LINES_UTIL_ALL. Offer definitions are read from OZF_OFFERS, and system behavior is controlled through OZF_SYS_PARAMETERS_ALL. Receivables integration uses AR_PAYMENT_SCHEDULES_ALL, RA_CUSTOMER_TRX_ALL, and RA_CUST_TRX_TYPES_ALL, while customer data comes from the HZ_CUST_* tables. The rule-based logging tables OZF_RULE_BASED_LOG and OZF_RULE_BASED_LOG_S are central to this package's diagnostic role.

Usage Notes

Because this is a PVT package, it should not be called directly from custom code; developers should use the corresponding public APIs (OZF_CLAIM_PVT, OZF_CLAIM_LINE_PVT). It is invoked internally during claim entry, claim validation, and rule-based settlement processing from Oracle Trade Management forms and concurrent programs. The OZF_RULE_BASED_LOG_S sequence supplies keys for the log table, enabling DBAs and support analysts to trace rule evaluation outcomes when diagnosing settlement issues.