Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Wednesday, October 31, 2007

Drop invalid java classes after 11.5.10 upgrade

We got two invalid java classes after applying a few patches on top of a freshly upgraded 11.5.10.2 instance:

OBJECT_TYPE OBJECT_NAME
----------------------------------------------------
JAVA CLASS /ae799f28_DirectDepositConcurr
JAVA CLASS /e6bc455_DocumentGenerator

Metalink Note 301345.1 advises dropping them:

Symptoms

The following 2 java classes are invalid after an Oracle Applications 11.5.10 upgrade:
/e6bc455_DocumentGenerator
/ae799f28_DirectDepositConcurr

Cause

These are invalid because CP classes are not loaded into the database,
and concurrent programs that reference them should not be loaded either.

Fix

Drop the invalid java objects:
/e6bc455_DocumentGenerator, and
/ae799f28_DirectDepositConcurr

So issue the following commands and drop them:

SQL> drop java class apps."/ae799f28_DirectDepositConcurr";

Java dropped.

SQL> drop java class apps."/e6bc455_DocumentGenerator";

Java dropped.

1 comment:

BCNovice said...

SQL> drop java class apps."/d1e26e1_FileHelper"
2 ;
drop java class apps."/d1e26e1_FileHelper"
*
ERROR at line 1:
ORA-01031: insufficient privileges

what a priviledge a should have to delete java class in this context?