R12 Create Project Encounters Error: FND_AS_UNEXPECTED_ERROR
(Doc ID 1306353.1)
Last updated on JULY 08, 2020
Applies to:Oracle Project Foundation - Version 12.1.1 and later
Information in this document applies to any platform.
Creating a project from a project template the following error occurs.
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.
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