Search Results pa_status_rsrc_ei_base_v




Overview
Explore in AI Chat

Overview

The view PA_STATUS_RSRC_EI_BASE_V is an Oracle Projects (PA) reporting object owned by the APPS schema. It is documented in ETRM as "10SC Only," indicating that it exists to support a specific Oracle-delivered reporting or extraction component rather than being a general-purpose user view. In Oracle EBS 12.1.1 and 12.2.2 the view underpins the resource-level expenditure inquiry and status reporting used by the Project Status Inquiry (PSI) and related resource summarization facilities.

The view consolidates cost and revenue activity at the level of project, task, resource list member, expenditure item, and PA period. It presents a unified row set in which cost-side quantities, raw costs, burdened costs, and their billable derivatives appear alongside revenue-only rows, allowing downstream reporting components to present a complete picture of resource performance without joining the transactional cost and revenue distribution tables directly.

Underlying Base Objects

The view is defined over the following documented base objects in the APPS schema:

  • PA_RESOURCE_ACCUM_DETAILS — provides project, task, and resource list member context along with the transaction accumulation identifier.
  • PA_TXN_ACCUM — supplies the PA period and transaction accumulation header linkage.
  • PA_TXN_ACCUM_DETAILS — supplies the expenditure item identifier and the line type that discriminates cost rows (LINE_TYPE = 'C') from revenue rows (LINE_TYPE = 'R').
  • PA_COST_DISTRIBUTION_LINES_ALL — the cost distribution source for quantity, amount, burdened cost, and billable flags in the first UNION ALL branch.
  • PA_CUST_REV_DIST_LINES_ALL — the customer revenue distribution source for the revenue amounts in the second UNION ALL branch.
  • PA_PERIODS — provides PA period start and end dates for period filtering.
  • PA_STATUS — the PL/SQL package whose functions (GETPROJID, GETTASKID, GETRSRCMEMBERID, GETSTARTDATE, GETENDDATE) drive the run-time bind parameters of the view.

Because the view invokes PA_STATUS package functions in its WHERE clause, it is a context-sensitive view whose returned rows depend on the session-level state set by the Project Status Inquiry framework before the query executes.

Key Columns

Common Use Cases and Queries

The view is queried within Project Status Inquiry and resource-level summarization to display cost and revenue by resource list member and period. Because its filters are driven by PA_STATUS package state, ad-hoc queries normally set up that state first, or replicate the filtering directly. A typical query resembles:

SELECT project_id, task_id, resource_list_member_id, pa_period,
       SUM(quantity) quantity, SUM(billable_quantity) billable_qty,
       SUM(billable_raw_cost) billable_raw, SUM(amount) revenue
FROM   pa_status_rsrc_ei_base_v
GROUP  BY project_id, task_id, resource_list_member_id, pa_period;

Typical uses include reconciling billable versus non-billable resource quantities, comparing accounted and burdened costs against revenue per period, and feeding custom resource status reports. Direct reliance on the view outside the delivered framework is discouraged, since its behavior depends on the PA_STATUS package session context and the view is marked as supporting a specific component.