Search Results ozf_refresh_sales_pvt




Overview
Explore in AI Chat

Overview

OZF_REFRESH_SALES_PVT is a private (PVT) PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Trade Management (formerly Oracle Sales Compensation and channel revenue management) product family, whose objects use the OZF prefix. The package provides the internal implementation layer that supports the refresh of sales transaction data within the Trade Management data model. Its principal procedure, LOAD, is responsible for populating and reconciling rows in the sales transaction staging and base tables, drawing order and customer information from the Order Management and Receivables schemas.

The PVT designation indicates that this is a private package, intended for invocation by other APPS packages or concurrent programs rather than as a published public API. The ETRM metadata records its status as VALID and confirms that it depends only on the SYS.STANDARD package, while being referenced by itself and by other APPS objects.

Key Procedures and Functions

The documented interface of OZF_REFRESH_SALES_PVT consists of four program units:

  • LOAD — The primary driver procedure. It performs the bulk refresh of sales transaction records, reading source order and customer data and writing the corresponding rows into the OZF sales transaction tables. This is the entry point through which the refresh cycle is executed.
  • GET_PRIMARY_UOM — A helper function that returns the primary unit of measure associated with an inventory item. It resolves the UOM from the item master so that sales quantities are stored consistently.
  • GET_PARTY_ID — A helper function that resolves the trading partner party identifier, typically from the HZ customer model, for use in associating sales transactions with the correct party.
  • GET_PARTY_SITE_ID — A helper function that resolves the specific party site identifier, supporting site-level attribution of sales transactions.

No parameter lists are documented in the ETRM metadata; the descriptions above reflect the documented purpose of each unit only.

Tables Accessed

The package operates across several documented tables accessed through APPS synonyms:

Usage Notes

As a private package, OZF_REFRESH_SALES_PVT is not intended for direct invocation by end users or external integrations. It is characteristically called from the Trade Management sales transaction refresh concurrent program, from Oracle Forms-based maintenance screens, or from other APPS packages that orchestrate the refresh cycle. The ETRM metadata states that the package is referenced by zero other packages at the time of documentation, meaning custom code should avoid assuming a stable public contract. Oracle support and upgrade considerations apply: modifications to the package body may be overwritten by patching, and any direct call should be validated against the specific 12.1.1 or 12.2.2 patch level in use.