Search Results planned_margin




Overview
Explore in AI Chat

Overview

APPS.PA_FP_CI_AMOUNTS_V is a reporting view in the Oracle E-Business Suite Projects (PA) module that consolidates financial plan amounts at the control item level. It exposes estimated, planned, and derived quantity, cost, revenue, and margin figures for a given control item within a project. The view is classified as "Oracle Internal Use Only," and Oracle Corporation does not support direct access to its data except through standard Oracle Applications programs. Consequently, the view is intended for use by Oracle's own Financial Planning (FP) and Control Item (CI) processing logic rather than as a public integration interface. In Oracle EBS 12.1.1 and 12.2.2, the view supports reporting on financial plan performance, enabling comparison of estimated, planned, and derived values for cost, revenue, and margin across control items.

Underlying Base Objects

The view is defined over four documented base objects: PA_BUDGET_VERSIONS (synonym), PA_CI_TYPES_W_FINPLAN_V (view), PA_CONTROL_ITEMS (synonym), and PA_PROJ_FP_OPTIONS (synonym). PA_CONTROL_ITEMS provides the control item identifiers and project context, while PA_BUDGET_VERSIONS supplies budget version information used to distinguish estimated versus planned figures. PA_CI_TYPES_W_FINPLAN_V contributes control item type and financial plan configuration attributes, and PA_PROJ_FP_OPTIONS holds project-level financial plan setup options that determine, for example, whether derived cost is calculated on a raw or burdened basis. The view joins these objects to present a single row per control item (keyed by CI_ID and PROJECT_ID) with aggregated financial plan amounts in the project currency.

Key Columns

Common Use Cases and Queries

A frequent use case is analyzing how derived amounts compare against estimated and planned figures for a control item. The following query returns the principal quantity, cost, and revenue columns for a specific project:

  • SELECT ci_id, project_id, est_quantity, labor_quantity, derived_quantity, est_project_raw_cost, total_project_raw_cost, derived_cost, derived_revenue, est_margin_percentage FROM apps.pa_fp_ci_amounts_v WHERE project_id = :project_id;

Because the view is marked Oracle Internal Use Only, direct ad-hoc querying should be restricted to diagnostic or support scenarios, and production integrations should rely on supported APIs or concurrent programs. Where the view is used, filtering by PROJECT_ID and CI_ID is recommended to constrain the result set.