FNDCPASS Oracle error -29548: ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.201020 1.6) does not match that of the oracle executable (12.1.0.2.220719 1.6) - USER ( APPS ) has been detected in FND_WEB_SEC.GET_OP_VALUE

 Changing apps password with FNDCPASS failed with below error.Working...

Oracle error -29548: ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.201020 1.6) does not match that of the oracle executable (12.1.0.2.220719 1.6) - USER ( APPS ) has been detected in FND_WEB_SEC.GET_OP_VALUE.

Fix

===

 sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 23 21:13:41 2022

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

INSTANCE_NAME> select dbms_java.get_jdk_version() from dual;

select dbms_java.get_jdk_version() from dual

                                        *

ERROR at line 1:

ORA-29548: Java system class reported: release of Java system classes in the

database (12.1.0.2.201020 1.6) does not match that of the oracle executable

(12.1.0.2.220719 1.6)

INSTANCE_NAME> spool javaissue.txt

INSTANCE_NAME> @?/javavm/install/update_javavm_db.sql

INSTANCE_NAME> SET FEEDBACK 1

INSTANCE_NAME> SET NUMWIDTH 10

INSTANCE_NAME> SET LINESIZE 80

INSTANCE_NAME> SET TRIMSPOOL ON

INSTANCE_NAME> SET TAB OFF

INSTANCE_NAME> SET PAGESIZE 100

INSTANCE_NAME>

INSTANCE_NAME> alter session set "_ORACLE_SCRIPT"=true;

Session altered.

INSTANCE_NAME>

INSTANCE_NAME> -- If Java is installed, do CJS.

INSTANCE_NAME>

INSTANCE_NAME> -- If CJS can deal with the SROs inconsistent with the new JDK,

INSTANCE_NAME> -- the drop_sros() call here can be removed.

INSTANCE_NAME> call initjvmaux.drop_sros();

Call completed.

INSTANCE_NAME>

INSTANCE_NAME> create or replace java system;

  2  /

Java created.

INSTANCE_NAME>

INSTANCE_NAME> update dependency$

  2    set p_timestamp=(select stime from obj$ where obj#=p_obj#)

  3    where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and

  4          (select type# from obj$ where obj#=p_obj#)=29  and

  5          (select owner# from obj$ where obj#=p_obj#)=0;

0 rows updated.

INSTANCE_NAME>

INSTANCE_NAME> commit;

Commit complete.

INSTANCE_NAME>

INSTANCE_NAME> alter session set "_ORACLE_SCRIPT"=false;

Session altered.

INSTANCE_NAME>

INSTANCE_NAME> select dbms_java.get_jdk_version() from dual;

DBMS_JAVA.GET_JDK_VERSION()

--------------------------------------------------------------------------------

1.6.0_211

1 row selected.

Thanks.