Adding Assets With WebADI Errors With "Unable to Authenticate Session" and ORA-20001 and ORA-6512 (Doc ID 786753.1)

Last updated on NOVEMBER 23, 2022

Applies to:

Symptoms

When uploading assets using a Web ADI Excel spreadsheet template, an error occurs in the browser after the selection of the responsibility.  

Oracle error 20001: java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: APP-FND-02500: Error occurred during product 

initialization for OFA when executing &#39: begin FA_GLOBAL.INIT&#59; end&#59,'. SQLCODE = -4061 SQLERROR = ORA-04061: existing state
of has been invalidated ORA-04061: existing state of package &#34:APPS.FA_CACHE_PKG" has been invalidated ORA-04065: not executed, altered or
dropped package "APPS.FA_CACHE_PKG" ORA-06508: PL/SQL: could not find program unit being called;
"APPS.FA_CACHE_PKG" has been detected in FND_GLOBAL.INITIALIZE. ORA-06512: at " APPS.APP_EXCEPTION",line 72
ORA-06512: at "APPS.FND_GLOBAL",line 101 ORA--6512: at "APPS.FND_GLOBAL",line 1147 ORA-06512: at
"APPS.FND_SESSION_MANAGEMENT",LINE 811 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT",line 1114 ORA-
06512: at &#34;APPS.FND_AOLJ_UTIL&#34;,line 415 ORA-06512: at line 1 has been detected in FND_AOLJ_UTIL.is_Valid_ICX. </PRE> Unable to
authenticate session.

Changes

<Patch 4966058> was applied.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.