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

ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/02/ora-08004-sequence-fndconcurrentprocess.html

ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE

ERROR

Routine AFPGCP cannot create a process ID for your concurrent manager process ORACLE error 8004 in FDUUID
Cause: FDUUID failed due to ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated.
TheCall to establish_icm failed
The Internal Concurrent Manager has encountered an error.

SOLUTION

The max value for the sequence FND_CONCURRENT_PROCESSES_S has been reached and we need to increase the max value.

For Checking Run the below query



SQL> select FND_CONCURRENT_PROCESSES_S.nextval from dual;

select FND_CONCURRENT_PROCESSES_S.nextval from dual
*
ERROR at line 1:
ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and
cannot be instantiated



Increase max value Of APPLSYS.FND_CONCURRENT_PROCESSES_S

SQL> ALTER SEQUENCE APPLSYS.FND_CONCURRENT_PROCESSES_S MAXVALUE 99999999;

Sequence altered.

How to check online FND_USERS - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2017/08/how-to-check-online-fndusers-in-oracle.html

How to check online FND_USERS

SELECT DISTINCT icx.session_id, icx.user_id, fu.user_name, fu.description
FROM icx_sessions icx, fnd_user fu
WHERE disabled_flag != ‘Y’
AND icx.pseudo_flag = ‘N’
AND ( last_connect
+ DECODE (fnd_profile.VALUE (‘ICX_SESSION_TIMEOUT’),
NULL, limit_time,
0, limit_time,
fnd_profile.VALUE (‘ICX_SESSION_TIMEOUT’) / 60
)
/ 24
) > SYSDATE
AND icx.counter < limit_connects
AND icx.user_id = fu.user_id

How to make your USER and SYSADMIN to view all Concurrent Requests. Other Users can see only their Requests - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2017/07/how-to-make-your-user-and-sysadmin-to.html

How to make your USER and SYSADMIN to view all Concurrent Requests. Other Users can see only their Requests

Suggested you enable those standard grants for fnd_concurrent_requests and create a new role and then assign to your USER and SYSADMIN. Please check below steps for details.


Using the Functional Developer Responsibility, type Code as "FND_CONCURRENT_REQUESTS"

1. End_dating the following grants

DEFAULT_ACCESS_VIEWREQ
ECO Implementation Concurrent Request Grant
XDO Concurrent Request Security
IPM System Administration Concurrent Requests Grant

2. Create a new roles and assign to your USER and SYSADMIN

1. As SYSADMIN user with “Functional Developer” responsibility, update object "Concurrent Requests".

Search for object Concurrent Requests.
Click on Concurrent Requests.
Click on Object Instance Sets tab.
Click on Create Instance Set button.
Enter Name, Code and Description for new instance set.
- Enter the following for predicate:
1=1


2.As the SYSADMIN user with “User Management”, go to Roles and Role Inheritance tab.

Click Create Role button
Input value for the following column
Application,Role Code.Display Name,Description
Click Apply button

then query the role you created just now,,click update icon.
click Create Grant button,Input value for the following column
Name,Description

For the Data Security Object enter “Concurrent Requests”.
Click Next and provide the Data Content Type of “Instance Set”.
for Instance Set choose instance set created in step #1
Click Next
The permission Set is “Request Operations”.
Click next and finish button

3. As the SYSADMIN user with “User Management”, go to Users

Under Search region,query user name your USER
click update icon,click Assign Roles button
Query the role which you created in step 2
click apply

Same steps for user SYSADMIN

4.Wait some mins (10-15mins) to make workflow Angent listener to proceed it
then retest your issue.

How to stop users to see specific Requests of any other user - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2017/07/how-to-stop-users-to-see-specific.html

How to stop users to see specific Requests of any other user

Navigation: View>Requests>Find>Find Requests>Specific Requests> (Now here I can see any user Request. How can I stop User to access this)

--------------------------------------------------------------------------------------------------------

1- Login as sysadmin ->functional developer.
2- Search for object Concurrent Requests.
3- Click on Concurrent Requests (link in the left cell)
4- Select the grants tab, click update.
5- Select the grants tab (again)
6- Update the "valid to " with the same date of the "valid from" for all records.
7- Click apply and retest the issue.

--------------------------------------------------------------------------------------------------------

For My Case:

1. Login as functional administrator.
2. Search for object Concurrent Requests.
3. For both XDO Concurrent Request Security click on Update and in Grantee Type select Specific User and select one user you want to allow to see all Users Requests (for my case it was Administrator User). one should be given access to view all requests of Users.

How to Disable Close Other Forms Function from any Responsibility - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2017/05/how-to-disable-close-other-forms.html

How to Disable Close Other Forms Function from any Responsibility

Navigate to Menu of the Responsibility and add in Function "Navigator: Disable Multiform".

If Menu is Shared to Multiple Users then add in Menu Exclusions of that Responsibility to Enable it for that Particular Responsibility