Search Results pa_rep_util_orgvw_ge_v




Overview
Explore in AI Chat

Overview

PA_REP_UTIL_ORGVW_GE_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. It is documented as a reporting utility that supplies Capacity and Total Hours values for expenditure organizations across the Global Week, and its output feeds the Disco Workbooks used for resource utilization analysis. The view carries a VALID status in the ETRM object registry and is present in both EBS 12.1.1 and 12.2.2, where it is referenced primarily by Oracle Projects reporting components rather than by transactional processing.

The "GE" in the object name denotes the Global Expenditure period type, and the view is effectively the organization-level counterpart of other PA_REP_UTIL views. The column most frequently searched for in connection with this object is EXPENDITURE_ORGANIZATION_NAME, which is the HR organization name resolved from the expenditure organization identifier. That column is what allows Disco Workbooks and ad hoc reports to present utilization figures grouped by organization name rather than by internal numeric identifier.

Underlying Base Objects

The view is defined over five principal sources, as documented in the ETRM metadata and the view text.

The PA_REP_UTIL_GLOB package supplies the runtime constants that drive the filters: the period type (GETPERIODTYPEGE), the object type code for organizations (GETOBJECTTYPEORG), the dummy period set name, and the balance type codes for actuals and forecast. HR_GENERAL and HR_SECURITY packages are invoked to apply language and security context.

Key Columns

  • EXPENDITURE_ORGANIZATION_ID — the expenditure organization identifier from PA_OBJECTS.
  • EXPENDITURE_ORGANIZATION_NAME — the organization name from HR_ALL_ORGANIZATION_UNITS_TL, resolved in the user's language. This is the column normally used for display and grouping.
  • EXP_END_DATE — the global expenditure period end date from PA_SUMM_BALANCES.
  • PERIOD_MONTH and PERIOD_YEAR — the quarter or month number and the year of the summarized balance period.
  • BALANCE_TYPE_NAME and BALANCE_TYPE_CODE — the lookup meaning and code identifying whether the row reflects actuals or forecast.
  • TOTAL_HOURS — a conditional aggregate over amount type 31 (G_ORG_TOT_HRS_C), returning zero where no such balance exists.
  • CAPACITY — computed as the amount for type 37 (G_ORG_TOT_CAP_C) less the amount for type 38 (G_ORG_TOT_REDUCEDCAP_C), floored at zero via a DECODE on SIGN.

Common Use Cases and Queries

The view is typically queried to compare organizational capacity against recorded hours for a given global week or period, most often to support utilization reporting and the Disco Workbooks. A representative query retrieving organization-level utilization data is shown below.

SELECT expenditure_organization_name, exp_end_date, period_month, period_year, balance_type_name, total_hours, capacity FROM apps.pa_rep_util_orgvw_ge_v WHERE period_year = :p_year ORDER BY expenditure_organization_name, exp_end_date;

A narrower query, useful when only named organizations with non-zero capacity are required, filters on the calculated capacity column.

SELECT expenditure_organization_name, total_hours, capacity FROM apps.pa_rep_util_orgvw_ge_v WHERE capacity > 0 AND balance_type_code = :p_balance_type;

Because the definition depends on session language and HR security, results returned for EXPENDITURE_ORGANIZATION_NAME can differ between users with different language or organization security profiles. Reports that join this view to other PA summary objects should therefore always join on EXPENDITURE_ORGANIZATION_ID rather than on the name, and should constrain the period year and period month to avoid aggregating across unrelated global expenditure periods.