Results for “res_list_to_plan_res_list”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PA_RES_LIST_UPGRADE_PKG is a PL/SQL package body within the Oracle E-Business Suite Projects (PA) module responsible for upgrading and migrating legacy resource list definitions into the forecast resource-list framework. The package addresses a data-model transition in which resource lists created prior to the introduction of Oracle Projects forecasting had no associated migration code, and therefore were not recognized by the forecasting resource-list engine. The business purpose of the package is to bridge that gap by converting qualifying resource lists into planning resource lists with the appropriate plan resource defaults, formats, and member mappings.

The header comment records the last revision at version 120.5 dated 2008/07/24, which places the package within the code line maintained across both the 12.1.1 and 12.2.2 releases. Its classification in the ETRM repository is OTHER, reflecting that it functions as an internal upgrade utility rather than a published integration API, and it is referenced by two other packages that depend on its conversion logic.

Key Procedures and Functions

The ETRM metadata documents a single public procedure, RES_LIST_TO_PLAN_RES_LIST. This procedure performs the core conversion of an individual resource list into a planning (forecast) resource list. It accepts a resource list identifier together with commit and initialization flags, and returns the standard concurrent-style status triple consisting of a return status, message count, and message data. It is the workhorse called repeatedly by the driver logic.

The excerpt additionally reveals a second entry point, RES_LIST_PLAN_LIST_WHEN_NULL. Although not itemized in the documented procedure list, it is the routine that scans PA_RESOURCE_LISTS for rows whose migration_code is null, explicitly excluding the resource list currently designated by the PA_FORECAST_RESOURCE_LIST profile option. It bulk-collects the qualifying identifiers into a PL/SQL table and iterates over them, invoking RES_LIST_TO_PLAN_RES_LIST for each row. The procedure honors the PA_DEBUG_MODE profile option, writing diagnostic output through PA_DEBUG when enabled, and propagates errors by raising PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc when a child call fails. Its NOCOPY OUT parameters and FND_API return status convention are consistent with Oracle Projects' internal error-handling standards.

Tables Accessed

The package reads and writes a broad set of Projects resource and planning tables through APPS synonyms. PA_RESOURCE_LISTS is queried to identify candidate lists with a null migration code. PA_RESOURCE_LIST_MEMBERS and PA_RESOURCE_LIST_MEMBERS_S hold the individual resource assignments that must be carried forward. PA_PLAN_RES_DEFAULTS stores the default planning attributes applied to the new list, while PA_PLAN_RL_FORMATS and PA_PLAN_RL_FORMATS_S define the planning resource-list formats used to structure it.

The supporting reference tables include PA_RESOURCE_CLASSES_B and PA_RESOURCE_CLASSES_TL for resource class definitions and translations, PA_RESOURCE_TYPES and PA_RES_TYPES_B for resource type identification, PA_RES_FORMATS_B for resource formats, PA_RESTYPE_MAP_TO_RESFORMAT for the mapping between resource types and formats, and PA_EXPENDITURE_TYPES for validation of expenditure-related members. DUAL is used for single-row lookups, and PLITBLM is the Oracle-supplied index table underlying the IdTabTyp collection used in the bulk fetch.

Usage Notes

PA_RES_LIST_UPGRADE_PKG is invoked as a one-time or repeatable upgrade utility, typically executed during patch application or data migration following an upgrade to a forecasting-enabled release. Because the driver procedure filters strictly on migration_code being null and skips the profile-designated forecast resource list, the package is idempotent: re-running it after a successful pass finds no remaining candidates. It may be called from a concurrent program wrapper, a database upgrade script, or custom PL/SQL that requires conversion of resource lists in bulk. Callers should ensure the PA_FORECAST_RESOURCE_LIST profile option is set to the intended target list before execution, and should inspect the returned status, message count, and message data for each invocation. The reference to TFS (Trading and Financial Services) and R10.1 in the originating search indicates this package has been examined in the context of Oracle Financial Services deployments of EBS, where resource-list forecasting is used for engagement staffing and revenue planning.