FA OTBI Odbc Driver Returned Error; ORA-20001: APPLCORE--20001: Invalid session 1 specified in attach to ORA-06512: at "FUSION.FND_SESSION_MGMT" (Doc ID 2462256.1)

Last updated on JUNE 28, 2022

Applies to:

Goal

Receiving Odbc driver returned error when running OTBI Reports


Error Details

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 20001, message: ORA-20001: APPLCORE--20001: Invalid session 1 specified in attach to ORA-06512: at "FUSION.FND_SESSION_MGMT", line 1047 ORA-06512: at "FUSION.FND_SESSION_MGMT", line 1103 ORA-06512: at line 1 at OCI call OCIStmtExecute: BEGIN fnd_session_mgmt.attach_session('1'); END;. (HY000)
State: HY000. Code: 17011. [nQSError: 17011] SQL statement execution failed. (HY000)
 

Solution

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