Search Results pa_forecast_grc_pvt




Overview
Explore in AI Chat

Overview

PA_FORECAST_GRC_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a PVT (private) API within the Oracle Projects (PA) module. Its name reflects its role in Global Resource Capacity forecasting, combining the forecast (PA_FORECAST) and resource capacity (GRC) domains. The package encapsulates the core logic used to derive resource capacity values that feed forecasting and summarization routines in Oracle Projects. Because it is a private package, it is not intended to be called directly by external or customer code; instead it exposes internal subprograms consumed by listed public packages, most notably PA_REP_UTILS_SUMM_PKG. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it depends on the shared APPS.PA_PLSQL_DATATYPES package as well as the SYS.STANDARD package. The documented metadata records two exposed subprograms and a set of denormalized Project resource and summarization tables, indicating that the package operates at the intersection of resource capacity computation and project summary balance maintenance.

Key Procedures and Functions

The ETRM documentation for 12.2.2 records two documented subprograms within this package:

  • GET_RESOURCE_CAPACITY — Returns the capacity available for a given resource, serving as the primary entry point for retrieving capacity figures used in resource forecasting. It abstracts the logic that determines how much capacity a resource contributes within a project or organizational context.
  • GET_CAPACITY_VECTOR — Returns capacity as a vector (a collection of values aligned across a date or period dimension), enabling callers such as PA_REP_UTILS_SUMM_PKG to process capacity across multiple periods in a single invocation. This vector form supports summarization and reporting workloads that aggregate capacity over time.

No parameter lists are documented in the ETRM metadata; only the subprogram names and their roles are recorded. Accordingly, the exact signatures are not asserted here. Both subprograms are callable only from within the APPS schema or by packages granted access, consistent with the PVT classification.

Tables Accessed

The package references the following tables through APPS synonyms, and its interaction with them reflects its capacity and forecasting purpose:

  • PA_RESOURCES_DENORM and PA_RESOURCE_TXN_ATTRIBUTES — denormalized resource definitions and transaction-level attributes that supply the resource dimension for capacity calculation.
  • PA_SUMM_BALANCES — summarized project balances, which the capacity vector is aligned against for reporting.
  • PA_UTILIZATION_OPTIONS — configuration controlling how utilization and capacity are derived.
  • PA_IMPLEMENTATIONS and PA_OBJECTS — installation-level settings and object metadata used to resolve project and resource context.
  • GL_PERIODS and GL_DATE_PERIOD_MAP — General Ledger period definitions and the date-to-period mapping that allow capacity vectors to be produced on a period basis.
  • PLITBLM — a PL/SQL index-by table type used internally to hold the capacity vector between computation and return.

Together these tables indicate that the package reads resource and utilization configuration, resolves accounting periods, and supplies period-aligned capacity values for downstream summary processing rather than writing transactional data.

Usage Notes

PA_FORECAST_GRC_PVT is invoked indirectly. The ETRM dependency data shows it is referenced by the public package PA_REP_UTILS_SUMM_PKG, meaning capacity calculations are triggered as part of project reporting and summarization routines rather than by end-user forms directly. Administrators and developers should not call this private package from custom code; instead, they should use supported public APIs or the concurrent programs that call PA_REP_UTILS_SUMM_PKG. Understanding this package is most valuable when diagnosing resource capacity values appearing in project summaries or forecast reports, or when tracing how period-aligned capacity is computed from utilization options and denormalized resource data. Because it is a PVT package, Oracle reserves the right to change its internals without notice across 12.1.1 and 12.2.2.