Search Results upload_batch

Overview

APPS.FUN_WEBADI_PKG is a PL/SQL package in the Oracle E-Business Suite Financials product family (FUN application) that supports the WebADI (Web Applications Desktop Integrator) integration for Oracle Payables and related financials interfaces. WebADI provides users with an Excel-based desktop interface that uploads structured spreadsheet data into EBS interface tables. FUN_WEBADI_PKG serves as the server-side integration layer bridging the WebADI uploader and the underlying Payables interface schema owned by APPS.

The package is documented in ETRM with a status of VALID and is classified as an "OTHER" API type, meaning it is not exposed as a public, externally supported API but rather as an internal integration utility used by WebADI integration components, forms, and concurrent processing. Its primary responsibility is the orchestration of uploading, importing, and deleting batch data flowing from WebADI into the Payables interface tables and ultimately into the transaction tables.

Key Procedures and Functions

Three procedures are documented for this package:

• UPLOAD_BATCH — Handles the upload of batch data received from the WebADI uploader into the Payables interface tables. It validates and stages the uploaded rows, populating the interface headers, batches, and distribution lines structures required for subsequent import processing.
• IMPORT_BATCH — Drives the import of a staged batch from the interface tables into the final Payables transaction base tables. This converts interface rows into validated invoice, batch, and distribution records via the standard Payables import logic.
• DELETE_BATCH — Removes a previously uploaded or imported batch, cleaning up interface records and, where applicable, associated transaction records to maintain data integrity between the WebADI staging area and the Payables tables.

The metadata does not document parameter lists for these procedures, so they cannot be described here; only their functional purpose is specified.

Tables Accessed

FUN_WEBADI_PKG references a significant set of interface and base tables through APPS synonyms. Interface staging tables include FUN_INTERFACE_BATCHES, FUN_INTERFACE_HEADERS, FUN_INTERFACE_DIST_LINES, FUN_INTERFACE_CONTROLS, and FUN_INTERFACE_CONTROLS_S, which hold the uploaded WebADI data prior to import. Base transaction tables FUN_TRX_BATCHES_S, FUN_TRX_HEADERS, FUN_TRX_HEADERS_S, and FUN_DIST_LINES_S receive the validated, imported results.

Reference and lookup tables accessed include FND_APPLICATION (application context and security), FND_ID_FLEX_STRUCTURES (key flexfield metadata for accounting key derivation), HZ_PARTIES and HZ_PARTY_USG_ASSIGNMENTS (supplier and party identification for invoice validation), XLE_ENTITY_PROFILES (legal entity context in multi-org configurations), and DUAL (standard utilities). This table set confirms the package's role in supplier-facing invoice/transaction import within Oracle Payables.

Usage Notes

FUN_WEBADI_PKG is invoked primarily through the WebADI framework rather than directly by end users. The procedures are called by WebADI integration components when a user uploads a spreadsheet, triggers a batch import, or deletes a previously created batch. It is also invoked by concurrent programs and forms that surface the Payables WebADI uploader, such as the Payables invoice entry WebADI integrator.

Because the package is classified as OTHER and is not documented as a public API, it should not be called directly from custom code except with caution and Oracle support guidance. Customers extending WebADI-based Payables uploads typically interact with it indirectly via configured integrators or menu functions. Referenced by zero other packaged objects, it sits at the top of its dependency chain and depends on the FUN interface schema. When troubleshooting WebADI upload failures in Payables, this package and its referenced interface tables are the appropriate starting points for diagnosis.