Results for “report_labor_hrs_from_code”

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

Overview

PA_PROJ_FP_OPTIONS is a Projects (PA) module table that stores the default financial planning options for a project, plan type, or plan version in Oracle EBS 12.1.1 and 12.2.2. It acts as the configuration anchor for how financial plans are generated, aggregated, and displayed — controlling source codes for cost, revenue, and combined plans; planning levels; time-phasing and period masks; amount sets; resource lists; rate schedules; and layout preferences. Each row represents one set of planning options tied to a specific project and financial plan type/version combination.

Under the heuristic Data Vault classification derived from its foreign key structure, PA_PROJ_FP_OPTIONS is satellite-leaning. This suggests modeling it as a descriptive satellite attached to a project hub (PA_PROJECTS_ALL) and financial plan type link, since it predominantly carries descriptive planning attributes and configuration flags rather than acting as a pure junction or core business entity. The table contains 123 documented columns in the 12.2.2 schema.

Key Information Stored

The surrogate primary key is PROJ_FP_OPTIONS_ID, enforced by the PA_PROJ_FP_OPTIONS_PK constraint. Two unique indexes identify business-key candidates: PA_PROJ_FP_OPTIONS_U1 on PROJ_FP_OPTIONS_ID and PA_PROJ_FP_OPTIONS_U2 on the composite (PROJECT_ID, FIN_PLAN_TYPE_ID, FIN_PLAN_VERSION_ID), which enforces one option set per project/plan type/plan version.

• PROJECT_ID — the owning project, foreign key to PA_PROJECTS_ALL.
• FIN_PLAN_TYPE_ID / FIN_PLAN_VERSION_ID — the financial plan type and plan version these options apply to.
• FIN_PLAN_OPTION_LEVEL_CODE — indicates whether the options are defined at project, plan type, or plan version level.
• FIN_PLAN_START_DATE / FIN_PLAN_END_DATE — the effective date range for the plan options.
• ALL_AMOUNT_SET_ID, COST_AMOUNT_SET_ID, REVENUE_AMOUNT_SET_ID — amount sets controlling budget/amount entry for combined, cost, and revenue plans.
• ALL_RESOURCE_LIST_ID, COST_RESOURCE_LIST_ID, REVENUE_RESOURCE_LIST_ID — resource lists determining which resources appear in each plan.
• COST_PERIOD_MASK_ID, REV_PERIOD_MASK_ID, ALL_PERIOD_MASK_ID — period masks controlling time-phased distribution.
• GEN_SRC_COST/REV/ALL_PLAN_TYPE_ID and version IDs — source plans used to generate new financial plans.
• PROJFUNC/ PROJECT cost and revenue rate types and date types — rate derivation settings linked to GL_DAILY_CONVERSION_TYPES.
• RBS_VERSION_ID / RBS_STRUCT_VERSION_ID — resource breakdown structure versions used for planning.
• LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY — standard audit columns.

Common Use Cases and Queries

Typical usage centers on retrieving the planning configuration for a project to understand which amount sets, resource lists, or source plans drive plan generation. A common join retrieves options alongside project and plan type:

• Identifying default options for a project: SELECT * FROM PA_PROJ_FP_OPTIONS WHERE PROJECT_ID = :p_project_id;
• Joining to plan type names: SELECT o.*, t.name FROM PA_PROJ_FP_OPTIONS o, PA_FIN_PLAN_TYPES_B t WHERE o.FIN_PLAN_TYPE_ID = t.FIN_PLAN_TYPE_ID AND o.PROJECT_ID = :p_project_id;
• Reporting on period masks and amount sets configured per plan version to audit plan consistency.
• Diagnosing plan generation issues by inspecting GEN_SRC_* source codes and plan versions.
• Extracting rate schedule configuration (RES_CLASS_RAW_COST_SCH_ID, COST_BURDEN_RATE_SCH_ID, etc.) for costing and revenue analysis.

Related Objects

PA_PROJ_FP_OPTIONS participates in a dense network of foreign keys and is referenced by several dependent tables.

• PA_PROJECTS_ALL — parent project (PROJECT_ID).
• PA_FIN_PLAN_TYPES_B — financial plan type definitions (FIN_PLAN_TYPE_ID, GEN_SRC_*_PLAN_TYPE_ID).
• PA_BUDGET_VERSIONS — plan versions and period masks (FIN_PLAN_VERSION_ID, COST_PERIOD_MASK_ID, REV_PERIOD_MASK_ID, ALL_PERIOD_MASK_ID, GEN_SRC_*_PLAN_VERSION_ID, GEN_SRC_*_WP_VERSION_ID).
• PA_FIN_PLAN_AMOUNT_SETS — amount sets (ALL_AMOUNT_SET_ID, COST_AMOUNT_SET_ID, REVENUE_AMOUNT_SET_ID).
• PA_RESOURCE_LISTS_ALL_BG — resource lists (ALL_RESOURCE_LIST_ID, COST_RESOURCE_LIST_ID, REVENUE_RESOURCE_LIST_ID).
• GL_DAILY_CONVERSION_TYPES — rate types (PROJFUNC/PROJECT cost and revenue rate types).
• PA_PERIOD_MASKS_B — period mask definitions (ALL_PERIOD_MASK_ID).
• PA_RBS_VERSIONS_B / PA_PROJ_ELEMENT_VERSIONS — RBS versions (RBS_VERSION_ID, RBS_STRUCT_VERSION_ID).
• PA_FP_ELEMENTS, PA_FP_EXCLUDED_ELEMENTS, PA_FP_TXN_CURRENCIES, PA_FP_UPGRADE_AUDIT — child tables referencing PROJ_FP_OPTIONS_ID.