Search Results seed_pji_rm_stats




Overview
Explore in AI Chat

Overview

APPS.PJI_PJI_EXTRACTION_UTILS is a PL/SQL utility package within the Oracle EBS Project Intelligence (PJI) application family. Its header declares AUTHID CURRENT_USER, meaning procedure bodies execute with the privileges of the invoking schema rather than the definer, which is consistent with an internal utility intended to be driven by administrative or concurrent-processing sessions that already hold the requisite APPS-level grants. The package's $Header annotation (PJIUT07S.pls, version 120.1, dated 2011/07/08) identifies it as a shipping Oracle file maintained across the 12.1.1 and 12.2.2 releases without structural change. Functionally, the package orchestrates the extraction layer that feeds Project Intelligence analytics: it seeds and refreshes extraction scope, populates and updates organization-level extraction information, maintains resource-management work-type and hierarchy data, gathers optimizer statistics on PJI fact tables, and provides a controlled truncation routine for PJI staging tables. It is registered in ETRM with an API classification of OTHER, indicating it is an internal implementation utility rather than a published, externally supported integration API.

Key Procedures and Functions

  • UPDATE_PJI_EXTR_SCOPE — Refreshes the set of projects and related entities eligible for PJI extraction.
  • POPULATE_ORG_EXTR_INFO — Inserts organization-level extraction information used to drive downstream extraction processing.
  • UPDATE_ORG_EXTR_INFO — Maintains and updates previously populated organization extraction records.
  • ANALYZE_PJI_FACTS — Computes optimizer statistics on the PJI fact tables to sustain query performance in Project Intelligence reporting.
  • SEED_PJI_RM_STATS — Seeds baseline resource-management statistics required by PJI resource analysis.
  • UPDATE_PJI_RM_WORK_TYPE_INFO(p_process) — Updates resource-management work-type information for the process identified by the supplied parameter.
  • UPDATE_PJI_ORG_HRCHY — Maintains the organization hierarchy used to roll up PJI extraction and reporting data.
  • UPDATE_RESOURCE_DATA(p_process) — Refreshes resource data for the specified process.
  • TRUNCATE_PJI_TABLES(errbuf, retcode, p_check) — Truncates PJI staging tables; the standard concurrent-program error-buffer signature and the p_check flag (default 'N') allow the caller to request a validation pass before destructive action.
  • MVIEW_REFRESH — Declared in a commented block and therefore not part of the active interface.

Tables Accessed

The package reads FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES to resolve site-level profile settings that govern extraction behavior, and PJI_SYSTEM_PARAMETERS, PJI_SYSTEM_SETTINGS, and PJI_SYSTEM_CONFIG_HIST for PJI configuration and its history. Extraction control metadata is held in PJI_MT_PRC_STEPS and retained in PA_PJI_PROJ_EVENTS_LOG. Resource-management enrichment uses PA_WORK_TYPES_B and PJI_RM_WORK_TYPE_INFO. DUAL supports singleton computations, while V$PARAMETER is queried to inspect database initialization parameters. All references resolve through APPS synonyms.

Usage Notes

ETRM records no dependent packages, confirming that PJI_PJI_EXTRACTION_UTILS is an entry-point utility rather than a library consumed by other PL/SQL units. It is normally invoked from PJI concurrent programs and administrative processing flows during extraction setup, periodic refresh, and statistics maintenance, with TRUNCATE_PJI_TABLES driven in the standard concurrent-program pattern using errbuf and retcode. Direct customer calls are discouraged because the package is an internal, unsupported interface; changes to its logic or to the PJI staging tables may accompany patching or upgrades.