ORA-06508 & ORA-02291 Errors Registering a New User in FDM Admin
Last updated on JUNE 30, 2010
Applies to:Oracle Financial Data Manager - Version: 4.5
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Checked for relevance on 30-Jun-2010.
In the 4.5 Oracle Financial Data Manager Administration application, when you try to register a new user, you receive the following errors after clicking on "Finish":
ORA-06508: PL/SQL: could not find program unit being called
ORA-02291: integrity constraint (.) violated - parent key not found
As a result, the user cannot be registered using the application.
If you try to run the "ofsa_app_utils.register_user" procedure directly in SQL*Plus, the procedure only outputs the ORA-6508 error message and does not register the user.
SQL> set serveroutput on
SQL> variable v_error_num number
SQL> exec ofsa_app_utils.register_user('USER','User','Name', :v_error_num);
PL/SQL procedure successfully completed.
SQL> exec dbms_output.put_line(:v_error_num);
Steps To Reproduce:
- Log into Financial Data Manager Administration
- Go to Wizards > Register > User...
- Enter the user information and click Next
- Select a User Group and click Next
- Click Finish on the "Congratulations" screen
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