My Oracle Support Banner

PRC: Update Project Performance Data fails with Planned Raw Cost Rate is not Defined for the Resource Assignment (Doc ID 1635802.1)

Last updated on JUNE 27, 2018

Applies to:

Oracle Project Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PJI_PJP_SUMMARIZE_INCR module: PRC: Update Project Performance Data fails with
ORA-01086: savepoint 'S_PROGRESS_ROLLUP' never established in this session or is invalid
+---------------------------------------------------------------------------+

: GET_SUMM_ACT: Error 1 =pa_progress_pub.get_summarized_actuals:ORA-22160: element at index [31] does not exist in Package PA_PROGRESS_PUB Procedure GET_SUMMARIZED_ACTUALS
: Begin GET_SUMM_ACT: p_extraction: INCREMENTAL p_res_level: Y
: GET_SUMM_ACT: Calling pji_fm_xbs_accum_utils.get_summarized_data


: GET_SUMM_ACT: Done insert/update of pa_progress_rollup.
: GET_SUMM_ACT: Error 1 =A required cost rate is missing.
: GET_SUMM_ACT: Error 2 =A required cost rate is missing.
: GET_SUMM_ACT: Error 3 =pa_progress_pub.get_summarized_actuals:ORA-22160: element at index [18] does not exist in Package PA_PROGRESS_PUB Procedure GET_SUMMARIZED_ACTUALS
: Begin GET_SUMM_ACT: p_extraction: INCREMENTAL p_res_level: Y


: GET_SUMM_ACT: Error 1 =pa_progress_pub.get_summarized_actuals:ORA-22160: element at index [55] does not exist in Package PA_PROGRESS_PUB Procedure GET_SUMMARIZED_ACTUALS


The planned amount is missing a raw cost. Actualls will not map to the Planned amounts if Planned amounts have missing Cost amounts. Task:192014
  , Res Assign Id:1717389 , Budget Ver Id:430518
  , Txn Curr:
EUR

Cause

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
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.