Results for “fpa_pc_proj_tbl”

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

Overview

APPS.FPA_AW_PC_PROJECTS_V is an Oracle E-Business Suite view owned by the APPS schema that exposes project-level dimension data from an Oracle OLAP analytic workspace used by the Enterprise Planning and Budgeting (EPB) module. The view is part of the FPA (Financial Planning and Analysis) family of objects and bridges the relational and multidimensional worlds: rather than reading a conventional base table, it retrieves members of the PROJECT dimension directly from an analytic workspace (AW) through the OLAP_TABLE mechanism.

In the 12.1.1 and 12.2.2 architectures the EPB application stores planning data in OLAP cubes and exposes pre-aggregated slices back to the relational layer via views such as this one. FPA_AW_PC_PROJECTS_V therefore serves as a reporting and integration surface—allowing standard SQL tools, concurrent programs, and BI Publisher reports to enumerate the projects that participate in a planning cycle without requiring them to speak the OLAP API. Because the AW space name is resolved dynamically at query time, the view always reflects the currently active workspace regardless of environment or cycle.

Underlying Base Objects

The documented definition of the view is deceptively short:

SELECT planning_cycle, project
FROM TABLE ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query',
                         'fpa_pc_proj_tbl','',
                         'DIMENSION project FROM project_d
                          WITH ATTRIBUTE planning_cycle FROM pc_project_r'))

The ETRM metadata lists two referenced objects: the package FPA_UTILITIES_PVT and the public synonym OLAP_TABLE. The literal string 'fpa_pc_proj_tbl'—the term the user searched for—is the OLAP_TABLE parameter identifying the target analytic workspace object (the AW cube or dimension source), not a relational table. FPA_UTILITIES_PVT.AW_SPACE_NAME is a package function that returns the physical AW workspace name at runtime, so the same view definition works across cycles and instances. OLAP_TABLE is the standard Oracle supplied table function that projects OLAP multidimensional data into rows and columns, driven by the fourth argument: an OLAP DML command string that specifies the DIMENSION clause (project from project_d) and the attribute mapping (planning_cycle from pc_project_r). Effectively, the view is a thin, parameterised wrapper that materialises the project dimension and its planning-cycle attribute for relational consumption.

Key Columns

• PROJECT — The member value of the PROJECT dimension drawn from the OLAP object PROJECT_D. It identifies a project available within the planning workspace and can be joined to relational project identifiers (for example to FND or PA project references) for enrichment.
• PLANNING_CYCLE — An attribute sourced from PC_PROJECT_R, expressing the planning cycle associated with each project member. This enables filtering to a specific budget or forecast cycle without querying the AW directly.

Only these two columns are projected, making the view narrow and efficient: its sole purpose is dimension/attribute enumeration rather than fact retrieval.

Common Use Cases and Queries

Typical uses include validating which projects are loaded into a workspace, populating LOVs or parameters for EPB concurrent programs, and reconciling OLAP dimension membership against relational project master data. A basic query is:

SELECT planning_cycle, project
FROM   apps.fpa_aw_pc_projects_v
ORDER BY planning_cycle, project;

To restrict to a single cycle:

SELECT project
FROM   apps.fpa_aw_pc_projects_v
WHERE  planning_cycle = :p_cycle;

Because the view invokes OLAP_TABLE, queries require the OLAP workspace to be attached and the APPS session to hold the necessary privileges; in reporting environments this is normally guaranteed by the EPB application context. Ensure the AW identified by FPA_UTILITIES_PVT.AW_SPACE_NAME is initialised before execution.