Results for “pa_fin_plan_adj_lines”

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

Overview

PA_FIN_PLAN_ADJ_LINES is a transactional table in the Oracle Projects (PA) schema that stores adjustment lines associated with a Financial Plan. It captures the specific adjustments a planner applies to a financial plan version, including monetary adjustments (cost, burdened cost, and revenue) and non-monetary adjustments (utilization and head count). The table sits at the detail level of the Financial Plan adjustment model, providing the granular rows that together describe how a plan has been modified relative to its baseline or prior state.

In Oracle EBS 12.1.1 and 12.2.2, this object interacts with the standard Project, Task, Budget Version, and Resource Assignment entities. It is a child object referenced by foreign keys from four parent tables, reflecting its role as a dependent detail record. A heuristic Data Vault modeling suggestion classifies this object as a link, since it resolves relationships among projects, tasks, budget versions, and resource assignments while also carrying descriptive measures. In practice, it functions as an intersection-style table joining planning dimensions to adjustment values.

Key Information Stored

The documented schema contains 20 columns. The most significant include:

• FIN_PLAN_ADJ_LINE_ID — the surrogate primary key and the sole business-key candidate, enforced by unique index PA_FIN_PLAN_ADJ_LINES_U1.
• ADJ_ELEMENT_ID — identifies the adjustment element associated with the line, coupling the row to the adjustment definition.
• PROJECT_ID — foreign key to PA_PROJECTS_ALL, identifying the owning project.
• TASK_ID — foreign key to PA_TASKS, identifying the task within the project.
• BUDGET_VERSION_ID — foreign key to PA_BUDGET_VERSIONS, tying the adjustment to a specific plan version.
• RESOURCE_ASSIGNMENT_ID — foreign key to PA_RESOURCE_ASSIGNMENTS, linking the adjustment to a planning resource.
• PERIOD_NAME, START_DATE, END_DATE — define the accounting period and effective date range over which the adjustment applies.
• RAW_COST_ADJUSTMENT, BURDENED_COST_ADJUSTMENT, REVENUE_ADJUSTMENT — the monetary adjustment values.
• UTILIZATION_ADJUSTMENT, HEAD_COUNT_ADJUSTMENT — the non-monetary or quantity-based adjustments.
• ADJUSTMENT_COMMENTS — free-text justification for the adjustment.
• Standard audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN).

The surrogate key is a system-generated sequential identifier; no separate alphanumeric business key is documented beyond this column.

Common Use Cases and Queries

Financial Plan adjustment lines are used to report, reconcile, and audit how plan versions deviate from expected values. Typical scenarios include reviewing adjustments by project, task, and period, comparing cost versus revenue impact, and extracting comments for change control.

A representative query joins the line to its parent project and version:

• Reporting total adjustment by project and budget version: select PROJECT_ID, BUDGET_VERSION_ID, PERIOD_NAME, and sum the monetary adjustment columns, grouping by those dimensions.
• Detail reconciliation: join PA_PROJECTS_ALL on PROJECT_ID and PA_TASKS on TASK_ID to obtain project and task names.
• Resource-level analysis: join PA_RESOURCE_ASSIGNMENTS on RESOURCE_ASSIGNMENT_ID to attribute adjustments to planners or resources.
• Audit extraction: filter on the audit columns to identify recently modified adjustment lines and their ADJUSTMENT_COMMENTS.

Related Objects

The following objects are most significant to PA_FIN_PLAN_ADJ_LINES, based on documented foreign-key relationships:

• PA_PROJECTS_ALL — joined via PROJECT_ID.
• PA_TASKS — joined via TASK_ID.
• PA_BUDGET_VERSIONS — joined via BUDGET_VERSION_ID.
• PA_RESOURCE_ASSIGNMENTS — joined via RESOURCE_ASSIGNMENT_ID.
• Adjustment element definitions referenced by ADJ_ELEMENT_ID, which link the line to the surrounding Financial Plan adjustment framework.

These relationships establish PA_FIN_PLAN_ADJ_LINES as a dependent detail table integrating project planning, budgeting, and resource dimensions within the Oracle Projects module.