Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12 upgrade - adworker fails with error ORA-20000: Unable to analyze INDEX "EGO"."EGO_MTL_SY_ITEMS_E

edited May 14, 2013 11:52PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 10 commentsAnswered
Hi

Getting below error when adworker tries to run EGOEXTCONC.sql

ERROR at line 1:
ORA-20000: Unable to analyze INDEX "EGO"."EGO_MTL_SY_ITEMS_EXT_B_U1",
insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 18341
ORA-06512: at "SYS.DBMS_STATS", line 18402
ORA-06512: at line 1
ORA-06512: at "APPS.FND_STATS", line 711
ORA-06512: at "APPS.FND_STATS", line 1836
ORA-06512: at line 91

I have checked that the index "EGO"."EGO_MTL_SY_ITEMS_EXT_B_U1" does not exist.

Please let me know how to proceed further without skipping this adworker because the script EGOEXTCONC.sql must complete sucessfully.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center