Search Results gl_period_number




Overview
Explore in AI Chat

Overview

APPS.PA_REP_RES_CAP_GL_V is an internal Oracle Applications view that presents resource capacity information aligned to General Ledger (GL) accounting periods. It is owned by the APPS schema and is registered under FND Design Data as PA.PA_REP_RES_CAP_GL_V. The view combines resource denormalized attributes with GL period definitions and organization (HR) job data, allowing capacity hours to be reported against a specific GL period name, period set, and period number. In the context of Oracle EBS 12.1.1 and 12.2.2, this view is primarily used by Oracle Projects reporting and integration logic that must reconcile resource capacity with the financial period calendar.

The view is explicitly marked as Oracle Internal Use Only. Oracle Corporation does not support direct access to this object except from standard Oracle Applications programs. Its status is VALID, and it is a standard (non-materialized) internal view.

Underlying Base Objects

According to the documented dependency metadata, APPS.PA_REP_RES_CAP_GL_V is defined over the following objects:

  • GL_PERIODS (reached via synonym) — supplies GL period name, period set name, period number, year, and quarter.
  • GL_SETS_OF_BOOKS (view) — supplies the set of books / ledger context used to resolve the GL calendar.
  • PA_IMPLEMENTATIONS (synonym) — provides the Oracle Projects implementation context (business group, org, and related setup).
  • PA_RESOURCES_DENORM (synonym) — the denormalized resource table that supplies resource, manager, organization, and job attributes.
  • PA_RESOURCE_UTILS (package) — PL/SQL utility package used in the view's definition, typically for resource name derivation or capacity computation.
  • PER_JOBS (synonym) — the HR job definition table supplying job names.

The view is not referenced by any other database object, confirming its role as a leaf reporting object consumed directly by application code or reports.

Key Columns

The view exposes the following columns, all of which are relevant to capacity reporting:

  • RESOURCE_ID / RESOURCE_NAME — internal identifier and display name of the resource.
  • MANAGER_ID / MANAGER_NAME — the resource's manager.
  • ORGANIZATION_ID — the organization to which the resource belongs.
  • YEAR / QUARTER — the fiscal year and quarter to which the GL period belongs.
  • GL_PERIOD_NAME — the name of the GL period (e.g., JAN-24).
  • GL_PERIOD_SET_NAME — the accounting period set/calendar name.
  • GL_PERIOD_NUMBER — the numeric identifier of the GL period, which the user specifically searched for. It is essential for ordering periods chronologically and for joins to GL period-based tables.
  • CAPACITY_HOURS — the number of capacity hours for the resource in that period.
  • JOB_NAME / RESOURCE_JOB_LEVEL — the resource's HR job and job level.
  • PERSON_TYPE — the person type of the resource (e.g., employee, contingent worker).
  • ORG_ID — the operating unit / organization identifier for multi-org security.

Common Use Cases and Queries

Typical uses include reporting resource capacity by GL period, reconciling capacity against project assignments, and feeding period-based resource utilization reports. Because the view uses GL_PERIOD_NUMBER, period-based filtering and ordering are straightforward.

Example query:

  • SELECT resource_name, gl_period_name, gl_period_number, capacity_hours FROM apps.pa_rep_res_cap_gl_v WHERE gl_period_set_name = :p_period_set AND org_id = :p_org_id ORDER BY gl_period_number;

Additional scenarios include filtering by manager, organization, or job to analyze capacity distribution, and joining to PA resource assignment tables on RESOURCE_ID and GL_PERIOD_NUMBER for utilization analysis.

Because the object is Oracle Internal Use Only and unsupported for direct access, any custom reporting should be validated against standard Oracle Projects and GL reporting programs in the target EBS release.