Search Results pabv_task_act_summary




Overview
Explore in AI Chat

Overview

PABV_TASK_ACT_SUMMARY is a read-only Oracle EBS view owned by the APPS schema within the Projects (PA) module. It presents summarized task-level actual cost, quantity, and revenue accumulations by accounting period. In both EBS 12.1.1 and 12.2.2, the view is documented as "Retrofitted," a designation indicating it was preserved or re-created to maintain compatibility with prior customizations, reports, and integrations that referenced it. Because the view carries a WITH READ ONLY clause, it can be queried safely without risk to the underlying Projects accumulation data.

The view is intended for reporting and analytical purposes rather than transactional entry. It consolidates values from the Projects accumulation tables for the natural resource category (resource identifier zero), meaning the summarized figures represent pure resource costs, quantities, labor hours, and revenue at the project and task level. This makes it particularly suitable for period-over-period comparisons and project performance reporting.

Underlying Base Objects

PABV_TASK_ACT_SUMMARY is defined over four documented base objects:

The join conditions link PROJECT_ACCUM_ID between the actuals and headers, and PROJECT_ID across headers, periods, and projects. Filters restrict the output to resource-neutral accumulation rows (RESOURCE_ID, RESOURCE_LIST_ID, RESOURCE_LIST_MEMBER_ID, and RESOURCE_LIST_ASSIGNMENT_ID all set to 0) and exclude the unassigned task (TASK_ID <> 0). The view also applies Projects user security via the ORG_ID predicate, so results are scoped to the projects the querying user is authorized to see.

Key Columns

The view exposes a wide set of accumulated measures, each repeated across four time horizons: inception-to-date (ITD), year-to-date (YTD), prior period (PP), and period-to-date (PTD).

  • PROJECT_ACCUM_ID, PROJECT_ID, TASK_ID — keys identifying the accumulation line, project, and task.
  • ACCUM_PERIOD — the accounting period for the summarized amounts.
  • RAW_COST_* — raw (unburdened) costs.
  • BILLABLE_RAW_COST_* — the billable portion of raw cost.
  • BURDENED_COST_* and BILLABLE_BURDENED_COST_* — burdened and billable burdened costs.
  • QUANTITY_* and BILLABLE_QUANTITY_* — total and billable quantities. BILLABLE_QUANTITY_PTD is the period-to-date billable quantity, the column most commonly referenced by users searching this view.
  • LABOR_HOURS_* and BILLABLE_LABOR_HOURS_* — total and billable labor hours.
  • REVENUE_* — recognized revenue amounts.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard audit columns.

Common Use Cases and Queries

This view is typically used for project cost and billing reporting, revenue analysis, and reconciliation between raw costs and billable amounts. A common requirement is to retrieve period-to-date billable quantities and costs for a given project and period:

  • Report billable quantity and billable burdened cost by task for a specific accounting period.
  • Compare period-to-date versus year-to-date and inception-to-date accumulations for trend analysis.
  • Feed custom reports or extracts where the resource-neutral summarized totals are required.

A representative query follows:

  • SELECT task_id, accum_period, billable_quantity_ptd, billable_burdened_cost_ptd, revenue_ptd FROM apps.pabv_task_act_summary WHERE project_id = :project_id AND accum_period = :period ORDER BY task_id;

Because of the read-only definition and the built-in organization security predicate, the view can be exposed directly to reporting users without granting write access to the underlying Projects accumulation tables.