PRC: Launch Update Project Performance Data ORA-04020 ORA-08104 PJI.PJI_FP_AGGR_PJP1_N2 PJI.PJI_FP_AGGR_PJP1 (Doc ID 1939386.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

Run PRC: Launch Update Project Performance Data process.

Spawns off 21 batches of PRC: Update Project Performance Data

PJI_SYSTEM_CONFIG_HIST shows COMPLETION_TEXT = 'Normal completion'.

However, when you look at the individual log files, 4 are showing the
following errors (1 Each log file):

ORA-04020: deadlock detected while trying to lock object
PJI.PJI_FP_AGGR_PJP1_N2

ORA-08104: this index object 1337698 is being online built or rebuilt

ORA-04020: deadlock detected while trying to lock object PJI.PJI_FP_AGGR_PJP1

ORA-08104: this index object 1337698 is being online built or rebuilt

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