Search Results ozf_webadi_interface_pvt




Overview
Explore in AI Chat

Overview

OZF_WEBADI_INTERFACE_PVT is an Oracle EBS Application Programming Interface package owned by the APPS schema and classified as a private (PVT) API. It belongs to the Oracle Trade Management (OZF) product family, which is part of the broader Channel Revenue Management and Trade Management suite. The package serves as the server-side integration layer between Oracle WebADI (Web Applications Desktop Integrator) spreadsheet-based data entry and the OZF Trade Management resale batch processing engine. Its primary business function is to ingest resale and code-conversion data captured in WebADI desktop worksheets, stage that data in the OZF interface tables, and orchestrate the validation and transfer of resale lines and batch records into the transactional resale schema. In this capacity it acts as the bridge that allows business users to maintain high volumes of resale and channel data in a familiar spreadsheet format while enforcing EBS validation and processing rules.

Key Procedures and Functions

The ETRM repository documents five procedures and functions within this package:

  • CODE_CONVERSION_WEBADI — Handles WebADI-based upload and conversion of code conversion records, mapping external or spreadsheet-supplied codes to their internal OZF equivalents via the OZF_CODE_CONVERSIONS_ALL table.
  • RESALE_WEBADI — The principal entry point for resale WebADI uploads. It accepts resale data from the WebADI integrator and drives staging and processing against the resale batch and interface structures.
  • INSERT_RESALE_INT_LINE — Inserts new resale line records into the OZF_RESALE_LINES_INT interface table, preparing staged rows for downstream validation and transfer.
  • UPDATE_RESALE_INT_LINE — Updates existing staged resale line rows in the interface table, supporting corrections and re-processing of previously uploaded lines.
  • UPDATE_RESALE_BATCH — Updates resale batch header records, typically to reflect batch status changes or summary values following the processing of staged lines.

No parameter signatures are exposed in the documented metadata; parameter details should be obtained from the live package specification in the APPS schema.

Tables Accessed

The package reads and writes the core Trade Management resale and customer tables. OZF_RESALE_BATCHES_ALL and its sequence OZF_RESALE_BATCHES_ALL_S hold batch header data; OZF_RESALE_LINES_INT, OZF_RESALE_LINES_INT_ALL and OZF_RESALE_LINES_INT_ALL_S hold staged resale line interface data. OZF_CODE_CONVERSIONS_ALL supports the code-conversion procedure. Customer and party data is validated against HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_PARTIES and HZ_PARTY_SITES, the TCA (Trading Community Architecture) tables that identify customers and their sites. Utility objects DUAL and PLITBLM are used for PL/SQL table handling, and UTL_FILE is referenced, indicating the package may read or write operating-system files. FND_API is referenced for standard EBS API error-handling and message conventions, and OZF_PRE_PROCESS_PVT is referenced for pre-processing logic.

Usage Notes

OZF_WEBADI_INTERFACE_PVT is an internal/private package and is not intended for direct invocation by end users or custom code. It is invoked through Oracle WebADI integrator definitions and, in some flows, through concurrent programs or forms that submit resale and code-conversion data. The package is self-referenced within its own body, and the ETRM metadata lists zero other referencing packages, confirming its tightly scoped role within the OZF WebADI integration. Because FND_API is referenced, exceptions raised are returned through standard EBS API messaging rather than raw PL/SQL errors. When diagnosing WebADI upload failures, DBAs and developers typically enable FND_DEBUG and inspect the interface tables and FND log messages generated by this package. Customizations should extend behavior through the documented public OZF APIs rather than by modifying this private interface package.