Check whether the EBS and fmw integrated workflow manager

Workflow manager checkpoint (DB level ):

-- 1: Set the Database Job AQ parameter. We recommend that you set job_queue_processes to 10.

Select P. Name, P. Description, P. value from

V $ parameter P

Where p. Name in ('job _ queue_processes ', 'aq _ tm_processes ');

-- 2 Concurrent manager Settings Check, set to Yes

Select pro. profile_option_name,

Pro. user_profile_option_name,

PRV. profile_option_value

From apps. fnd_profile_options_vl pro,

Applsys. fnd_profile_option_values PRV

Where pro. profile_option_id = PRV. profile_option_id (+)

& PRV. level_id = 10001

And pro. profile_option_name = 'conc _ gsm_enabled'

 

-- 3 check the service manager target and actual of the concurrency Manager> = 1

Select fcq. concurrent_queue_name,

Fcq. user_concurrent_queue_name,

Fcq.tar get_node,

Fcq. max_processes target,

Fcq. running_processes actual

From fnd_concurrent_queues_vl fcq

Where fcq. enabled_flag = 'y'

Fcand Q. concurrent_queue_name like 'fndsm %'

 

-- 4 workflow agent listener service check

Select fcq. concurrent_queue_name,

Fcq. user_concurrent_queue_name,

Fcq.tar get_node,

Fcq. max_processes target,

Fcq. running_processes actual,

Fcqs. sleep_seconds

From fnd_concurrent_queues_vl fcq, fnd_concurrent_queue_size fcqs

Where fcq. concurrent_queue_id = fcqs. concurrent_queue_id

Fcand Q. enabled_flag = 'y'

Fcand Q. concurrent_queue_name = 'wfalsnrsv'

 

Steps for running a workflow (system operation level ):

1. log on to the EBS system, select the duty of the workflow administrator, and open the workflow manager under Oracle Applications manager.

2. Check whether the agent listeners/service components is up.

 

 

3. Click the green button after Agent listeners/service components or the related link in the lower-left corner of the page.

.

 

4. On the open page, check that the workflow deferred agent listener is running normally. If it is stopped, restart the agent.

5. Click [workflow proxy receiver Service] link to check whether the workflow proxy receiver service works properly (the actual processes/target processes of the workflow proxy receiver service is no less than 1, workflow deferred agent listener can be restarted successfully

6. Check the other checkpoint. In the concurrency manager, confirm that the workflow proxy accepts the actual and target> = 1, which correspond to the check at point 5th.