Search Results fixed_date




Overview
Explore in AI Chat

Overview

APPS.PA_FP_WEBADI_CONTENTS_V is a read-only reporting view in the Oracle E-Business Suite Projects (PA) module. It exposes financial plan data — budget versions, resource assignments, tasks, amount types, currencies, and period-by-period amounts — in a flattened, WebADI-friendly structure intended for desktop integration and external reporting. The view is part of the Project Financial Planning / budgeting feature set and is defined in the APPS schema, making it queryable by any user with the appropriate grants.

Within Oracle EBS 12.1.1 and 12.2.2 the view functions as an abstraction layer over the underlying PA financial plan and budget tables. It joins resource assignments, task definitions, amount types, and the denormalized period columns (PERIOD_AMOUNT1 through PERIOD_AMOUNT52) so that consumers do not need to reconstruct multi-table joins themselves. This makes it suitable for WebADI upload/download templates, BI Publisher reports, and ad-hoc SQL used by project accountants.

Underlying Base Objects

According to the ETRM metadata for 12.2.2, the view is defined over the following documented base objects:

The principal driving objects are PA_PROJ_PERIODS_DENORM (which supplies the PERIOD_AMOUNT1..52 columns), PA_RESOURCE_ASSIGNMENTS (resource_assignment_id, unit_of_measure), PA_BUDGET_VERSIONS (budget_version_id), and PA_TASKS (task_number, task_name). The FND_PROFILE package is referenced to respect site-level profile options such as currency and cross-business-group security, while PA_FIN_PLAN_UTILS computes derived financial plan attributes.

Key Columns

Common Use Cases and Queries

Typical uses include exporting a budget version's plan to Excel via WebADI, reconciling budget lines to tasks, and feeding downstream reporting on labor and non-labor amounts by period.

SELECT pra.budget_version_id,
       pra.resource_assignment_id,
       ptk.task_number,
       pmvl.amount_type_name,
       p.currency_code,
       p.period_amount1,
       p.period_amount2
FROM   apps.pa_fp_webadi_contents_v p
WHERE  p.budget_version_id = :budget_version_id
ORDER  BY ptk.task_number, pmvl.amount_type_name;

Note on the searched term fixed_date: this view contains no FIXED_DATE column and does not reference the FND_SESSIONS/fixed-date mechanism. Any "fixed date" behavior affecting results would come from the session-level profile option (FND: Fixed Date) applied by the underlying base tables, not from a column in this view.