R12.2: PJI_PA_PROJ_EVENTS_LOG_N1 Index Goes Into Unusable State Frequently

(Doc ID 2408719.1)

Last updated on JUNE 07, 2018

Applies to:

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

Symptoms

On 12.2.6:


PJI_PA_PROJ_EVENTS_LOG_N1 index is going into Unusable state frequently.

Followed the steps below:
-----------------------------
1. Ran the "Gather Table Statistics" process for table PJI_PA_PROJ_EVENTS_LOG
with "Granularity" option as 'DEFAULT'. The process completed successfully.

2. Rebuilt the index. Index status was back as Valid.
But it goes back to Unusable status after sometimes.

 

WORKAROUNDS
===========
Rebuild the index every time.

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