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

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 ***

Symptoms

On : 12.1.3 version, Misc Issues

When attempting to create project from 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, 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.








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