Search Results pa_fc_res_map




Overview
Explore in AI Chat

Overview

PA_FC_RES_MAP is an Oracle Applications (APPS) PL/SQL package belonging to the Oracle Project Costing / Forecasting and Budgeting family of modules within Oracle E-Business Suite. Its name derives from "Project Accounting – Forecasting/Financial Consolidation – Resource Map," indicating that its primary business purpose is to maintain the association between project resources and the resource mapping definitions used during forecasting, budgeting, and financial consolidation processes. In Release 12.1.1 and 12.2.2, the package is registered in the ETRM repository with a status of VALID and is classified as an OTHER API rather than a formal public interface, which indicates it is an internal utility package invoked by other project accounting components rather than exposed for direct customer calls. The package encapsulates the logic required to translate raw resource assignments into the mapping structures consumed by the Project Resource Management and forecasting engines.

Key Procedures and Functions

ETRM documents two procedures/functions within this package:

  • DELETE_RES_MAPS_ON_ASGN_ID — Removes resource map records that are keyed to a specific assignment identifier. It is used when an assignment is deleted, terminated, or reorganized, ensuring that orphaned resource–mapping relationships are not retained in the resource map table.
  • MAP_TRANS — Performs the mapping or transformation of resource records, transferring resource assignment data into the appropriate resource mapping structure. This supports the reconciliation of resources across project forecasting or consolidation boundaries.

Because the documentation does not expose parameter lists, exact signatures must be obtained from the package specification in the APPS schema (via DESCRIBE or the ETRM source view) before making direct programmatic calls. Neither procedure should be assumed to be a public API.

Tables Accessed

The documented table dependency is PA_RESOURCE_MAPS, accessed through its APPS synonym. This is the core repository where resource-to-mapping associations are persisted for the forecasting and consolidation engines. The package writes to and reads from this table in order to add transformed mappings (via MAP_TRANS) and to remove stale mapping rows (via DELETE_RES_MAPS_ON_ASGN_ID). All other references in the dependency chain are limited to the SYS.STANDARD package, confirming that PA_FC_RES_MAP does not directly touch the primary project transaction tables (such as PA_PROJECTS, PA_TASKS, or PA_ASSIGNMENTS); instead, it works only against the derived resource map store.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, this package is invoked indirectly. Typical callers include project resource assignment form logic and concurrent programs that perform assignment maintenance, project forecasting, or financial consolidation. When a user deletes or reassigns a resource assignment, the assignment maintenance layer calls DELETE_RES_MAPS_ON_ASGN_ID to maintain referential consistency. When forecasting or consolidation data is regenerated, MAP_TRANS is called to refresh the resource map entries. The ETRM metadata shows the package is referenced by zero other packages, meaning it is a leaf dependency rather than a shared utility, although it internally references no other APPS packages either. Because it is classified as an OTHER API and its procedures are not documented as public, customizations should not call these procedures directly. Any change to PA_RESOURCE_MAPS through direct DML risks bypassing the mapping validation logic embedded in MAP_TRANS and DELETE_RES_MAPS_ON_ASGN_ID. Administrators investigating resource mapping discrepancies during forecasting or consolidation should enable PL/SQL tracing on this package while reproducing the affected operation, and should confirm the exact procedure signatures from the live package specification rather than relying on the summarized ETRM listing.