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

MOSC Banner

PLS-00754: illegal reference to editioned object APPS_APPFND.FND_ADG_COMPILE_DIRECTIVE

edited Aug 20, 2021 10:14AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 6 commentsAnswered

Our ebs environment 'APPS' user is 'APPS_APPFND'. 'APPLSYS' is 'APPFND'.

We did upgrade from 11.5.10.2 to R12.2.5, so far so good.

I ran 'adadmin' utility to compile 'APPS' schema, when exiting the utility, I encountered this error:

.

.

.

Drop FND_INSTALL_PROCESSES table [No] ? yes

AD Administration error:
The following ORACLE error:

ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 5, column 5:
PLS-00754: illegal reference to editioned object APPS_APPFND.FND_ADG_COMPILE_DIRECTIVE
ORA-06550: line 4, column 37:
PL/SQL: Statement ignored
ORA-06550: line 5, column 5:
PLS-00174: a static boolean expression must be used
ORA-01434: private synonym to be dropped does not exist

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