Search Results billable_quantity

Overview

PJI_ACT_CMT_BY_PERIOD_V is an Oracle E-Business Suite view owned by the APPS schema within the PJI (Project Intelligence) product family. It consolidates actual cost, revenue totals, and commitment data for the lowest-level tasks and resources in Oracle Projects, aggregated across both PA (Project Accounting) periods and GL (General Ledger) periods. The view is primarily intended for consumption by external project management systems that import actuals from Oracle Projects, and it also serves as a reporting foundation for period-based project performance analysis in Oracle EBS 12.1.1 and 12.2.2.

Because it exposes quantities and costs at the resource level, the view is frequently interrogated when users search for cost or billing metrics such as billable_quantity. The BILLABLE_QUANTITY column allows reporting of the portion of total project quantity that is billable versus non-billable, which is essential for revenue recognition, invoicing reconciliation, and utilization analysis.

Underlying Base Objects

Per the documented view text and ETRM metadata, PJI_ACT_CMT_BY_PERIOD_V is defined over a single base object: PJI_PRD_ACT_CMT_BY_RSRC_V, an APPS view that stores actual and commitment balances by resource. The relationship is a straightforward SELECT that maps each column from the base resource-level view to the reporting view, retaining PROJECT_ID, TASK_ID, PERIOD_NAME, and the various cost, revenue, and quantity measures. There are no joins, unions, or filter predicates in the documented view definition, meaning data granularity is inherited directly from PJI_PRD_ACT_CMT_BY_RSRC_V. No direct table access is performed by this view; all underlying data resolution occurs within the base view and its own dependencies.

Key Columns

PROJECT_ID / TASK_ID – Identifiers for the project and its lowest-level task, enabling drill-down to the finest work breakdown structure level.
PERIOD_NAME / PERIOD_START_DATE / PERIOD_END_DATE – The PA or GL period context for the aggregated figures, supporting period-to-date and comparative reporting.
RBS_ELEMENT_ID / RBS_VERSION_ID – Resource breakdown structure identifiers, allowing aggregation by resource type or individual resource.
CALENDAR_TYPE – Distinguishes whether PA or GL period calendars apply.
QUANTITY / BILLABLE_QUANTITY – Total transacted quantity and the billable subset, central to utilization and billing analysis.
LABOR_HRS / BILL_LABOR_HRS / EQUIPMENT_HOURS / BILLABLE_EQUIPMENT_HOURS – Detailed labor and equipment hour metrics, both total and billable.
REVENUE / LABOR_REVENUE – Recognized and labor-specific revenue amounts.
RAW_COST / BURDENED_COST / CAPITAL_RAW_COST / CAPITAL_BURDENED_COST – Actual cost measures at raw and burdened levels, including capitalized portions.
LABOR_RAW_COST / LABOR_BRDN_COST / EQUIPMENT_RAW_COST / EQUIPMENT_BRDN_COST / BILL_LABOR_RAW_COST / BILL_LABOR_BRDN_COST – Cost components split by expenditure category and billability.
CMT_QUANTITY / SUP_INV_COMMITTED_COST / PO_COMMITTED_COST / PR_COMMITTED_COST / OTH_COMMITTED_COST / CMT_BURDENED_COST – Commitment quantities and amounts by source (supplier invoice, purchase order, requisition, and other), plus burdened commitment cost.

Common Use Cases and Queries

Typical usage includes external system integration, where actual costs, revenue, and commitments are extracted by period for import into third-party project management tools. Reporting users also query the view to compare billable versus total quantities, evaluate burdened versus raw cost, or reconcile commitments by source document.

A representative query retrieving billable quantity and cost by project, task, and period:

SELECT project_id, task_id, period_name, quantity, billable_quantity, raw_cost, burdened_cost, revenue FROM apps.pji_act_cmt_by_period_v WHERE period_name = 'JAN-24' ORDER BY project_id, task_id;
SELECT project_id, SUM(billable_quantity), SUM(quantity), SUM(labor_revenue) FROM apps.pji_act_cmt_by_period_v GROUP BY project_id;
SELECT project_id, task_id, period_name, po_committed_cost, pr_committed_cost, sup_inv_committed_cost, cmt_burdened_cost FROM apps.pji_act_cmt_by_period_v WHERE calendar_type = 'PA';

These patterns support billing validation, utilization reporting, and commitment tracking, confirming the view's role as a consolidated period-level reporting interface for Oracle Projects actuals and commitments.

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_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_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_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_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_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_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_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_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_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_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_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 ,