Search Results pji_pjp_sum_cust




Overview
Explore in AI Chat

Overview

PJI_PJP_SUM_CUST is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Projects (PJI) module and categorized in the ETRM repository as an API with the classification OTHER. Its name follows the naming convention used by the Project Portfolio Analysis and summarization components of Oracle Projects: the PJI prefix denotes Projects Intelligence/analysis objects, PJP identifies the summarization program family, and the CUST suffix indicates that the package is responsible for the customer-related dimension of that summarization process. In practice, the package exists to support the aggregation and maintenance of summarized project performance data at the customer level, feeding the pre-aggregated summary tables that Oracle Projects uses to drive project performance reporting, Project Status Inquiry, and related analytical inquiries. It operates in conjunction with the driving summarization package PJI_PJP_SUM_MAIN, which invokes its routines as part of the broader summarization cycle.

Key Procedures and Functions

The package exposes two documented program units.

  • PJP_CUSTOM_FPR_API — Handles the customer-level processing associated with FPR (financial project reporting) summarization. It is the entry point through which summarized customer performance figures are created or refreshed so that reporting inquiries can retrieve pre-computed data rather than querying transactional project and expenditure detail directly.
  • PJP_CUSTOM_ACR_API — Handles the customer-level processing associated with ACR (aggregate/cost-related) summarization. It maintains the aggregated customer summary records used for cost and commitment reporting.

Both routines act as internal APIs; parameter signatures are not documented in the ETRM metadata and are not reproduced here. They are designed to be called by the summarization driver rather than directly by end users.

Tables Accessed

The package operates against four documented summary tables, reached through APPS synonyms:

The package reads and writes rows in these tables to populate or refresh customer-scoped summary balances. The "PJP0" suffix identifies them as the base summary tables for the PJP summarization model.

Usage Notes

PJI_PJP_SUM_CUST is not intended for direct invocation by end users. It is referenced by the summarization coordinator package PJI_PJP_SUM_MAIN, which calls its customer summarization routines during the standard Oracle Projects summarization run. Typical invocation paths include the concurrent programs that execute project summarization and the Project Status Inquiry reporting flow, both of which rely on the summary tables the package maintains. Because the environment is 12.1.1 and 12.2.2, the package should be treated as an internal, non-public API: customizations should call the supported summarization entry points rather than invoking PJP_CUSTOM_FPR_API or PJP_CUSTOM_ACR_API directly. The TAPI/CAPI designation in the metadata is not documented, and no dependencies on other application packages beyond the APPS-owned summarization chain are recorded.