Search Results pa_refresh_res_lists




Overview
Explore in AI Chat

Overview

PA_REFRESH_RES_LISTS is a standard Oracle Projects (PA) PL/SQL package in the APPS schema that maintains the accumulated actuals and commitments figures associated with resource lists. Resource lists in Oracle Projects define named groupings of resources — such as expenditure categories, employees, jobs, or non-labour resources — that are used throughout project performance reporting, summarisation, and cost collection. The package exists to reconcile and refresh the summarised balances that Oracle Projects stores per resource list so that reporting enquiries, project status reports, and resource-based analytics reflect current transaction activity.

The header comment (identified by the $Header tag dated 2005/08/19) confirms the package has been stable since the 11i era and is carried forward into EBS 12.1.1 and 12.2.2 without functional change. Its single documented procedure accumulates actuals and commitments for a specific resource list within a defined accounting period and project context. In ETRM metadata the package is classified as API classification OTHER, meaning it is not a published open interface but an internal utility invoked by Oracle Projects' own processing flows. It is referenced by zero other packages according to the documented metadata, so it is treated as a leaf-level worker routine.

Key Procedures and Functions

The package exposes one documented procedure:

  • PROCESS_RES_LISTS — Accumulates actuals and commitments for a given resource list. Based on the documented signature, it accepts a project identifier, a resource list identifier, the current and previous accounting period names, the current accounting year, and the start and end dates of the current period. It also carries the standard Oracle error-handling trio: an error stack, an error stage, and an error code, each declared as IN OUT NOCOPY so that diagnostic context propagates back to the caller. The procedure is the sole entry point of the package; there are no documented functions or additional procedures.

Tables Accessed

The package reads and writes the following documented tables (accessed via APPS synonyms):

  • PA_RESOURCES — the resource definition table. Used to resolve the resources that belong to the resource list being processed.
  • PA_RESOURCE_LIST_MEMBERS — the membership table linking resources to a resource list. Read to determine which resources participate in the accumulation.
  • PA_RESOURCE_LIST_ASSIGNMENTS — links resource lists to projects or other owning entities. Read to establish the assignment context for the list being refreshed.
  • PA_TXN_ACCUM — the transaction accumulation table holding raw accumulated amounts. Read to obtain the actuals and commitments that feed the summary.
  • PA_RESOURCE_ACCUM_DETAILS — the resource-level accumulation detail table. Written with the recalculated actuals and commitments for the resource list, forming the refreshed balance that downstream reports consume.

Usage Notes

PROCESS_RES_LISTS is not a public API. It is invoked internally by Oracle Projects when resource list summaries must be rebuilt — typically following cost distribution, commitment updates, or period close activity that changes the underlying accumulation data. The parameters for period name, year, and start/end dates indicate the caller supplies a fully resolved accounting period context, so the procedure itself is period-agnostic and can be reused across open and closed periods.

Direct invocation from custom code is discouraged. Implementations that need resource list balances refreshed should call the supported Oracle Projects concurrent processes (such as those that maintain resource list summaries or run project summarisation), which in turn call this package with properly derived period parameters. Because the error information is returned through the x_err_stack, x_err_stage, and x_err_code parameters rather than raised exceptions, any custom caller must inspect these OUT values after execution and translate them into application-level error handling. The package carries no dependencies on other packages and none on it, so it can be analysed in isolation when troubleshooting resource list reporting discrepancies in either 12.1.1 or 12.2.2.