My Oracle Support Banner

R12 Create Project Encounters Error: FND_AS_UNEXPECTED_ERROR (Doc ID 1306353.1)

Last updated on JUNE 20, 2019

Applies to:

Oracle Project Foundation - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Creating a project from a project template the following error occurs.


ERROR
-----------------------
FND_AS_UNEXPECTED_ERROR

There  are no INVALID objects.

Enabling SQL_TRACE on the query shows, the recursive statement being executed many times.

select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#,
sample_size, minimum, maximum, distcnt, lowval, hival, density, col#,
spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2


If the global statistics on a partitioned table are not gathered, Cost Based Optimizer (CBO) will issue the above query for each column and for each partition.

Running Concurrent Manager program Gather Schema Statistic shows the following errors in the log.
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=PJI.PJI_PA_PROJ_EVENTS_LOG***ORA-20000: index "PJI"."PJI_PA_PROJ_EVENTS_LOG_N1" or partition of such index is in unusable state.

This issue may manifest in other places than described here.  Hence if looking in a log file one finds the above message then some users may be having problems related to the place where index is used.









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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.