My Oracle Support Banner

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:

Oracle Project Planning and Control - Version and later
Information in this document applies to any platform.


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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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