Search Results gen_map_bv_to_target_rl




Overview
Explore in AI Chat

Overview

PA_FP_MAP_BV_PUB is a public PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Project Manufacturing and Project Billing forecasting infrastructure — specifically the Forecast Generation and Budget Version mapping logic used by Project Resource Management and Project Costing. The package name reflects its role within the PA_FP (Project Forecasting/Financial Planning) family: it maps budget version (BV) definitions to target resource and forecast structures. In releases 12.1.1 and 12.2.2 the object is delivered with a VALID status and is classified as a PUB (public) API, meaning it is intended for invocation by other Oracle application modules and, where supported, by customer extensions.

The package participates in the broader forecast generation flow: forecasting in Oracle Projects derives planned amounts from budget versions, distributes them across accounting periods, and writes the results into forecast or budget line tables. PA_FP_MAP_BV_PUB provides the mapping and maintenance layer that resolves which budget version supplies source amounts and how the resulting detail rows are structured for the target forecast.

Key Procedures and Functions

ETRM documents two callable program units within this package:

  • GEN_MAP_BV_TO_TARGET_RL — Generates the mapping between a source budget version and the target forecast/budget structure. Its purpose is to translate budget-version-based amounts into the target resource list (RL) required by downstream forecast generation and amount calculation routines. It serves as the bridge between budget definition data and the target planning structure.
  • MAINTAIN_RBS_DTLS — Maintains Resource Breakdown Structure (RBS) detail records associated with the mapping. This routine manages the RBS-level detail rows needed so that mapped forecast amounts retain correct resource hierarchy and rollup behavior.

Parameter lists are not reproduced here; callers should consult the package specification in the target instance, as signatures may differ between 12.1.1 and 12.2.2.

Tables Accessed

The documented dependency information identifies the following tables, accessed through APPS synonyms:

  • PA_BUDGET_VERSIONS — Source of budget version definitions being mapped.
  • PA_PERIODS_ALL — Provides accounting period information used to align mapped amounts with period ranges.
  • PA_BUDGET_LINES — Budget line detail that supplies the amounts being mapped to the target structure.
  • PA_FP_CALC_AMT_TMP3 — A temporary/working table holding calculated forecast amounts during processing.
  • PA_PROJ_FP_OPTIONS — Project-level forecast options controlling how generation and mapping behave.
  • PA_RESOURCE_ASSIGNMENTS — Resource assignment data used to resolve the target resource list for mapped rows.
  • PLITBLM — The standard Oracle Projects PL/SQL index-by table type used for bulk processing of identifiers and amounts.

The package also calls PA_FP_GEN_AMOUNT_UTILS for amount computation utilities during mapping.

Usage Notes

PA_FP_MAP_BV_PUB is not an end-user-facing API. It is invoked programmatically by the forecast generation stack. ETRM records that it is referenced by PA_FP_GEN_FCST_AMT_PUB1 and PA_FP_GEN_PUB, both of which are forecast generation entry points. These are typically driven from the Project Forecast Generation concurrent program or from Project Management and Project Billing forms that trigger forecast creation.

Because the package is classified PUB and its subordinate routines are called by other PA_FP modules, customizations should avoid modifying the package body. Instead, use the standard forecast generation APIs and concurrent programs, or wrap supported public entry points. Always verify the actual specification in the target instance (12.1.1 vs. 12.2.2) before relying on a given procedure, since the documented signatures are not reproduced in the ETRM metadata.