Search Results pa_fp_webadi_custom_v




Overview
Explore in AI Chat

Overview

PA_FP_WEBADI_CUSTOM_V is a customization view owned by the APPS schema in Oracle E-Business Suite, defined under the Projects (PA) product family. Its documented purpose is to support the Financial Planning module's download-to-Excel function, providing the row set that is rendered into the spreadsheet generated through the WebADI framework. In Oracle EBS 12.1.1 and 12.2.2 the object is registered as VALID, and the Financial Planning feature it serves remains a supported component of Project Management.

The view acts as a filtered, presentation-oriented projection of the underlying financial plan contents. Rather than exposing the full contents view, PA_FP_WEBADI_CUSTOM_V narrows the result set by both amount subtype and financial plan preference. The result is a shape suited to spreadsheet consumption: one row per budget version, resource assignment, task, and amount subtype combination, with the period-by-period amounts spread across PRD1 through PRD52.

Underlying Base Objects

The ETRM metadata lists the following referenced objects:

  • PA_FP_WEBADI_CONTENTS_V (VIEW) — the immediate source of the SELECT, supplying all projected columns.
  • FND_PROFILE (PACKAGE) — the standard profile option access package, used indirectly through the Financial Planning preference resolution chain to derive FIN_PLAN_PREFERENCE_CODE.
  • PA_CROSS_BUSINESS_GRP (PACKAGE) — the cross-business-group security package, used to enforce organization-level access on the rows returned.
  • PA_FIN_PLAN_UTILS (PACKAGE) — the Financial Planning utility package, providing supporting logic for plan and preference evaluation.

The relationships are hierarchical. PA_FP_WEBADI_CONTENTS_V supplies the conceptual row model; FND_PROFILE, PA_CROSS_BUSINESS_GRP, and PA_FIN_PLAN_UTILS supply the profile-driven and security-driven context that shapes which rows and which preference value a given user sees. PA_FP_WEBADI_CUSTOM_V is therefore the outermost layer of a stack used by the WebADI download, and it is the layer intended for customer extension.

Key Columns

The view exposes identification, descriptive, rate, and period columns. Among the most significant:

The view closes with fourteen NULL placeholder columns, reserved to preserve a fixed column count for downstream WebADI templates.

Common Use Cases and Queries

The primary use case is the Financial Planning download-to-Excel action, where the view provides the WebADI row set. Functional users also query it directly to audit what was exported, and developers build customization views modeled on it when a customer requires additional or excluded columns. The FIN_PLAN_PREFERENCE_CODE value determines which amount subtypes are suppressed: a COST_ONLY preference excludes revenue rows, while a REVENUE_ONLY preference excludes raw cost rows.

A representative query follows:

  • SELECT budget_version_id, project_name, task_num, task_name, resource_name, amount_subtype_code, amount_type_order, prd1, prd2, prd3 FROM pa_fp_webadi_custom_v WHERE fin_plan_preference_code = 'COST_ONLY' AND budget_version_id = :p_version ORDER BY task_num, resource_name, amount_type_order;
  • SELECT amount_subtype_code, COUNT(*) FROM pa_fp_webadi_custom_v WHERE budget_version_id = :p_version GROUP BY amount_subtype_code;
  • SELECT DISTINCT fin_plan_preference_code FROM pa_fp_webadi_custom_v;

Because the view derives from security-aware packages, returned rows reflect the caller's business group and profile context; queries executed as APPS return the unfiltered administrative set, while end-user sessions observe the plan preference applied to their responsibility.