Search Results adj_elements




Overview
Explore in AI Chat

Overview

APPS.PA_FP_ENTER_ADJ_LINES_V is a financial planning (FP) reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2 that drives the "Enter Adjustments" page of the Project Financial Planning / Budgeting module. Its purpose is to flatten period-by-period budget amounts for adjustment elements into a fixed, wide row format so that each amount type can be entered, edited, or reviewed against a set of adjustment reason codes. The view is a UNION-based construct: the first branch returns populated adjustment amounts for amount types flagged as adjustable, while the second branch returns placeholder ("null") rows for adjustable amount types that have no matching adjustment data, ensuring the adjustments entry form always presents a complete list of eligible amount types.

The view was located by the user under the search term "pa_fp_period_values_v", which is significant because PA_FP_PERIOD_VALUES_V is the principal source of period amount data. PA_FP_ENTER_ADJ_LINES_V builds directly on that underlying view, so faults or gaps in period value storage propagate into this adjustments view.

Underlying Base Objects

The view is defined over the following documented objects, all owned by APPS:

  • PA_FP_PERIOD_VALUES_V (VIEW) — Supplies the preceding, succeeding and period-specific amount columns for adjustment elements. Joined on object_id = adj_element_id, object_type_code = 'ADJ_ELEMENTS', budget_version_id, and amount_type_code.
  • PA_FP_ADJ_ELEMENTS (SYNONYM) — Holds adjustment element lines, keyed by adjustment_reason_code and resource_assignment_id, and constrained to the current version from the global package.
  • PA_AMOUNT_TYPES_VL (VIEW) — The amount type definitions, joined on amount_type_code (for base types) and on amount_subtype_code (for adjustment subtype types), filtered by plan_adjustable_flag='Y' and plan_adj_amount_flag='Y'.
  • PA_RESOURCE_ASSIGNMENTS (SYNONYM) — Restricts rows to resource assignments of type 'OWN' for the current budget version.
  • PA_FIN_PLAN_VIEW_GLOBAL (PACKAGE) — Provides session context through GET_VERSION_ID() and Get_Adj_Reason_Code(), which scope every branch of the query to the budget version and adjustment reason currently being edited.

The dependency on PA_FIN_PLAN_VIEW_GLOBAL means the view is only meaningful when invoked from within the FP planning session; standalone queries without an initialized global context typically return no rows.

Key Columns

Common Use Cases and Queries

Typical uses include custom adjustments entry pages, reconciliation of entered adjustments to the underlying period values, and reporting on which amount types are eligible for adjustment. A representative query is:

SELECT amount_type_code, amount_subtype_code,
       preceding_periods_amount, succeeding_periods_amount,
       period_amount1, period_amount2
  FROM apps.pa_fp_enter_adj_lines_v
 WHERE amount_type_code = :p_amount_type;

Because the view relies on session globals, it should be queried through the standard planning flow or with the package context set, rather than as an unrestricted ad hoc data source.