Search Results etc_method




Overview
Explore in AI Chat

Overview

PA_FP_WEBADI_PERIODIC_V is an APPS-owned reporting view within the Oracle E-Business Suite Projects (PA) module. Its documented purpose is to support Financial Planning by downloading periodic budget and forecast data into an Excel spreadsheet. The view is registered as VALID in the ETRM repository and is available in both EBS 12.1.1 and 12.2.2. It functions as a presentation-layer interface between the WebADI (Web Applications Desktop Integrator) staging structures and the spreadsheet upload/download process used by planners working with periodic (spread) budget and forecast versions.

The view exposes one row per planning resource assignment for a given budget version, including project and task identifiers, resource details, currency and rate information, remaining effort (ETC) attributes, and a horizontally pivoted set of up to fifty-two period amount columns (PRD1 through PRD52), bracketed by preceding and succeeding period amounts. This shape is optimized for tabular consumption by Excel, rather than for normalized relational querying.

Underlying Base Objects

The view is defined over a single base object: the synonym PA_FP_WEBADI_XFACE_TMP, which resolves to the WebADI interface/staging table used during the Financial Planning download process. Because the view is defined entirely over this temporary interface structure, it carries no independent storage and reflects only the data currently staged for a WebADI planning session. Records are associated with a session through BUDGET_VERSION_ID and the delete flag, and the staging table is populated by the Financial Planning download logic before the data is rendered into the Excel worksheet.

The DELETE_FLAG column indicates staged rows marked for removal or refresh within the interface. Consequently, the view should be treated as session-scoped and transient, not as a stable historical record of planning data. Persistent planning amounts reside in the PA budget and forecast base tables; this view is strictly the WebADI transport representation.

Key Columns

Common Use Cases and Queries

The principal use case is the Financial Planning periodic budget/forecast download into Excel via WebADI. Technically, the view is queried to inspect staged planning rows, validate ETC method assignments, and troubleshoot download results.

To list staged rows for a budget version, including the ETC method for each resource assignment:

SELECT project_number, task_number, resource_alias,
       etc_method_code, etc_method, etc_source,
       preceding_period_amount, prd1, prd2
FROM   apps.pa_fp_webadi_periodic_v
WHERE  budget_version_id = :budget_version_id
AND    delete_flag = 'N';

To summarize planned amounts by ETC method across the staged session:

SELECT etc_method_code, COUNT(*) staged_rows,
       SUM(prd1) period1_amount
FROM   apps.pa_fp_webadi_periodic_v
WHERE  budget_version_id = :budget_version_id
GROUP  BY etc_method_code;

Because the object is a view over a staging synonym, queries should always filter on BUDGET_VERSION_ID and DELETE_FLAG to avoid returning rows from unrelated or stale planning sessions.