Search Results pa_fp_calc_amt_tmp1




Overview
Explore in AI Chat

Overview

PA_FP_GEN_FCST_RMAP_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an OTHER API. Its business purpose is to support the Forecast Generation process within Oracle Project Management and Oracle Project Costing by mapping estimate-to-complete (ETC) source transactions to the resource list of a target project plan version. In other words, when a forecast plan version is generated, the resource assignments, roles, jobs, suppliers, and non-labor resources associated with source ETC transactions must be reconciled against the resource breakdown structure of the destination plan. This package performs that reconciliation mapping.

The package header comment (revision 120.2, dated 2006/01/16) identifies the primary method as "used to map the ETC source txns to the target plan version resource list." A debug profile check via FND_PROFILE.value('PA_DEBUG_MODE') is initialized at the package level, reflecting standard PA diagnostic instrumentation.

Key Procedures and Functions

The ETRM metadata documents a single procedure within this package:

  • FCST_SRC_TXNS_RMAP — Maps ETC source transactions to the target plan version resource list. The procedure accepts a project identifier, a budget version identifier, and a record of forecast column definitions, and returns a status, a message count, and message data (the standard PA error-stack return signature). Internally it declares a cursor, map_to_target_fp_cur, which selects resource assignment information — person, job, organization, supplier, expenditure type, event type, non-labor resource, expenditure and revenue categories, cost type, resource class, inventory item, BOM resource, named role, and planning start/end dates — from the temporary staging table PA_FP_CALC_AMT_TMP1. A Bug 4070976 fix noted in the source restricts the cursor to resources with a null TARGET_RLM_ID, ensuring that only unprocessed rows are picked up. The cursor feeds PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS, which completes the mapping of resource list members to the RBS structure.

Tables Accessed

The documented tables referenced through APPS synonyms are:

  • PA_FP_CALC_AMT_TMP1 / PA_FP_CALC_AMT_TMP2 — Temporary calculation tables that stage forecast amounts and resource detail. PA_FP_CALC_AMT_TMP1 is the source of the cursor rows, precisely the table referenced by the user's search term pa_fp_calc_amt_tmp1.
  • PA_FP_PLANNING_RES_TMP1 — Temporary planning resource staging table used during forecast plan generation.
  • PA_PROJ_FP_OPTIONS — Stores forecast plan generation options per project; supplies the P_PROJECT_ID parameter type and drives selection logic.
  • PA_BUDGET_VERSIONS — Provides the target plan/budget version context.
  • PA_BUDGET_LINES — Budget line detail for the plan version being mapped.
  • PA_RESOURCE_ASSIGNMENTS — The target resource assignments against which source transactions are matched; the cursor labels its source type 'RES_ASSIGNMENTS'.
  • PA_RESOURCE_LISTS_ALL_BG — The resource list definition used to validate and map target resources.
  • PLITBLM — Standard EBS PL/SQL table-of-varchar2 utility used for message and list handling.

Usage Notes

This package is not exposed to end users directly; it is invoked internally by the forecast generation flow, typically from the Generate Forecast concurrent program or from the parent PL/SQL processes that build and populate the PA_FP_CALC_AMT_TMP1 staging table before resource mapping. The ETRM metadata records that it is referenced by exactly one other package, confirming its position as an internal helper rather than a public API. Because rows are consumed only where TARGET_RLM_ID is null, callers must ensure the staging table has been fully populated before invoking FCST_SRC_TXNS_RMAP, and must re-invoke processing if additional rows are loaded. Debug output is controlled by the PA_DEBUG_MODE profile option. Customizations that insert into PA_FP_CALC_AMT_TMP1 must respect the column contract expected by the cursor — resource, classification, and planning-date columns — or the mapping to the target resource list will silently skip those rows.