User Not Authorized and ORA-01403 Logging into FDM Admin After OFSA Database Import

(Doc ID 744234.1)

Last updated on OCTOBER 31, 2008

Applies to:

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


After exporting an Oracle Financial Services Applications (OFSA) database from one server and importing it into another server, you receive errors when trying to login to the various OFSA modules.

When logging into Financial Data Manager (FDM) Administration, the following error occurs:

User not authorized 100,
ORA-01403; no data found
ORA-06512: at "<db owner>.OFSA_SECURE_ROLE", line 33
ORA-06512: at "<db owner>.OFSA_AUTHENTICATE", line 14

When logging into Balance & Control (BC), you receive the following error:

Invalid schema owner... please use a valid database.

Additionally, when trying to run the "grant_all" procedure, the following error occurs:

ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "<db owner>.OFSA_DBA", line 1089
ORA-06512: at "<db owner>.OFSA_DBA", line 7538
ORA-01403: no data found
ORA-06512: at line 1


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