PRC: Update Project Performance Data Errors With ORA-20000: Index "PJI"."PJI_FM_EXTR_PLNVER4_N1"
(Doc ID 2811385.1)
Last updated on OCTOBER 01, 2021
Applies to:Oracle Project Planning and Control - Version 12.2.6 and later
Information in this document applies to any platform.
When running PJI_PJP_SUMMARIZE_INCR: PRC: Update Project Performance Data the following error is encountered:
ORA-20000: index "PJI"."PJI_FM_EXTR_PLNVER4_N1" or partition of such index is in unusable state
Steps to reproduce:
1. Using a Projects responsibility navigate to Other-->Requests -->Run
2. Select Name = PRC: Update Project Performance Data
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