Home / APPS DBA / How to Create The Service Manager ‘FNDSM’ on Oracle Applications

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.

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

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

 

 

About Syed Saad Ali

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

AC-50480: Internal error occurred

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora

Leave a Reply