Search Results balances_rowid_table

Overview

APPS.PJI_FM_SUM_PSI is a PL/SQL package in the Oracle E-Business Suite Applications schema that supports the Project Intelligence (PJI) summarization and aggregation engine. Its primary business function is to maintain, populate, and purge the summary balance tables that store pre-aggregated financial and commitment data used by Project Management and Project Intelligence reporting. The package name suffix "PSI" aligns with the Projects Summary Incremental processing family, distinguishing it from full-refresh extractions such as those performed by PJI_FM_SUM_EXTR.

In the EBS 12.1.1 and 12.2.2 releases, PJI_FM_SUM_PSI is documented with an API classification of OTHER and is catalogued as a VALID object owned by APPS. It operates as a dependent of the SYS.STANDARD package and is itself referenced by APPS.PJI_FM_SUM_EXTR, by its own internal subprograms, and by PJI_PJP_SUM_MAIN. This dependency pattern confirms that PJI_FM_SUM_PSI is a lower-level worker package invoked by the main summarization driver to perform balance insertion, delta updates, and purge operations.

Key Procedures and Functions

The ETRM metadata documents 21 procedures and functions within the package. No parameter lists are published, so the following describes purpose only, grouped by functional area:

• Setup and lookup: RESOURCE_LOOKUP_TABLE establishes the resource mapping structures used to resolve resources, categories, and person types during aggregation.
• Period aggregation: AGGREGATE_FPR_PERIODS and AGGREGATE_ACR_PERIODS drive aggregation of financial plan and actual/commitment resource data across accounting periods. FORCE_SUBSEQUENT_RUN supports re-triggering of dependent aggregation runs.
• Header management: INSERT_NEW_HEADERS creates new summary header rows for periods and project combinations that do not yet exist.
• Balance loading (full): BALANCES_INSERT, BALANCES_INSERT_CMT, BALANCES_INCR_NEW_PRJ, and BALANCES_INCR_NEW_PRJ_CMT handle insertion of new project balances and their commitment counterparts, including incremental handling for newly created projects.
• Balance maintenance (delta): BALANCES_UPDATE_DELTA, BALANCES_INSERT_DELTA, and BALANCES_INSERT_DELTA_CMT apply delta-based updates and inserts to keep summary tables current without full rebuilds.
• Purge operations: PURGE_FP_BALANCES, PURGE_CMT_BALANCES, PURGE_AC_BALANCES, PURGE_INCREMENTAL_BALANCES, PURGE_BALANCES_CMT, and PURGE_BALANCES_ACT remove stale or historical balance rows to control table growth.
• Rowid staging: BALANCES_ROWID_TABLE and ACT_ROWID_TABLE provide in-memory collections of ROWIDs to support efficient bulk operations.

Tables Accessed

PJI_FM_SUM_PSI reads reference and setup data from BOM_RESOURCES, PA_NON_LABOR_RESOURCES, PA_RESOURCE_CLASSES_B, and PA_PLAN_RES_DEFAULTS to resolve resource definitions, and from MTL_ITEM_CATEGORIES and PA_EXPENDITURE_CATEGORIES for category mapping. PA_IMPLEMENTATIONS_ALL, PA_PERIODS_ALL, GL_PERIODS, and PA_TIME_CAL_NAME supply implementation parameters, period definitions, and calendar information. PA_PROJECT_ASSIGNMENTS, PER_PERSON_TYPES, and PER_PERSON_TYPE_USAGES_F provide project staffing and person type context. The primary write targets are the summary aggregate tables PJI_FM_AGGR_ACT2 and PJI_FM_AGGR_ACT4, which store the aggregated actual and commitment balances produced by the insertion, delta, and aggregation routines.

Usage Notes

PJI_FM_SUM_PSI is an internal engine package and is not exposed through Oracle Forms or standalone concurrent programs directly. It is invoked programmatically by PJI_FM_SUM_EXTR and PJI_PJP_SUM_MAIN as part of the Project Intelligence summarization and incremental refresh cycle. Because its subprograms manipulate summary balance tables directly, customizations should avoid calling its procedures outside the supported summarization framework; doing so can bypass concurrency and purge logic coordinated by the calling drivers. It is valid across both EBS 12.1.1 and 12.2.2, and revisiting the package after patching remains advisable, as the summarizing engine is periodically updated.