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

Last updated on AUGUST 03, 2016

Applies to:

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

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms