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

MOSC Banner

patch :6678700:Upgrade to 12.1 failing with error

edited Jul 1, 2012 7:13PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓
Hi,
When applying the patch :6678700, the following error occurred.
AutoPatch error:
Error while executing statement

AutoPatch error:
ORA-04063: package body "APPS.FND_STATS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_STATS"
ORA-06512: at "APPS.AD_STATS_UTIL_PKG", line 116
ORA-06512: at "APPS.AD_STATS_UTIL_PKG", line 207
ORA-06512: at line 5

Error calling adphistGatherStatsIfNecessary(TASK_TIMING, 37481)
AutoPatch error:
aimini(): Error calling adptaskStoreTimInfoToHist()

SQL> alter package FND_STATS compile body;

Warning: Package Body altered with compilation errors.

SQL> sho error
Errors for PACKAGE BODY FND_STATS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
865/4    PL/SQL: Item ignored
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