PLS-00754: illegal reference to editioned object APPS_APPFND.FND_ADG_COMPILE_DIRECTIVE
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