Search Results pa_fp_options_reslists_v




Overview
Explore in AI Chat

Overview

PA_FP_OPTIONS_RESLISTS_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the financial plan option configuration at the project and plan type level, specifically the resource lists that have been associated with cost, revenue, and combined financial plan structures. The view consolidates three distinct resource list associations — cost, revenue, and cost-and-revenue — into a single, uniformly structured result set, labeling each row with a resource list type indicator.

Because financial plan options in Oracle Projects are stored denormalized across several columns of PA_PROJ_FP_OPTIONS, this view provides a normalized, reporting-friendly projection. It is intended to support reporting, data extraction, and integration scenarios where a flat list of project/plan-type resource list assignments is required without needing to know which physical column holds the relevant identifier. The view is read-only and reflects the state of the underlying configuration table at query time.

Underlying Base Objects

The view is defined over a single documented base object, PA_PROJ_FP_OPTIONS (referenced in the schema as a synonym), which stores financial plan option settings for each project and financial plan type combination. The view is constructed as a UNION ALL of three SELECT statements, each filtering the base table on a different resource list column and an accompanying preference code. Only rows where FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE' are included.

Each branch requires non-null PROJECT_ID, FIN_PLAN_TYPE_ID, and the respective resource list identifier. The final result set is ordered by project and plan type.

Key Columns

  • PROJECT_ID — Identifier of the project to which the financial plan option applies.
  • FIN_PLAN_TYPE_ID — Identifier of the financial plan type associated with the option record.
  • FP_RESOURCE_LIST_ID — The resource list identifier resolved from the applicable source column. Note that the documented view text aliases these as COST_RESOURCE_LIST_ID, REVENUE_RESOURCE_LIST_ID, and ALL_RESOURCE_LIST_ID in the individual branches; the exposed view column is FP_RESOURCE_LIST_ID.
  • FP_RESOURCE_LIST_TYPE — A descriptive tag (COST RESOURCE LIST, REVENUE RESOURCE LIST, or COST AND REVENUE RESOURCE LIST) indicating the nature of the resource list association.
  • FIN_PLAN_START_DATE — The start date of the financial plan option period.
  • FIN_PLAN_END_DATE — The end date of the financial plan option period.

Common Use Cases and Queries

Typical uses include auditing which resource lists are configured per project, validating financial plan setup during implementation, and feeding downstream reporting or integration processes that consume resource list assignments.

Retrieve all resource list associations for a specific project:

SELECT PROJECT_ID,
       FIN_PLAN_TYPE_ID,
       FP_RESOURCE_LIST_ID,
       FP_RESOURCE_LIST_TYPE,
       FIN_PLAN_START_DATE,
       FIN_PLAN_END_DATE
FROM   APPS.PA_FP_OPTIONS_RESLISTS_V
WHERE  PROJECT_ID = :p_project_id
ORDER  BY FIN_PLAN_TYPE_ID, FP_RESOURCE_LIST_TYPE;

Summarize the count of associations by resource list type:

SELECT FP_RESOURCE_LIST_TYPE, COUNT(*) AS ASSOC_COUNT
FROM   APPS.PA_FP_OPTIONS_RESLISTS_V
GROUP  BY FP_RESOURCE_LIST_TYPE;

Join to project and plan type lookups to produce a human-readable report:

SELECT p.name  AS project_name,
       v.FP_RESOURCE_LIST_TYPE,
       v.FP_RESOURCE_LIST_ID
FROM   APPS.PA_FP_OPTIONS_RESLISTS_V v,
       APPS.PA_PROJECTS_ALL p
WHERE  v.PROJECT_ID = p.project_id
ORDER  BY p.name;