Search Results amount_subtype_code




Overview
Explore in AI Chat

Overview

The APPS.PA_FP_VIEW_BY_COMP_V view is a reporting and integration object within the Oracle E-Business Suite Project Accounting (PA) module, specifically part of the Financial Planning (FP) component. It presents financial plan forecast amounts organized by amount subtype (component), across a rolling horizon of up to thirteen accounting periods. In Oracle EBS 12.1.1 and 12.2.2, this view serves as a denormalized, presentation-ready data source that consolidates period-by-period amounts, preceding and succeeding period accumulations, and derived PA-currency and GL-currency totals into a single queryable structure.

The view is particularly relevant to users searching on amount_subtype_code, as that column is a central organizing dimension. Each row corresponds to a distinct amount subtype — such as HEADCOUNT_ADJUSTMENTS, BEGIN_HEADCOUNT, UTILIZATION_ADJUSTMENTS, or UTILIZATION_PERCENT — with associated period amounts and computed totals. This makes the view suitable for forecast comparison reporting, plan-versus-actual analysis, and downstream integration into custom dashboards or extracts.

Underlying Base Objects

The view is defined over several documented base objects:

  • PA_AMOUNT_TYPES_VL — provides the descriptive amount_type_name, exposed as Amount_Subtype_Name.
  • PA_FP_PERIOD_VALUES_V — supplies the source period amount columns (period_amount1 through period_amount13), preceding_periods_amount, succeeding_periods_amount, Amount_Subtype_Code, and amount_subtype_id.
  • PA_FP_ORG_FCST_UTILS — a PL/SQL utility package whose functions calculate_pa_amount and calculate_gl_amount derive specialized values for specific subtypes (headcount and utilization adjustment/percent subtypes).
  • PA_FIN_PLAN_VIEW_GLOBAL — a package referenced in the view definition, supporting global financial plan view logic.
  • PA_LOOKUPS — supports lookup-based decoding and validation.

The view therefore functions as a wrapper that joins descriptive amount-type metadata to the period-value facts, while layering in conditional currency calculations for the subset of subtypes that require special handling.

Key Columns

  • Amount_Subtype_Code — the code identifying the forecast component; used throughout the view's DECODE logic and by users filtering on amount_subtype_code.
  • Amount_Subtype_Name — the user-facing name from PA_AMOUNT_TYPES_VL.
  • Amount_Sybtype_Id — the subtype identifier (note the documented spelling in the view).
  • preceding_periods_amount / succeeding_periods_amount — aggregates for periods before and after the display window.
  • period1 through period13 — discrete period amounts across the forecast horizon.
  • Total_PA and Total_GL — computed totals. For standard subtypes they are the sum of period_amount1 through period_amount13 (NULLs treated as zero). For HEADCOUNT_ADJUSTMENTS, BEGIN_HEADCOUNT, UTILIZATION_ADJUSTMENTS, and UTILIZATION_PERCENT, they are instead sourced from pa_fp_org_fcst_utils.calculate_pa_amount and calculate_gl_amount respectively.

Common Use Cases and Queries

Typical uses include forecast reporting, component-level trend analysis, and integration extracts. A representative query filters by amount subtype:

  • SELECT Amount_Subtype_Name, Amount_Subtype_Code, Total_PA, Total_GL, period1, period2, period3 FROM APPS.PA_FP_VIEW_BY_COMP_V WHERE Amount_Subtype_Code = 'UTILIZATION_PERCENT';
  • SELECT Amount_Subtype_Code, SUM(Total_PA) FROM APPS.PA_FP_VIEW_BY_COMP_V GROUP BY Amount_Subtype_Code;
  • SELECT Amount_Subtype_Name, preceding_periods_amount, succeeding_periods_amount FROM APPS.PA_FP_VIEW_BY_COMP_V WHERE Amount_Subtype_Code = 'BEGIN_HEADCOUNT';

Because Total_PA and Total_GL for adjustment and percent subtypes rely on package function calls rather than simple summation, consumers should avoid re-aggregating those columns across subtype rows without accounting for the special-case logic.