Search Results pji_ac_act_cmt_by_task_v




Overview
Explore in AI Chat

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:

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.