Search Results ozf_sd_util_pvt




Overview
Explore in AI Chat

Overview

OZF_SD_UTIL_PVT is an Oracle EBS Trade Management (formerly Oracle Channel Revenue Management, and historically Oracle Sales and Distribution/Claims) private utility package belonging to the APPS schema. In EBS 12.1.1 and 12.2.2 it underpins the deduction and supplier claims settlement workflow captured in the OZF_SD_* schema, where "SD" denotes Sales Deduction activity such as claim batches, batch lines, disputes, and postback processing. The package is classified as PVT (private), which means it is not a formally published public API; it is a supporting library of internal routines invoked by other OZF packages, workflows, and concurrent programs rather than by external integrations. Its header identifies the deployed source file as ozfvsdub.pls (version 120.17, dated 2008/05/02), confirming that the same foundational logic has been carried forward from the 11i heritage codebase into the 12.1.1 and 12.2.2 releases with minimal change. The package assembles a broad set of utility operations: currency conversion against utilization and batch records, date and timezone normalization between the R12 (RN) model and legacy database representations, stale request data cleanup, request price updates, batch adjustment and claim creation, penalty batch closure, event raising, and completion flag management.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions that fall into several functional clusters.

Tables Accessed

The package reads and writes the core deduction data model through APPS synonyms.

Usage Notes

Because OZF_SD_UTIL_PVT is a private package, it should not be called directly from external interfaces; Oracle does not guarantee its signature across patches. It is typically invoked from the OZF Sales Deduction forms, from concurrent programs that process deduction batches and supplier responses, from the deduction workflow through SD_RAISE_EVENT, and from the two other APPS packages documented as referencing it. The "ozf_sd_no_response" search term relates to the deduction response lifecycle that this package supports — specifically the logic around PROCESS_SD_RESPONSE, SD_RAISE_EVENT, and the completeness flag routines, which together determine when a supplier deduction or claim has received no response and trigger follow-up or stale-data handling. Debug behavior is influenced by the CLN_DEBUG_LEVEL profile option referenced in the package header. Any customization should invoke the public deduction APIs instead, leaving this utility package to Oracle-supplied code paths.