PRC: Launch Update Project Performance Data Completes with PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception. (Doc ID 2203527.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

The customer is running the PRC: Launch Update Project Performance Data process (LUPPD). One of the PRC: Update Project Performance Data processes (UPPD) spawned by the Launch process errors with a legitimate error (project
number 101095). Other projects summarized with project 101095 give the following generic error after the initial error is reported (i.e., project number 100400):

PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception.

The output appears as:

Summarization Exceptions Report
------------------------------------------------------------------------------
--

The following projects may have incorrect actual amounts on Workplan pages. For accurate actual amounts, please correct the exceptions and resubmit the PRC: Update Project Performance Data process.

Project Number Exception Reason
===================== =================
100400 PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS:User-Defined Exception
100484 PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS:User-Defined Exception
101095 The planned raw cost rate is not defined for the resource assignment <Workplan/Budget version name - WORKPLAN>; ; ; .
Please enter the planned raw cost rate for the resource assignment to map the actual amount to the planned amount.

When the UPPD process is run for the project reporting this generic error (project number 100400) outside of the Launch process, the UPPD appears to complete successfully, but the following is seen in the log file:

: GET_SUMM_ACT: Before inserting records in PA_PROG_ACT_BY_PERIOD_TEMP.Record Count = 8
: DELETE_FIN8: p_project_id386273p_err_flag1p_err_msg The planned raw cost rate is not defined for the resource assignment <Workplan/Budget version name - WORKPLAN>; ; ;
. Please enter the planned raw cost rate for the resource assignment to map the actual amount to the planned amount.
: DELETE_FIN8: p_project_id389274p_err_flag1p_err_msg
PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception
: DELETE_FIN8: p_project_id177273p_err_flag1p_err_msg
PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception
: DELETE_FIN8: p_project_id235273p_err_flag1p_err_msg
PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception
: DELETE_FIN8: p_project_id399273p_err_flag1p_err_msg
PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception
: DELETE_FIN8: p_project_id403274p_err_flag1p_err_msg
PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception
: DELETE_FIN8: p_project_id405276p_err_flag1p_err_msg
PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception
: DELETE_FIN8: p_project_id448274p_err_flag1p_err_msg
PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception
: DELETE_FIN8: p_project_id450273p_err_flag1p_err_msg
PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception
: DELETE_FIN8: p_project_id451280p_err_flag1p_err_msg
PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: User-Defined Exception
: GET_SUMM_ACT: Done with Get_Summarized_Actuals.

The customer indicates that the projects that give the generic error changes with each run.

Cause

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