R12 Create Project Encounters Error: FND_AS_UNEXPECTED_ERROR
Last updated on JANUARY 02, 2017
Applies to:Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance 09-Feb-2015 ***
On : 12.1.3 version, Misc Issues
When attempting to create project from 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, CBO will issue the above query for each column and for each partition.
Running Concrrent 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 the way described here, hence if looking in a log file one finds above message then some users may be having problems related to the place where index is used.
In some performance issues someone may find the sql being run and then also the solution will be same.
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