Search Results pr_committed_cost

Overview

The view APPS.PJI_AC_ACT_CMT_BY_TASK_V is a Project Intelligence (PJI) reporting object in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents actual costs, revenue, and commitments for Oracle Projects (PA) and General Ledger (GL) periods, aggregated at the project and task level. Its principal purpose is to serve as an extraction interface for external project management systems that import financial data from Oracle Projects. By exposing a pre-joined, pre-aggregated result set keyed on project and task, the view allows downstream systems to consume consistent cost, revenue, and commitment figures without needing to reconstruct the underlying star-schema relationships in PJI_FP_XBS_ACCUM_F.

The view is defined in the APPS schema and holds VALID status. It is registered under the PJI – Project Intelligence product family, which supplies the materialized fact and dimension structures used by Project Intelligence reporting and by external integrations. Users searching for equipment_raw_cost will find that this measure is exposed directly by the view as the EQUIPMENT_RAW_COST column.

Underlying Base Objects

The documented base objects referenced by this view are:

PJI_FP_XBS_ACCUM_F (SYNONYM) — the Project Intelligence accumulated fact table that stores cost, revenue, quantity, and commitment accumulators across period types, calendars, and resource breakdown structures.
PA_PROJECTS_ALL (SYNONYM) — the Oracle Projects project definition table, used here to supply the project functional currency code.

The view joins the fact table to PA_PROJECTS_ALL on PROJECT_ID, and additionally constrains the fact to the project functional currency (FACT.CURRENCY_CODE = PPA.PROJFUNC_CURRENCY_CODE). The fact side is filtered to the accumulated, non-rollup, transaction-level task slice: TIME_ID = -1, PERIOD_TYPE_ID = 2048, CALENDAR_TYPE = 'A', RBS_AGGR_LEVEL = 'T', RBS_VERSION_ID = -1, PRG_ROLLUP_FLAG = 'N', PLAN_VERSION_ID = -1, and PLAN_TYPE_ID = -1. Results are grouped by PROJECT_ID and PROJECT_ELEMENT_ID, producing one row per project–task combination.

Key Columns

The view exposes the following principal columns:

PROJECT_ID, TASK_ID — the grouping keys identifying the project and its task (project element).
REVENUE — summed revenue for the project/task.
RAW_COST and CAPITAL_RAW_COST — raw (unburdened) cost and its capitalizable portion.
BURDENED_COST and CAPITAL_BURDENED_COST — burdened cost and its capitalizable portion.
EQUIPMENT_RAW_COST and EQUIPMENT_BRDN_COST — raw and burdened equipment cost, the measures most relevant to the equipment cost search.
LABOR_RAW_COST, LABOR_BRDN_COST, LABOR_REVENUE, BILL_LABOR_RAW_COST, BILL_LABOR_BRDN_COST — labor cost and revenue measures, in total and billable form.
QUANTITY, LABOR_HRS, BILLABLE_QUANTITY, BILL_LABOR_HRS, CMT_QUANTITY — labor quantity measures.
EQUIPMENT_HOURS, BILLABLE_EQUIPMENT_HOURS — equipment quantity measures.
SUP_INV_COMMITTED_COST, PO_COMMITTED_COST, PR_COMMITTED_COST, OTH_COMMITTED_COST — commitment amounts by source (supplier invoice, purchase order, requisition, other).
CMT_BURDENED_COST — total commitments, computed as the sum of the four commitment columns using NVL defaults.

Common Use Cases and Queries

The view is typically used to feed external project management or cost reporting systems, to reconcile PA and GL period actuals by task, and to report equipment and labor cost against revenue and commitments.

Retrieving equipment raw cost by task for a project:

SELECT PROJECT_ID, TASK_ID, EQUIPMENT_RAW_COST, EQUIPMENT_BRDN_COST, EQUIPMENT_HOURS FROM PJI_AC_ACT_CMT_BY_TASK_V WHERE PROJECT_ID = :p_project_id;

Comparing cost, revenue, and commitments across tasks:

SELECT PROJECT_ID, TASK_ID, RAW_COST, BURDENED_COST, REVENUE, CMT_BURDENED_COST FROM PJI_AC_ACT_CMT_BY_TASK_V WHERE PROJECT_ID = :p_project_id ORDER BY TASK_ID;

Isolating equipment cost within total project cost:

SELECT TASK_ID, EQUIPMENT_RAW_COST, LABOR_RAW_COST, RAW_COST FROM PJI_AC_ACT_CMT_BY_TASK_V WHERE PROJECT_ID = :p_project_id;

Commitment analysis by source:

SELECT PROJECT_ID, TASK_ID, PO_COMMITTED_COST, PR_COMMITTED_COST, SUP_INV_COMMITTED_COST, OTH_COMMITTED_COST FROM PJI_AC_ACT_CMT_BY_TASK_V WHERE PROJECT_ID = :p_project_id;

Because the view applies fixed filters on calendar, period type, RBS aggregation level, and plan version, results represent the standard accumulated, project-functional-currency, task-level slice; callers requiring alternate period types, calendars, or rollup levels should query the underlying fact table directly.

View: PJI_AC_ACT_CMT_BY_TASK_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_AC_ACT_CMT_BY_TASK_V, object_name:PJI_AC_ACT_CMT_BY_TASK_V, status:VALID, product: PJI - Project Intelligence , description: This view displays actual costs, revenue, and commitments for PA and GL periods by task. The view is used by external project management systems that import financial data from Oracle Projects. , implementation_dba_data: APPS.PJI_AC_ACT_CMT_BY_TASK_V ,
View: PJI_ACT_CMT_BY_PERIOD_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_ACT_CMT_BY_PERIOD_V, object_name:PJI_ACT_CMT_BY_PERIOD_V, status:VALID, product: PJI - Project Intelligence , description: PJI_ACT_CMT_BY_PERIOD_V is a view that displays actual cost, revenue totals, and commitment for lowest level tasks and resources by PA, and GL periods. The view is mainly used by external project management systems that import actuals from , implementation_dba_data: APPS.PJI_ACT_CMT_BY_PERIOD_V ,
View: PJI_XTD_ACT_CMT_BY_RSRC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_XTD_ACT_CMT_BY_RSRC_V, object_name:PJI_XTD_ACT_CMT_BY_RSRC_V, status:VALID, product: PJI - Project Intelligence , description: PJI_XTD_ACT_CMT_BY_RSRC_V is a view that displays actual cost, revenue totals, and commitments for PTD, QTD, YTD, and ITD by task, and resource. The view is mainly used by external project management systems that import actuals from Oracle , implementation_dba_data: APPS.PJI_XTD_ACT_CMT_BY_RSRC_V ,
View: PJI_FP_XBS_ACCUM_F_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_FP_XBS_ACCUM_F_V, object_name:PJI_FP_XBS_ACCUM_F_V, status:VALID, product: PJI - Project Intelligence , description: This table stores project reporting data , implementation_dba_data: APPS.PJI_FP_XBS_ACCUM_F_V ,
View: PJI_PRD_ACT_CMT_BY_TASK_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_PRD_ACT_CMT_BY_TASK_V, object_name:PJI_PRD_ACT_CMT_BY_TASK_V, status:VALID, product: PJI - Project Intelligence , description: PJI_PRD_ACT_CMT_BY_TASK_V is a view that displays actual cost, revenue totals, and commitments for PA, and GL periods by task. The view is mainly used by external project management systems that import actuals from Oracle Projects. , implementation_dba_data: APPS.PJI_PRD_ACT_CMT_BY_TASK_V ,
View: PJI_XTD_ACT_CMT_BY_TASK_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_XTD_ACT_CMT_BY_TASK_V, object_name:PJI_XTD_ACT_CMT_BY_TASK_V, status:VALID, product: PJI - Project Intelligence , description: PJI_XTD_ACT_CMT_BY_TASK_V is a view that displays actual cost, revenue totals, and commitments for PTD, QTD, YTD, and ITD by task. The view is mainly used by external project management systems that import actuals from Oracle Projects. , implementation_dba_data: APPS.PJI_XTD_ACT_CMT_BY_TASK_V ,
View: PJI_AC_ACT_CMT_BY_RSRC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_AC_ACT_CMT_BY_RSRC_V, object_name:PJI_AC_ACT_CMT_BY_RSRC_V, status:VALID, product: PJI - Project Intelligence , description: This view displays actual costs, revenue, and commitments for PA and GL periods by task and resources. The view is used by external project management systems that import financial data from Oracle Projects. , implementation_dba_data: APPS.PJI_AC_ACT_CMT_BY_RSRC_V ,
View: PJI_PRD_ACT_CMT_PG_TASK_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_PRD_ACT_CMT_PG_TASK_V, object_name:PJI_PRD_ACT_CMT_PG_TASK_V, status:VALID, product: PJI - Project Intelligence , description: PJI_PRD_ACT_CMT_PG_TASK_V is a view that displays actual cost, revenue totals, and commitments for PA, and GL periods by task at Program Level. The view is mainly used by external project management systems that import actuals from Oracle P , implementation_dba_data: APPS.PJI_PRD_ACT_CMT_PG_TASK_V ,
View: PJI_PRD_ACT_CMT_BY_RSRC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_PRD_ACT_CMT_BY_RSRC_V, object_name:PJI_PRD_ACT_CMT_BY_RSRC_V, status:VALID, product: PJI - Project Intelligence , description: PJI_PRD_PLN_BY_RSRC_V is a view that displays budget cost and revenue totals for PA, and GL periods by task, and resources. The view is mainly used by external project management systems that import actuals from Oracle Projects , implementation_dba_data: APPS.PJI_PRD_ACT_CMT_BY_RSRC_V ,
View: PJI_AC_PLN_BY_TASK_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_AC_PLN_BY_TASK_V, object_name:PJI_AC_PLN_BY_TASK_V, status:VALID, product: PJI - Project Intelligence , description: This view displays budgeted cost and revenue for PA and GL periods by task. The view is used by external project management systems that import financial data from Oracle Projects. , implementation_dba_data: APPS.PJI_AC_PLN_BY_TASK_V ,
View: PJI_PRD_PLN_BY_TASK_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_PRD_PLN_BY_TASK_V, object_name:PJI_PRD_PLN_BY_TASK_V, status:VALID, product: PJI - Project Intelligence , description: PJI_PRD_PLN_BY_TASK_V is a view that displays budget cost and revenue totals for PA, and GL periods by task. The view is mainly used by external project management systems that import actuals from Oracle Projects. , implementation_dba_data: APPS.PJI_PRD_PLN_BY_TASK_V ,
View: PJI_AC_PLN_BY_RSRC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_AC_PLN_BY_RSRC_V, object_name:PJI_AC_PLN_BY_RSRC_V, status:VALID, product: PJI - Project Intelligence , description: This view displays budgeted cost and revenue for PA and GL periods by task and resources. The view is used by external project management systems that import financial data from Oracle Projects. , implementation_dba_data: APPS.PJI_AC_PLN_BY_RSRC_V ,
View: PJI_PRD_PLN_BY_RSRC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_PRD_PLN_BY_RSRC_V, object_name:PJI_PRD_PLN_BY_RSRC_V, status:VALID, product: PJI - Project Intelligence , description: This new PSI view is to provide PSI functionality using new summarization model.Full Description :PJI_PRD_PLN_BY_RSRC_V is a view that displays budget costand revenue totals for PA, and GL periods by task, and resources. The view is mainly , implementation_dba_data: APPS.PJI_PRD_PLN_BY_RSRC_V ,
View: PJI_XTD_PLN_BY_RSRC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_XTD_PLN_BY_RSRC_V, object_name:PJI_XTD_PLN_BY_RSRC_V, status:VALID, product: PJI - Project Intelligence , description: PJI_XTD_PLN_BY_RSRC_V is a view that displays budget cost and revenue totals for PTD, QTD, YTD, and ITD by task, and resource. The view is mainly used by external project management systems that import actuals from Oracle Projects. , implementation_dba_data: APPS.PJI_XTD_PLN_BY_RSRC_V ,
View: PJI_XTD_PLN_BY_TASK_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PJI.PJI_XTD_PLN_BY_TASK_V, object_name:PJI_XTD_PLN_BY_TASK_V, status:VALID, product: PJI - Project Intelligence , description: PJI_XTD_PLN_BY_TASK_V is a view that displays budget cost and revenue totals for PTD, QTD, YTD, and ITD by task. The view is mainly used by external project management systems that import actuals from Oracle Projects. , implementation_dba_data: APPS.PJI_XTD_PLN_BY_TASK_V ,