Search Results rollup_fpr_rbs_top

Overview

APPS.PJI_PJP_GEN_PERF_ALL is an Oracle EBS project performance aggregation package associated with the ETRM (Enterprise Project and Portfolio Management) product family. In EBS 12.1.1 and 12.2.2 it serves as the generation and rollup engine for project performance data, extracting plan, estimate-to-complete (ETC), and actual transaction information, then aggregating and rolling it up across the project resource breakdown structure (RBS), work breakdown structure (WBS), and financial plan hierarchies. The package header (§120.0, dated 28-Mar-2011) declares AUTHID CURRENT_USER, meaning procedures execute with the privileges of the invoker rather than the package owner — a relevant detail for security and grants in customized environments. Its naming convention (PJI_PJP) ties it to the Project Intelligence (PJI) schema and the Project Performance (PJP) processing infrastructure used for financial plan rollups.

Key Procedures and Functions

The ETRM metadata documents eight callable units:

• GET_PARAMETER — a function that returns a configuration parameter value by name, used internally to drive extraction and rollup behavior.
• EXTRACT_PLAN_ETC_PRIRBS — extracts plan and ETC data at the primary RBS slice level, scoped by a maximum project ID and a slice type defaulting to 'PRI'.
• ROLLUP_FPR_RBS_T_SLICE — performs rollup of financial plan resource (FPR) RBS transaction slice data.
• EXTRACT_ACTUALS — extracts actual cost/quantity transactions for processing, optionally filtered by external type.
• PROCESS_PENDING_PLAN_UPDATES — processes queued plan updates, optionally constrained by a maximum project ID, external type, and an ETC extraction flag.
• AGGREGATE_FP_SLICES — aggregates financial plan slices by worker, extraction type, and multiple currency flags/codes (transaction currency, group-1, group-2), supporting multi-currency reporting.
• ROLLUP_FPR_RBS_TOP — the top-level rollup of FPR RBS data (the object behind the search term "rollup_fpr_rbs_top"), taking a worker ID to identify the processing run.
• EXECUTE_ROLLUP_FPR_WBS — orchestrates the WBS-level rollup, accepting optional worker ID and level, plus partial-mode and FPM-upgrade indicators.

Tables Accessed

The package reads and writes across project and PJI staging tables via APPS synonyms. Source-side tables include PA_PROJECTS_ALL, PA_BUDGET_LINES, PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_CLASSES_B, and the RBS/WBS structure tables PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEM_VER_STRUCTURE, PA_PROJ_WORKPLAN_ATTR, and PA_XBS_DENORM, plus PA_RBS_TXN_ACCUM_MAP for transaction-to-RBS mapping. Work/target tables include PJI_FM_EXTR_PLAN_LINES and PJI_FM_EXTR_PLNVER4 (extracted plan lines and plan versions), PJI_FP_TXN_ACCUM (transaction accumulation), PJI_FP_AGGR_PJP0 and PJI_FP_AGGR_PJP1 (aggregated results), and PJI_FM_AGGR_FIN7. These support the extract-to-aggregate-to-rollup pipeline.

Usage Notes

This is a backend engine package, not an end-user API. It is typically invoked by ETRM concurrent programs, by the financial plan rollup scheduler, and by two other dependent packages (per the metadata). It is not intended for direct form calls. Custom code should invoke the orchestration procedures (EXECUTE_ROLLUP_FPR_WBS, AGGREGATE_FP_SLICES) in the documented sequence after extraction, supplying valid worker IDs, and should account for the AUTHID CURRENT_USER behavior and multi-currency parameters when integrating.