How to Create The Service Manager ‘FNDSM’ on Oracle Applications

Create The Service Manager ‘FNDSM’

Run below command to check if node is registered for FNDSM:-
select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like ‘FNDSM%’;

if not then follow

Note.218893.1 :How to Create The Service Manager ‘FNDSM’ on Oracle Applications

SOLUTION

From the Application tier:

1. Log in as applmgr
2. cd to $FND_TOP/patch/115/sql
3. Run the script: afdcm037.sql
4. This script will create libraries for FNDSM and create Managers for Preexisting Nodes.

[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “1” entry_duration= “0.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]

Note: Service Manager “FNDSM” can not be created from form:
Concurrent> Manager> Define under Sysadmin Responsibility.

[edsanimate_end]

Reference <bug:6085070 FNDSM TRIGGER CAUSES SERVICE MANAGER NOT TO BE CREATED AFTER CLONING SINGLE NODE>