Search Results pa_fp_webadi_utils




Overview
Explore in AI Chat

Overview

PA_FP_WEBADI_UTILS is a PL/SQL package body in the APPS schema that provides the server-side utility layer for the WebADI (Web Applications Desktop Integrator) interface used to upload financial plan and forecast data in Oracle Project Portfolio Management. In Oracle EBS 12.1.1 and 12.2.2, financial plans (budgets, forecasts, and commitments) are frequently maintained outside the application in spreadsheet form and uploaded back through WebADI-enabled layouts. This package supplies the validation, lookup resolution, amount retrieval, and interface-table management logic that supports those uploads.

The package is classified as OTHER within the ETRM metadata rather than as a published public API, which indicates that it is an internal supporting package rather than an entry point intended for external integration. Its dependency list confirms this role: it consumes WebADI framework objects (BNE_INTEGRATORS_B, BNE_LAYOUTS_B, BNE_LAYOUTS_TL, BNE_LAYOUTS_VL), the generic API and messaging infrastructure (FND_API, FND_MSG_PUB, FND_PROFILE, FND_REQUEST), and numerous Project financial planning entities such as PA_BUDGET_LINES, PA_BUDGET_VERSIONS, PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_LIST_MEMBERS, and PA_PROJ_FP_OPTIONS.

Notably, the ETRM metadata records that the package body is not referenced by any database object, while the broader dependency report notes that PA_FP_WEBADI_UTILS is referenced by three other packages. This is consistent with a utility module invoked dynamically through WebADI integrator definitions and through sibling packages such as PA_FP_WEBADI_PKG, rather than through static compile-time references in most cases.

Key Procedures and Functions

The package exposes twenty documented procedures and functions, organized around validation, metadata retrieval, and amount calculation:

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms. WebADI configuration tables BNE_INTEGRATORS_B, BNE_LAYOUTS_B, and BNE_LAYOUTS_TL supply integrator and layout definitions. Project financial plan structures are represented by PA_BUDGET_LINES, PA_BUDGET_VERSIONS, PA_FIN_PLAN_TYPES_B, and PA_PROJ_FP_OPTIONS. Resource data comes from PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_LIST_MEMBERS, and related resource list tables. PA_AMOUNT_TYPES_B provides amount type definitions, while PA_FP_TXN_CURRENCIES supplies the transaction currency setup. Staging and interface activity is handled through PA_FP_WEBADI_UPLOAD_INF and PA_FP_WEBADI_XFACE_TMP. Reference data is drawn from FND_APPLICATION and PA_TASKS.

Usage Notes

This package is invoked indirectly through the WebADI upload flow for project financial plans. Users launch the download and upload process from Oracle Projects forms, where the integrator definition invokes validation routines such as VALIDATE_BEFORE_LAUNCH, VALIDATE_RESOURCE_INFO, and VALIDATE_CURRENCY_CODE as rows are processed. Concurrent request resubmission is handled by RESUBMIT_CONC_REQUEST. Because the package is not a published public API, customizations should avoid calling it directly; the supported integration path is through PA_FP_WEBADI_PKG and the standard WebADI integrator configuration.