Thursday, August 12, 2010

ORA-20001:FND_CANT_INSERT_USER_ROLE when attaching responsibility to User

Yesterday we had a issue with one user saying after he logs into applications no responsibility displayed.When we did a search for that user on the forms ,surprisingly
there was no responsibilities attached to that user.

We tried to attach responsibility and save it ,but it will not save and came back with the below message

"ORA-20001:FND_CANT_INSERT_USER_ROLE has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT"

Later we ran concurrent program "Workflow Directory Services User/Role Validation" .Request completed normal and this time the responsibility was visible on the forms when we queried that user.But when the user tried to login no responsibilities still.

We fixed this issue by end-dating the responsibility assigned to the user and saved.Then removed the end date for the responsibility and saved.

Now requested the user to test and he can see the responsibility now and work without any issues.

RMAN-05001: auxiliary filename /u01/oracle/oradata/wipd06.dbf conflicts with a file used by the target database

When performing duplication using RMAN I recieved the following message and duplication came out with errors.
On researching found that the values for parameters 'db_file_name_convert' and 'log_file_name_convert' was not set correctly.

The reasons being last time when duplication was performed the DBA used a different Database as source and the values for 'db_file_name_convert' and 'log_file_name_convert' were still pointing to the previous source database mount points.

So this time without checking or modifying the values the DBA started the duplication and received the above error message.

To fix it

Stop the database,change the values for 'db_file_name_convert' and 'log_file_name_convert' to the correct source Database values and then restart the duplication.