Results for “pa_fp_webadi_prd_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_FP_WEBADI_PRD_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, residing in the Projects (PA) product family. Its documented purpose is to support the Financial Planning WebADI download process by resolving the start date and end date of each period defined within a given period mask. Period masks are the reusable definitions that translate a project's or budget's fiscal calendar into an ordered sequence of accounting periods; the view pivots that sequence into a row-per-budget-version layout suitable for spreadsheet-based entry and upload.

Because Financial Planning uses WebADI to publish planning layouts to Microsoft Excel, the download query must present a compact, deterministic set of date columns. This view supplies exactly that: for each budget version and period mask pairing, it returns up to ten positionally anchored start/end date pairs (PRDSD1/PRDED1 through PRDSD10/PRDED10). Each pair corresponds to one period position within the mask, allowing the WebADI template to render period headers and date ranges without the client performing additional calendar arithmetic.

The view is defined in the APPS schema and is reported as VALID in the ETRM metadata for 12.2.2. The same definition is present in 12.1.1, since the underlying Financial Planning and period mask infrastructure is common to both releases.

Underlying Base Objects

The documented referenced base objects are:

• PA_FP_PERIODS_V (VIEW) — supplies the period-level start and end dates and the period mask positioning used to derive the pivoted columns.
• PA_PERIOD_MASK_DETAILS (SYNONYM) — the period mask definition, providing the anchor and position attributes for each mask.
• PA_PROJECTS_ALL (SYNONYM) — the projects master, providing the project context for planning options.
• PA_PROJ_FP_OPTIONS (SYNONYM) — the project-level Financial Planning options that determine which calendar and mask apply.

The view text confirms this relationship. It selects BUDGET_VERSION_ID and PERIOD_MASK_ID from the driving period source, then applies MIN(DECODE(...)) aggregation over FROM_ANCHOR_POSITION minus the minimum anchor for the mask. This technique collapses multiple period rows into a single row per budget version and mask, with each of the ten period slots decoded into its own start-date and end-date column pair. The view therefore sits logically above the period and mask detail objects and below the WebADI download query.

Key Columns

• BUDGET_VERSION_ID — identifies the budget version for which the period dates are resolved. This is the primary grouping key in the WebADI download.
• PERIOD_MASK_ID — the period mask whose concrete periods are being expanded. This is the column most often referenced when users search for "all_period_mask_id," since period mask identifiers are the pivot between mask definition and rendered period dates.
• PRDSD1 … PRDSD10 — the start date of period position 1 through 10 within the mask.
• PRDED1 … PRDED10 — the end date of period position 1 through 10 within the mask.

Because each date column is populated only when the computed anchor offset equals the corresponding position, positions beyond the mask's length return NULL. Consumers should not assume all ten pairs are populated.

Common Use Cases and Queries

The principal use case is the Financial Planning WebADI download, where the template retrieves period date ranges for the active budget version. A typical query is:

• SELECT budget_version_id, period_mask_id, prdsd1, prded1, prdsd2, prded2 FROM apps.pa_fp_webadi_prd_v WHERE budget_version_id = :p_budget_version_id;
• Diagnostic verification that a mask resolves correctly: SELECT period_mask_id, prdsd1, prded1 FROM apps.pa_fp_webadi_prd_v WHERE period_mask_id = :p_mask_id;
• Joining back to planning tables to reconcile displayed periods against stored plan lines by budget version.

Note that the view exposes period masks rather than all masks; filtering on PERIOD_MASK_ID is the reliable way to isolate a specific mask's period date ranges.