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

Last updated on JULY 13, 2022

Applies to:

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

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