Cannot Log into FDM Admin After 4.5.2 Upgrade - ORA-01403: No Data Found (Doc ID 373666.1)

Last updated on AUGUST 02, 2006

Applies to:

Oracle Financial Services Applications (OFSA) 4.5.2
Oracle Financial Data Manager - Version: 4.5.2
This problem can occur on any platform.

Symptoms

After upgrading from OFSA 4.0 to OFSA 4.5.2, when you try to log into Financial Data Manager Administration as the OFSA database owner, you receive the following errors:

User not authorized 100, ORA-01403: no data found ORA-06512: at
"OFSA_OWNER.OFSA_SECURE_ROLE", line 33 ORA-06512: at
"OFSA_OWNER.OFSA_AUTHENTICATE", line 14

You have an Oracle 9i database.

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