Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE

Syed Saad October 10, 2017 Errors/Workarounds-Applications, Oracle APPS DBA Leave a comment 686 Views

ERROR

Oracle error – 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE
(USERNAME=SYSADMIN)
(ROLENAME=FND_RESP|FND|FND_FUNC_ADMINI|STANDARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has
been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

SOLUTION

This Issue exists in default R12 installation

Step 1. Run the concurrent program “Workflow Directory Services User/Role Validation” with parameters : 100000, Yes, Yes, No

Step 2. Bounce all services under oacore or bounce opmnctl .

Reference Oracle Note id : 454988.1

 

 

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleEBSerror

Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status

ERROR Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status /u01/app/applmgr/TST123/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lm …

Leave a Reply

Powered by OracleSolutions | Designed by
© Copyright 2025, https://oraclesolutions.pk All Rights Reserved