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

MOSC Banner

alter JAVA SOURCE APPS.Download_Files compile * ERROR at line 1: ORA-04043: object DOWNLOAD_FILES do

edited Aug 20, 2021 10:08AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

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);

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