Adding Assets With WebADI Errors With "Unable to Authenticate Session" and ORA-20001 and ORA-6512

(Doc ID 786753.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Web Applications Desktop Integrator - Version to [Release 11.5]
Information in this document applies to any platform.


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
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.



<Patch 4966058> was applied.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms