Search Results planned_margin




Overview
Explore in AI Chat

Overview

PA_FP_CI_AMOUNTS_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. It is documented as valid in both EBS 12.1.1 and 12.2.2 and is defined in the APPS schema alongside the core Financial Plan (FP) objects. The view exists to service the Control Item pages, returning financial amounts that originate from budget versions and presenting them grouped by control item identifier (ci_id) and project identifier (project_id).

Its role is aggregational rather than transactional. Instead of exposing individual budget lines, the view consolidates quantity, cost, and revenue figures into a single summarized row per control item and project combination. Because the Control Item pages need consistent quantity and amount derivation logic, the view embeds several DECODE rules that select between raw and burdened cost, between estimated and total values, and between labor quantity and estimated quantity based on the underlying project setup. This makes PA_FP_CI_AMOUNTS_V a stable reporting and integration surface for the Control Item user interface and any external process that consumes those figures.

Underlying Base Objects

The documented base objects are PA_BUDGET_VERSIONS (synonym), PA_CI_TYPES_W_FINPLAN_V (view), PA_CONTROL_ITEMS (synonym), and PA_PROJ_FP_OPTIONS (synonym). The principal driver is PA_BUDGET_VERSIONS, aliased in the view text as BV, since the aggregation is performed over its quantity and amount columns. Grouping is at the ci_id and project_id level, both of which are carried on the budget version rows selected by the view.

PA_PROJ_FP_OPTIONS, aliased as PO, supplies project-level financial plan configuration, most importantly MARGIN_DERIVED_FROM_CODE. This attribute determines whether the view treats raw or burdened cost as the primary cost measure when computing estimated cost, total cost, and estimated margin. PA_CONTROL_ITEMS and PA_CI_TYPES_W_FINPLAN_V define the control item structures and their financial plan type characteristics against which the summarized budget amounts are presented on the Control Item pages.

Key Columns

Common Use Cases and Queries

Typical usage includes Control Item page rendering, financial plan summaries, and project margin reporting. A standard query returns all summarized amounts for a project:

  • SELECT ci_id, project_id, est_quantity, labor_quantity, derived_quantity FROM apps.pa_fp_ci_amounts_v WHERE project_id = :p_project_id;
  • SELECT ci_id, est_project_cost, total_project_cost, est_margin FROM apps.pa_fp_ci_amounts_v WHERE project_id = :p_project_id ORDER BY ci_id;
  • SELECT ci_id, derived_quantity, derived_cost, derived_revenue FROM apps.pa_fp_ci_amounts_v WHERE project_id = :p_project_id AND derived_revenue > 0;

Because values are pre-summarized and NULL-safe, the view is convenient for joined extracts and for reconciliation against control item totals without repeating the aggregation logic in the calling application.