ORA-29516:Assertion Failure at eox.c.232 Logging into OFSA Modules

(Doc ID 420871.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5.39 and later
Oracle Profitability Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39
Oracle Performance Analyzer - Version: 4.5.39

Symptoms

After installing Oracle daylight savings database Patch 5047902, users cannot log into Oracle Performance Analyzer (PA) or other OFSA modules. The following error occurs:

(203105) Oracle drv_oci error:
OCI Function: {12} - ofetch(), ofen()
SQL Function: {4} - SELECT
Oracle Error: ORA-29516: Aurora assertion failure: Assertion failure at eox.c.232
Uncaught exception Root of all Java exceptions:
java.lang.ExceptionInInitializerError
ORA-06512: at "ofsaowner.OFSA_SECURE_ROLE", line 14
ORA-06512: at "ofsaowner.OFSA_SECURE_ROLE", line 19
ORA-06512: at "ofsaowner.OFSA_AUTHENTICATE", line 4

Driver Function: drv_oct::FetchNext()
SQL Statement: select ofsa_authenticate.RequestRole from dual

Cause

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