Useful Workflow Queries

Workflow Processes Status

SELECT fcq.USER_CONCURRENT_QUEUE_NAME Container_Name, DECODE(fcp.OS_PROCESS_ID,NULL,'Not
Running',fcp.OS_PROCESS_ID) PROCID,
fcq.MAX_PROCESSES TARGET,
fcq.RUNNING_PROCESSES ACTUAL,
fcq.ENABLED_FLAG ENABLED,
fsc.COMPONENT_NAME,
fsc.STARTUP_MODE,
fsc.COMPONENT_STATUS
from APPS.FND_CONCURRENT_QUEUES_VL fcq, APPS.FND_CP_SERVICES fcs, APPS.FND_CONCURRENT_PROCESSES
fcp, fnd_svc_components fsc
where fcq.MANAGER_TYPE = fcs.SERVICE_ID
--and fcs.SERVICE_HANDLE = 'FNDCPGSC'
and fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
and fcq.concurrent_queue_id = fcp.concurrent_queue_id(+)
and fcq.application_id = fcp.queue_application_id(+)
and fcp.process_status_code(+) = 'A'
order by fcp.OS_PROCESS_ID, fsc.STARTUP_MODE;

WFupload and DownLoad

WFLOAD apps/apps@arsdev2 0 Y {UPLOAD | UPGRADE | FORCE} <filepath>[<file_name.wft>]
WFLOAD apps/apps@arsdev3 100 Y FORCE REQAPPRV.wft

WFLOAD apps/appst3lp207@ARSPROD 0 Y DOWNLOAD REQAPPRV.wft REQAPPRV


How to Close the FYI notifications Automatically 

1) Go to system administrator responsibility.
2) Click on Workflow Manager inside Workflow : Oracle Applications Manager.
3) Click on the button next to Notification Mailers. 
4) Click on the Edit Button. Click on Advanced Button. Click on Next button 3 times.
5) Then you will see Autoclose FYI check box. Tick that box and Click on Finish Button twice.
6) Click on Apply Button.


This will automatically close all the FYI notifications.

To Find the Workflow Activity for a particular Item Type.

SELECT pa.process_item_type,

       pa.process_name,

       pa.process_version,

       pa.activity_item_type,

       pa.activity_name,

       aav.name,

       aav.value_type,

       aav.text_value,

       aav.number_value

  FROM wf_process_activities pa, wf_activity_attr_values aav

 WHERE     pa.process_item_type = 'APEXP'

       AND aav.process_activity_id = pa.instance_id

       AND aav.name = '#TIMEOUT'

       AND process_name LIKE 'AME%'