How to Define Custom Measure In Performance Reporting Using PJI_PJP_SUM_CUST (Doc ID 420909.1)

Last updated on NOVEMBER 18, 2022

Applies to:

Goal

Users are trying to define a stored custom measure to be used in performance reporting. The package PJI_PJP_SUM_CUST needs to be utilized.

Question #1

Comments in the package clearly state basis table PJI_FP_AGGR_PJP0 should be populated.  Is the fact that PJI_FP_AGGR_PJP0 is not populated going to prevent the users custom measure definition?

Question #2

Columns in PJI_FP_AGGR_PJP0/PJI_FP_XBS_ACCUM_F are not defined enough to know how to populate time_id and period_type_id. How can users find the definition to determine appropriate values?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.