Search Results pa_proj_fp_options

Overview

The PA_PROJ_FP_OPTIONS table is a core repository for financial planning configuration within Oracle E-Business Suite Projects. It serves as a central control point by storing default financial planning options that can be applied at three distinct levels: for a specific project, for a financial plan type, or for a particular plan version. This hierarchical storage mechanism ensures consistent financial planning behavior across the application, governing critical processes such as currency conversion, period mapping, and the generation of one financial plan from another. Its role is integral to the setup and execution of budgeting, forecasting, and other financial planning activities in Oracle Projects.

Key Information Stored

The table's primary key is PROJ_FP_OPTIONS_ID. Its most significant columns define the financial planning environment through foreign key relationships to other setup entities. Key stored information includes rate types for converting project and project functional currency amounts (PROJECT_COST_RATE_TYPE, PROJFUNC_COST_RATE_TYPE, etc.), identifiers for period masks to map amounts to accounting periods (COST_PERIOD_MASK_ID, REV_PERIOD_MASK_ID, ALL_PERIOD_MASK_ID), and amount set identifiers for cost and revenue (COST_AMOUNT_SET_ID, ALL_AMOUNT_SET_ID). Crucially, it stores source plan references for plan generation processes, such as GEN_SRC_COST_PLAN_TYPE_ID and GEN_SRC_COST_PLAN_VERSION_ID, which define the source cost plan used to generate a new one. The table also links to a specific Resource Breakdown Structure (RBS) version via RBS_STRUCT_VERSION_ID and to a financial plan type via FIN_PLAN_TYPE_ID.

Common Use Cases and Queries

A primary use case is auditing the financial planning setup for a project or plan type to troubleshoot plan generation or currency conversion issues. Database administrators or functional consultants may query this table to verify that period masks and rate types are correctly assigned. A common reporting need is to list all financial planning options for active projects. A sample SQL pattern to retrieve core options for a specific project would be:

• SELECT project_id, fin_plan_type_id, cost_period_mask_id, projfunc_cost_rate_type FROM pa_proj_fp_options WHERE project_id = <PROJECT_ID>;

Another critical scenario involves understanding the source-target relationships for automated plan generation, which requires joining to PA_FIN_PLAN_TYPES_B and PA_BUDGET_VERSIONS on the GEN_SRC_* columns. Data fixes or mass updates to default options, though rare, are also performed directly in this table following change control procedures.

Related Objects

PA_PROJ_FP_OPTIONS maintains extensive foreign key relationships, acting as a hub connecting financial planning components. Key documented relationships include:

• PA_PROJECTS_ALL: Links options to a specific project via PROJECT_ID.
• PA_FIN_PLAN_TYPES_B: Links to the financial plan type (FIN_PLAN_TYPE_ID) and to source plan types for generation (GEN_SRC_COST_PLAN_TYPE_ID, GEN_SRC_REV_PLAN_TYPE_ID, GEN_SRC_ALL_PLAN_TYPE_ID).
• PA_BUDGET_VERSIONS: Links to specific plan versions for period masks (COST_PERIOD_MASK_ID, REV_PERIOD_MASK_ID) and source plan versions for generation (GEN_SRC_COST_PLAN_VERSION_ID, etc.).
• GL_DAILY_CONVERSION_TYPES: Links to the four defined currency conversion rate types for project and project functional costs and revenue.
• PA_PERIOD_MASKS_B: Links to the period mask for all amounts (ALL_PERIOD_MASK_ID).
• PA_FIN_PLAN_AMOUNT_SETS: Links to amount sets for cost (COST_AMOUNT_SET_ID) and all amounts (ALL_AMOUNT_SET_ID).
• PA_PROJ_ELEMENT_VERSIONS: Links to the Resource Breakdown Structure version via RBS_STRUCT_VERSION_ID.