My Oracle Support Banner

R12: ORA-959 Error Occured During PA_SEARCH_RESULTS_TEMP_U3 Index Creation When Applying A Patch (Doc ID 2517027.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Project Resource Management - Version 12.2.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1 version

ERROR
-----------------------
Applying XDF file : $PA_TOP/patch/115/xdf/pa_search_results_temp.xdf
================================================================================


Table Name is PA_SEARCH_RESULTS_TEMP
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 30
The table definition in the XDF is the same as the one in DB.

Executing grants on PA_SEARCH_RESULTS_TEMP to APPS
GRANT ALL ON PA.PA_SEARCH_RESULTS_TEMP TO APPS WITH GRANT OPTION
Synonyms match.

Index hashcode(s) extracted from the XDF.

Hashcodes generated for DB indexes.

Index PA_SEARCH_RESULTS_TEMP_U1 exists under PA schema.
Checking for differences

Column_name and Uniqueness match for both file and DB Indexes
Index PA_SEARCH_RESULTS_TEMP_U2 exists under PA schema.
Checking for differences

Column_name and Uniqueness match for both file and DB Indexes
Index PA_SEARCH_RESULTS_TEMP_U3 does not exist in PA.

CREATE UNIQUE INDEX "PA"."PA_SEARCH_RESULTS_TEMP_U3" ON "PA"."PA_SEARCH_RESULTS_TEMP" ("RESOURCE_ID")
Start time for statement above is Wed Mar 06 15:28:59 GMT 2019
ORA-959 error occured during Index creation.

==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Wed Mar 06 15:28:59 GMT 2019]
Updating task with status 1
 

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


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