Search Results start_process_resale




Overview
Explore in AI Chat

Overview

OZF_RESALE_PVT is a private PL/SQL package in the APPS schema that implements the core business logic for the Oracle Trade Management (formerly Oracle Sales for Handhelds / Trade Management) resale and chargeback settlement process. The package belongs to the OZF module, which manages trade promotions, accruals, and channel rebate processing. In Oracle EBS 12.1.1 and 12.2.2, this package serves as the internal engine that supports resale processing — the mechanism by which distributors or resellers submit point-of-sale and inventory data, and the system computes eligible resale or chargeback amounts against trade promotion offers.

The "PVT" suffix indicates that OZF_RESALE_PVT is a private implementation package. It is not intended to be called directly by external consumers; instead, it is wrapped by the public API package OZF_RESALE_PUB, which exposes a supported interface. The package delegates generic cross-module utilities to the Oracle Application Object Library API (FND_API) and relies on the standard PL/SQL package (STANDARD) provided by the database. ETRM documents the package as VALID in the APPS schema.

Key Procedures and Functions

ETRM documents ten procedures and functions within OZF_RESALE_PVT. Each is named and described below; parameter signatures are intentionally omitted, as the package is private and its interface may change between patch levels.

  • INITIATE_PAYMENT — Initiates payment processing for a resale batch, driving settlement of the amounts determined during resale processing.
  • INITIATE_PAYMENT_WFL — The workflow-enabled variant of payment initiation, invoked from Oracle Workflow so that the process can be resumed or retried asynchronously.
  • PROCESS_IFACE — Processes the open resale interface records, validating and transforming staged data into the resale transaction tables.
  • PROCESS_IFACE_WFL — The workflow-enabled counterpart of PROCESS_IFACE, invoked from a Workflow background process.
  • PROCESS_RESALE — The central routine that performs resale calculation and validation against trade promotion offers, populating resale lines and logs.
  • START_PROCESS_RESALE — Entry-point orchestration that initiates the resale processing run (typically invoked after interface processing completes).
  • PURGE — Removes obsolete resale interface, batch, and log records according to retention rules.
  • START_PURGE — Orchestration entry point that launches the purge operation.

Several procedures provide paired "plain" and "_WFL" variants, reflecting the standard Oracle pattern of allowing a process to be driven either synchronously or from Oracle Workflow.

Tables Accessed

The package reads and writes the following documented tables (referenced through APPS synonyms):

  • OZF_RESALE_BATCHES / OZF_RESALE_BATCHES_ALL — Header records for resale processing runs (batches), including status and control information.
  • OZF_RESALE_LINES_INT / OZF_RESALE_LINES_INT_ALL — The staging interface tables holding inbound resale/point-of-sale line data before validation and processing.
  • OZF_RESALE_LOGS_ALL — Diagnostic and audit log records generated during processing, used for troubleshooting and reconciliation.
  • WF_PARAMETER_LIST_T — Workflow parameter list structure used by the workflow-enabled procedures.
  • DBMS_XMLGEN — Oracle-supplied utility used to generate XML payloads.
  • PLITBLM — Oracle-supplied PL/SQL table manipulation utilities.

Usage Notes

OZF_RESALE_PVT is a private package and is not a supported integration point. It is referenced by the public API OZF_RESALE_PUB, by the workflow private package OZF_RESALE_WF_PVT, and recursively by itself, confirming that OZF_RESALE_PUB is the supported entry point for custom code. In standard EBS operation, resale processing is invoked through the Trade Management concurrent programs and associated Oracle Workflow processes, which call the public API and ultimately delegate to this private package. Customers should not call OZF_RESALE_PVT directly; doing so risks breakage on patching or upgrade from 12.1.1 to 12.2.2. Any custom integration should target OZF_RESALE_PUB and its documented public procedures.