Defining New Concurrent Manager in R12

We can execute concurrent request through newly define concurrent manager without using Standard Manager.

Responsibility Needed - System Administrator

1. Define Custom Workshifts (Optional)

     Navigation 

     System Administrator->Concurrent->Manager->Workshifts

     Click + icon on the menu bar (Top left) to insert new record.

     Enter details and save.

2. Define Concurrent Manager

     Navigation 

     System Administrator->Concurrent->Manager->Define

     

     Enter details for following

• Manager - New Concurrent Manager Name
• Short Name - Short Name
• Application Name - Usually Custom Application Name or Existing Application (Ex : Application Object Library)
• Type - Concurrent Manager
• Cache Size - 1
• Node - If you use multi node configuration, you can differentiate primary node for this manager from standard manager such as follows otherwise just keep them blank so that EBS automatically find  the right node (Primary - XX2,Secondary - XX1)
• Program Library Name - FNDLIBR 
• Save the Record

3. Define Workshifts for manager

     Click 'Workshifts' button on Manager form

     

     Enter following

• Select Work shifts from drop down define in step 1 or select standard workshifts
• Processes - 10
• Sleep Seconds - 30
• Save Details

4. Define Specializtion Rule for manager

      

     Click 'Specialization Rules' button on Manager form

     Enter what need to be run on new manager

• Include/Exclude
• Type - Program (Can include Program)                                             Oracle ID (Can include Module)                                             User (Can include Program execute by particular User )
• Application - Application Name for Program
• Name - Name of Program/User
• Save the Record

5. Exclude from Standard Manager

     (Otherwise both New Concurrent Manager and Standard Manager handle       objects)

     Navigation 

     System Administrator->Concurrent->Manager->Define

     Query 'Standard Manager' and Click 'Specialization Rules' button

     Exclude the Program/User defined in Step 4

        

     Save the Details

      Note : In Specialization Rules of  'Standard Manager', never use                "Include" definition. Standard Manager is supposed to deal with all             requests. If you define any Include record here, Standard Manager             only deal with that "Include" object as if it is a special manager for           that object and all other concurrent requests will be kept in "No               Manager" status

6. Activate Newly Created Concurrent Manager

     Navigation 

     System Administrator->Concurrent->Manager->Administer

     Scroll down the record until find the newly created concurrent                  manager

     Click the row and click 'Activate' Button

     By Clicking 'Refresh' Button at regular interval, Monitor Actual and            Target Processes are displayed as 10 which defined in step 3

7. Bounce the Standard Manager to reflect the latest definition

     Navigation 

     System Administrator->Concurrent->Manager->Administer

     Scroll down the record until find the 'Standard Manager' concurrent            manager

     Click the row and click 'Deactivate' Button

     By Clicking 'Refresh' Button at regular interval, Monitor Status Column,      Once Status column become Deactivated then Click 'Activate' button          to start the Standerd Manager.

8. Check If the concurrent request are running with newly created concurrent manager

     select b.USER_CONCURRENT_QUEUE_NAME,

     e.USER_CONCURRENT_PROGRAM_NAME

     from fnd_concurrent_processes a,

     fnd_concurrent_queues_vl b, fnd_concurrent_requests c,

     FND_CONC_REQ_SUMMARY_V d,FND_CONCURRENT_PROGRAMS_TL e

     where a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID

     and a.CONCURRENT_PROCESS_ID = c.controlling_manager

     and c.request_id=d.request_id

     and d.concurrent_program_id=e.concurrent_program_id

     and c.request_id =<Request_id>;

Execute above script with relevant request_id to get the details.