alter JAVA SOURCE APPS.Download_Files compile * ERROR at line 1: ORA-04043: object DOWNLOAD_FILES do
On upgrading EBS to 11.5.10.2 and RDBMS to 11.2.0.4 invalids increased. Followed the note 1325394.1 to troubleshoot the invalids. Some of them compiled and some we can ignore but there are two object which on compilation below showing error.
SQL> alter JAVA SOURCE APPS.Download_Files compile;
alter JAVA SOURCE APPS.Download_Files compile
*
ERROR at line 1:
ORA-04043: object DOWNLOAD_FILES does not exist
SQL> alter java class APPS.Download_Files resolve;
alter java class APPS.Download_Files resolve
*
ERROR at line 1:
ORA-04043: object DOWNLOAD_FILES does not exist
Below is the Release information of a Java Class stored in the Database:
SQL> exec dbms_java.set_output(200000);