Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/06/adding-responsibility-to-sysadmin-user.html

Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE

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

ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/06/processorexception-unable-to-determine.html

ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST 

ERROR

Outpost Processot has encoutered the below error.

This error can be found in OPP logs:
—————————————-
[GC 14000K->8604K(32459K), 0.0068459 secs]
ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST
at oracle.apps.fnd.cp.opp.EmailDeliveryProcessor.deliver(EmailDeliveryProcessor.java:66)
at oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:91)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
—————————————-

SOLUTION

Step 1. Log into System Administrator responsibility.

Step 2. Navigate to Profile > System.

Step 3. Query up the %smtp% profiles.

Step 4. Set the following profile values to the defined host and port:

FND:smtp Host

FND:smtp Port

Responsibility (Menu & Functions) LEVEL-1 - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/06/responsibility-menu-functions.html

Responsibility (Menu & Functions) LEVEL-1

SELECT   distinct a.RESPONSIBILITY_NAME, menu.DESCRIPTION MENU_DESCRIPTION,
/*LPAD(' ', 6*((LEVEL-1))) ||*/ menu_entry.entry_sequence "SEQUENCE (LEVEL-1)"
,menu_entry.PROMPT "PROMPT (LEVEL-1)"
, /*LPAD(' ', 6*((LEVEL-1))) ||*/ menu.user_menu_name "SUBMENU DESCRIPTION (LEVEL-1)"
,/* LPAD(' ', 6*((LEVEL-1))) ||*/ func.user_function_name "FUNCTION DESCRIPTION (LEVEL-1)"
,menu_entry.DESCRIPTION "DESCRIPTION (LEVEL-1)"
, menu.menu_id
, func.function_id
, menu_entry.grant_flag Grant_Flag
, DECODE( menu_entry.sub_menu_id
, null, 'FUNCTION'
, DECODE( menu_entry.function_id
, null, 'SUBMENU'
, 'BOTH')
) Type
FROM FND_MENU_ENTRIES_VL menu_entry,
fnd_menus_tl menu,--FND_USER_RESP_GROUPS_DIRECT c,
fnd_form_functions_tl func , Fnd_Responsibility_Vl a
WHERE menu_entry.sub_menu_id = menu.menu_id(+)
AND menu_entry.function_id = func.function_id(+)
and a.MENU_ID =  menu_entry.MENU_ID
--and c.RESPONSIBILITY_ID(+)=a.RESPONSIBILITY_ID
--and a.RESPONSIBILITY_NAME =  'AP ADMINISTRATOR'
AND grant_flag = 'Y'
--and LPAD(' ', 6*((LEVEL-1))) || menu_entry.entry_sequence = 5

CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id
ORDER SIBLINGS BY menu_entry.entry_sequence