Search Results adj_elements




Overview
Explore in AI Chat

Overview

PA_FP_ENTER_ADJ_LINES_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 is part of the Financial Planning (FP) subsystem and stores adjusted amounts by period for a single adjustment reason. The view is designed to support the "Enter Adjustments" flow within Project Financial Planning, where planners enter adjustments against budget or forecast versions at the resource assignment level.

The view consolidates periodic adjustment amounts into a single row per amount type, exposing up to thirteen period columns (PERIOD_AMOUNT1 through PERIOD_AMOUNT13) along with preceding and succeeding period rollups. Its role is primarily informational and form-driven: it feeds the entry screen used to record adjustments, and it serves as a queryable interface for reporting on how adjustments flow across accounting or planning periods. Because the view depends on session-level context supplied by the PA_FIN_PLAN_VIEW_GLOBAL package, it is intended for use inside the Financial Planning UI rather than as a standalone reporting object.

Underlying Base Objects

ETRM documents the following base objects referenced by PA_FP_ENTER_ADJ_LINES_V:

The view is a UNION of two branches. The first branch joins period values to adjustment elements, resource assignments, and amount types to return actual adjustment amounts. The second branch returns amount types that are adjustable but have no corresponding adjustment rows yet, populating period columns with NULLs. This guarantees that the entry screen always displays every adjustable amount type, even where no adjustment has been recorded.

Key Columns

Common Use Cases and Queries

Typical usage is within the Financial Planning adjustment entry form, where the view is queried after session context is established. A representative query follows:

  • SELECT amount_type_code, amount_subtype_code, period_amount1, period_amount2, period_amount3 FROM pa_fp_enter_adj_lines_v WHERE amount_type_code = :type;
  • SELECT amount_type_code, preceding_periods_amount, succeeding_periods_amount FROM pa_fp_enter_adj_lines_v ORDER BY amount_type_code;

Because the view relies on PA_FIN_PLAN_VIEW_GLOBAL session state, direct SQL execution outside the planning flow may return no rows or unexpected results unless the global package values are set. Reporting solutions requiring the same data should preferably consume PA_FP_PERIOD_VALUES_V and PA_FP_ADJ_ELEMENTS directly, applying equivalent filters for budget version, adjustment reason, and resource assignment type.