Search Results pji_rep_ra1_tbl

Overview

APPS.PJI_PMV_AVL is a valid PL/SQL package body owned by the APPS schema within Oracle EBS 12.1.1 and 12.2.2. It belongs to the Oracle Projects Intelligence (PJI) product family, the analytic and reporting layer delivered on top of Oracle Projects. The package name reflects its role: "PMV" refers to the Performance Management Viewer (PMV) framework shared with BIS (Business Intelligence System) constructs, while "AVL" denotes availability — that is, the resource and organizational availability analytics used in project performance dashboards and reports.

Functionally, PJI_PMV_AVL supports reporting on project resource availability against demand. It assembles data for the six packaged report definitions PJI_REP_RA1 through PJI_REP_RA5 and their associated table types (PJI_REP_RA1_TBL through PJI_REP_RA5_TBL). The user search term "pji_rep_ra1_tbl" reflects a direct downstream dependency: PJI_REP_RA1_TBL is one of the record collections this package uses to stage or return report result sets. The package works alongside PJI_PMV_ENGINE, PJI_PMV_UTIL, and PJI_PMV_AVL, which together form the PMV execution and dimension-loading infrastructure.

Key Procedures and Functions

The ETRM metadata records no explicitly documented public procedures or functions for this package body, so individual routine signatures are not itemized in the reference material. Based on the dependency graph and the package's role as an "availability" engine, the body is understood to contain internal routines that populate the RA1–RA5 report collections, transform denormalized resource and organization snapshots into report-ready structures, and invoke the shared PMV engine for page parameter handling and query attribute resolution. The package is classified as OTHER, indicating it is not a published integration API but an internal engine consumed by the PMV reporting framework and its parent packages.

Tables Accessed

The dependency list shows that PJI_PMV_AVL reads from a broad set of Projects and internal PMV objects:

• PA_PROJECTS_ALL, PA_IMPLEMENTATIONS_ALL, and PA_RESOURCES_DENORM supply project definitions, implementation business-group context, and denormalized resource attributes.
• PJI_AV_ORGO_F_MV, PJI_CA_ORGO_F_MV, and PJI_RM_ORGO_F_MV are organizational fact materialized views providing availability and resource-management facts.
• PJI_RM_RES_F and PJI_RM_RES_WT_F supply resource fact and weighted resource fact measures.
• PJI_AVL_THRESHOLDS_V provides configurable availability thresholds that influence report exception logic.
• PJI_MT_BUCKETS, PJI_PMV_TIME_DIM_TMP, PJI_PMV_ORG_DIM_TMP, and PJI_PMV_ORGZ_DIM_TMP are time, organization, and organization-hierarchy dimension staging tables used to build the query axes.
• BIS_PMV_PAGE_PARAMETER_TBL, BIS_QUERY_ATTRIBUTES_TBL, and FII_TIME_WEEK are BIS/FII framework tables for PMV page parameters, query metadata, and weekly time bucketing.
• PJI_REP_RA1 through PJI_REP_RA5 and their _TBL collection types carry the staged report outputs, including the referenced PJI_REP_RA1_TBL.
• PJI_SYSTEM_SETTINGS controls package behavior, while PLITBLM, STANDARD, and SYS provide standard PL/SQL and utility support.

Usage Notes

PJI_PMV_AVL is invoked indirectly rather than as a standalone API. It is typically executed through the Oracle Projects Intelligence PMV dashboards and the concurrent programs and page flows that render the RA1–RA5 availability reports, using the PJI_PMV_ENGINE and PJI_PMV_UTIL packages as the surrounding execution framework. Because no other database object references it, it is a terminal, leaf-level implementation package; customizations should therefore avoid direct calls and instead rely on the supported PMV report pages and their parameters. In 12.1.1 and 12.2.2 the package behavior is governed by PJI_SYSTEM_SETTINGS and by the materialized views it queries, so any tuning of availability thresholds or MV refresh strategy directly affects report output.