Search Results map_rlmi_rbs




Overview
Explore in AI Chat

Overview

The APPS.PA_FP_MAP_BV_PUB package body is a public (PUB) PL/SQL API within the Oracle E-Business Suite Projects (PA) module. Its core business function is to map budget version amounts to financial plan target resource lists, enabling the transformation of summarized budget line data into the financial plan structures used for forecasting, budgeting, and resource-level reporting. The package operates in the Project Financial Planning (FP) area, where budget versions must be aggregated and redistributed across resource list members and tasks. The header comment identifies the source file as PAFPMBTB.pls (version 120.0), confirming this is a standard Oracle-delivered component rather than a custom extension. It includes a debug mechanism gated by the PA_DEBUG_MODE profile option, allowing diagnostic output when enabled. The package is classified as public, meaning other Oracle EBS and customer packages may legitimately call its procedures.

Key Procedures and Functions

  • GEN_MAP_BV_TO_TARGET_RL — The primary procedure for generating mappings from a source budget version to target resource list entries. It accepts a source budget version identifier together with financial plan column structures (target, estimate-to-complete, and cost/budget columns), commit and message-initialization flags, and an actual-through date that bounds the budget line data considered. It returns a standard API status, message count, and message data. Internally it drives a cursor that aggregates transaction amounts — quantity, raw cost, burdened cost, and revenue — from resource assignments joined to budget lines and a temporary calculation table, honoring the multi-currency planning option to select either transaction-currency or project-currency columns.
  • MAINTAIN_RBS_DTLS — The companion procedure that maintains Resource Breakdown Structure (RBS) detail records associated with the mapping operation. This is the procedure most relevant to the search term map_rlmi_rbs, which points to the mapping between resource list member identifiers (RLMI) and RBS elements. It ensures that RBS detail rows remain consistent when budget version amounts are mapped to target resource lists.

Tables Accessed

  • PA_BUDGET_VERSIONS — Supplies the source budget version and its attributes; the primary input anchor for the mapping.
  • PA_BUDGET_LINES — Provides the detailed budget quantities, raw/burdened costs, and revenue amounts that are summarized by resource assignment.
  • PA_RESOURCE_ASSIGNMENTS — Links resources to the budget version and joins to budget lines and the temporary calculation table.
  • PA_FP_CALC_AMT_TMP3 — A temporary calculation table holding resource list member identifiers and aggregation keys; accessed with an explicit index hint for performance.
  • PA_PROJ_FP_OPTIONS — Determines the multi-currency planning flag that governs which currency columns are summed.
  • PA_PERIODS_ALL — Provides period end dates used to bound the actual-through-date filtering of budget lines.
  • PLITBLM — The standard PL/SQL message table used to accumulate and emit API error and status messages.

Usage Notes

This package is invoked during financial plan generation and budget version mapping workflows, typically triggered from Project Financial Planning forms or concurrent programs that rebuild target resource list amounts. Because it is a PUB API, customer extensions and integrations may call it directly, but callers must supply the full set of FP column records, commit flag, and message flags, and must handle the returned status and message data. The PA_DEBUG_MODE profile enables tracing when diagnosing mapping failures. The package is referenced by two other packages, indicating it participates in a larger dependency chain within the Projects financial planning architecture.