Search Results g_org_tot_reducedcap_c




Overview
Explore in AI Chat

Overview

APPS.PA_REP_UTIL_ORGVW_PA_V is a reporting view in Oracle EBS Projects (PA) that presents organization-level utilization and capacity balances by accounting period. It is part of the PA reporting utility layer (note the PA_REP_UTIL naming convention) and consolidates summarized project balance data into a denormalized structure suitable for utilization reporting, dashboards, and downstream integration extracts.

The view joins summarized balance records to GL period definitions, organization names, and balance-type lookups, and filters to a specific set of amount types. The search term "g_org_tot_cap_c" is significant: in the view text this appears as the global constant G_ORG_TOT_CAP_C, mapped to amount_type_id = 37. This is the summarized capacity amount type, which the view subtracts against amount type 38 (reduced capacity) to derive remaining capacity.

Underlying Base Objects

The documented base objects include GL_PERIODS, HR_ALL_ORGANIZATION_UNITS_TL, HR_GENERAL, HR_ORG_UNITS_NO_JOIN, HR_SECURITY, PA_LOOKUPS, PA_OBJECTS, PA_REP_UTIL_GLOB, and PA_SUMM_BALANCES.

  • PA_SUMM_BALANCES — the primary fact source holding period-level summarized amounts (hours, capacity). Filters include version_id = -1 and object_type_code from PA_REP_UTIL_GLOB.GetObjectTypeOrg.
  • PA_OBJECTS — supplies the expenditure organization identifier.
  • GL_PERIODS — provides period start and end dates, joined on period set name and period name.
  • HR_ALL_ORGANIZATION_UNITS_TL and HR_ORG_UNITS_NO_JOIN — resolve the organization name, with an outer join and language handling via USERENV('LANG').
  • PA_LOOKUPS — resolves the balance type meaning from lookup type PA_BALANCE_TYPES.
  • PA_REP_UTIL_GLOB — package supplying runtime filter values (balance types, period type, period set name, object type).
  • HR_GENERAL / HR_SECURITY — support organization security and name resolution.

Key Columns

  • expenditure_organization_id / expenditure_organization_name — the organization the balance pertains to.
  • period_name, period_num, period_start_date, period_end_date — the accounting period the balance falls in.
  • period_quarter, period_year — quarter/month number and fiscal year references.
  • balance_type_code / balance_type_name — the PA balance type.
  • total_hours — derived from amount_type_id 31 (G_ORG_TOT_HRS_C).
  • capacity — derived from amount_type_id 37 (G_ORG_TOT_CAP_C) minus amount type 38, floored at zero via DECODE(SIGN(...),1,...,+0).

Common Use Cases and Queries

Typical uses include organization utilization reporting, capacity versus actual hours comparisons, and period-over-period trends. A representative query:

SELECT expenditure_organization_name,
       period_name,
       total_hours,
       capacity,
       CASE WHEN capacity > 0
            THEN total_hours / capacity
       END AS utilization_ratio
FROM   apps.pa_rep_util_orgvw_pa_v
WHERE  period_year = 2024
ORDER  BY expenditure_organization_name, period_num;

Because the view is driven by PA_REP_UTIL_GLOB package globals, callers should initialize the reporting utility context before querying. The view returns summarized, not transactional, data.