Search Results fun_interface_controls_s

Overview

FUN_WEBADI_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Financials for the WebADI interface layer. Its role is to provide the server-side programmatic bridge that allows Oracle WebADI (Web Applications Desktop Integrator) spreadsheet integrations to load, validate, and reverse Accounts Payable batches into the underlying Payables transaction tables. The package supports the ETRM-relevant upload path in which external or desktop-originated data is staged into the FUN interface tables, processed through the standard Payables transaction APIs, and then committed to the live FUN_TRX tables.

In Oracle EBS 12.1.1 and 12.2.2, WebADI is the primary spreadsheet upload mechanism for Payables invoices, payments, and related transactions. FUN_WEBADI_PKG encapsulates the orchestration logic required to move data from those spreadsheets into the interface schema and to trigger the concurrent import process. It is a thin, integration-oriented package rather than a general-purpose Payables utility, and it depends on the standard Payables public and private APIs (FUN_TRX_PUB, FUN_TRX_PVT, FUN_TRX_ENTRY_UTIL) and on FND infrastructure services for messaging, global context, and key flexfield validation.

Key Procedures and Functions

The ETRM metadata documents three procedures in this package body:

• UPLOAD_BATCH — Accepts the batch payload delivered through the WebADI upload context and stages transaction header, distribution, and control information into the FUN interface tables. This procedure is the entry point for desktop-originated data and prepares the record set for import.
• IMPORT_BATCH — Invokes the Payables import logic against the staged interface rows. It drives validation and conversion of interface records into live Payables transactions, leveraging the transaction APIs and message publication facilities to report errors and status.
• DELETE_BATCH — Removes a previously uploaded or imported batch, cleaning up the interface rows and related staging records. This supports correction and re-upload workflows initiated from the WebADI spreadsheet.

No parameter lists are documented in the ETRM metadata, and none should be assumed. The procedures are consumed internally by the WebADI integration framework rather than called directly by end users.

Tables Accessed

The package references the FUN interface and transaction tables central to Payables batch processing, via APPS synonyms:

• FUN_INTERFACE_BATCHES, FUN_INTERFACE_HEADERS, FUN_INTERFACE_CONTROLS, FUN_INTERFACE_CONTROLS_S, FUN_INTERFACE_DIST_LINES — the staging structures into which UPLOAD_BATCH writes and from which IMPORT_BATCH reads. FUN_INTERFACE_CONTROLS and its sequence FUN_INTERFACE_CONTROLS_S are the control and numbering objects the user searched on and are central to batch identity and grouping.
• FUN_TRX_BATCHES_S, FUN_TRX_HEADERS, FUN_TRX_HEADERS_S, FUN_DIST_LINES_S — the live Payables transaction and sequence objects that import populates once validation succeeds.
• HZ_PARTIES, HZ_PARTY_USG_ASSIGNMENTS, XLE_ENTITY_PROFILES — used to validate supplier and party references and legal-entity context on the batch.
• FND_APPLICATION, FND_ID_FLEX_STRUCTURES, DUAL — supporting lookups for application and key flexfield context during validation.

Usage Notes

FUN_WEBADI_PKG is not referenced by any other database object per the ETRM metadata, confirming it sits at the top of the call stack for its function. It is invoked indirectly through WebADI spreadsheet integrations that post Payables batches, and its logic is expected to run under the standard APPS initialization (FND_GLOBAL, FND_MSG_PUB, FND_API) so that error handling and concurrent context are preserved. The related database package FUN_INTERFACE_CONTROLS_S is the sequence commonly inspected when troubleshooting batch control numbers generated during upload. In 12.1.1 the package behaves as a direct WebADI helper; in 12.2.2 it is unchanged in naming and remains valid, though sites should verify custom WebADI integrators against their installed patch level before modifying or extending it.