Search Results map_rbs_plans

Overview

PA_RBS_MAPPING is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) module and supports the Resource Breakdown Structure (RBS) framework, which provides the hierarchical classification of resources — expenditures, event types, and planning resources — used throughout project costing, budgeting, and summarization. The package status is VALID in the ETRM dictionary, and its API classification is recorded as OTHER, indicating that it is an internal utility package rather than a formally published open interface.

The principal business function of PA_RBS_MAPPING is to translate source project transaction data into RBS-mapped resources so that summarization, rollup, and reporting processes operate against a consistent resource taxonomy. It maps actual costs, budgets and plans, and inherited resource types into the RBS structures defined for a project, and supplies the numeric identifiers and tokens that other RBS utilities require when building or validating mapping rules.

Key Procedures and Functions

ETRM documents nine callable objects in APPS.PA_RBS_MAPPING:

• MAP_RBS_ACTUALS_NEW — Maps actual project transactions to RBS resources using the current mapping logic. This is the successor routine used by concurrent summarization flows in Release 12.x.
• MAP_RBS_ACTUALS — The earlier form of the actuals mapping routine; retained for backward compatibility with existing callers.
• MAP_RBS_PLANS — Maps planning and budgeting resource records to their corresponding RBS elements and versions.
• CREATE_RES_TYPE_NUMERIC_ID — Creates or derives the numeric resource type identifier required for RBS mapping rows.
• GET_RES_TOKEN — Returns the resource token associated with an RBS resource, used as a key in mapping and event processing.
• GET_RES_TYPE_NUMERIC_ID — Retrieves the numeric identifier for a resource type without creating it.
• CREATE_MAPPING_RULES — Generates mapping rule rows that associate source resource attributes with RBS elements.
• GET_RESOURCE_TYPE_COLS — Returns the resource type column definitions used when constructing mapping SQL for the different RBS resource classes.
• GET_RES_TYPE_ID — Resolves the resource type identifier for a given resource type code.

These routines are internal helper APIs; they are not documented as supporting a formal parameter contract for external consumers.

Tables Accessed

The package reads and writes RBS configuration and transaction staging tables through APPS synonyms, including PA_RBS_ELEMENTS, PA_RBS_ELEMENTS_S, PA_RBS_HEADERS_B, PA_RBS_ELEMENT_MAP, PA_RBS_ELEMENT_MAP_S, PA_RBS_MAPPING_RULES, PA_RBS_MAPPING_RULE_S, and the temporary table PA_RBS_ELEM_IN_TEMP. Source-attribute table PA_RBS_MAP_T1 is used as the working structure for mapping rules.

Transaction and reference data includes PA_EXPENDITURE_CATEGORIES, PA_EXPENDITURE_TYPES, PA_EVENT_TYPES, PA_BUDGET_VERSIONS, PA_PJI_PROJ_EVENTS_LOG, and PA_PJT_EVENTS. Actual/commitment summarization and denormalization flows depend on the mapping results maintained in these tables.

Usage Notes

PA_RBS_MAPPING is invoked internally rather than from Oracle Forms or a standalone concurrent program. ETRM records eight referring packages: PA_PPR_CONCURRENT_PROGRAM, PA_RBS_ELEMENTS_UTILS, PA_RBS_UTILS, PA_RBS_VERSIONS_PUB, PA_RLMI_RBS_MAP_PUB, PJI_FM_PLAN_MAINT, PJI_PJP_SUM_DENORM, and PJI_PJP_SUM_ROLLUP. It also references itself for internal reuse and depends only on SYS.STANDARD. Custom code should call the public RBS utilities (for example PA_RBS_UTILS or PA_RBS_VERSIONS_PUB) instead of PA_RBS_MAPPING directly, since the documented procedures expose no supported external signature and Oracle may change them without notice.