This article is part of Operations Management – 101, specifically addressed to Oracle HCM Cloud – technical consultants.
In this article, we will use an SQL to get the list of HCM Extracts scheduled by a user.
Use the following query (r.call_id is the process ID)
Modify the query to use flow_name or flow_instance_name depending on what is needed:
select r.call_id ,fti.flow_instance_id,ft.base_flow_task_name,rh.requestedstart
,f.flow_name,fi.instance_name,r.call_type,
fi.status
from pay_flow_task_instances fti
, pay_flow_tasks_vl ft
, pay_requests r
, ESS_REQUEST_HISTORY rh
, pay_flow_instances fi
, pay_flows_vl f
where ft.base_flow_task_id = fti.base_flow_task_id
and r.flow_task_instance_id = fti.flow_task_instance_id
and r.call_type = ‘FLOW_ESS’
and ft.base_flow_task_name = ‘START_FLOW’
and rh.requestid = r.call_id
and fti.flow_instance_id = fi.flow_instance_id
and fi.base_flow_id = f.base_flow_id
and f.flow_name = ‘XYZ%’
–and instance_name like ‘XYZ%’
order by requestedstart desc;
You can run these queries by using Business Intelligence (BI) tool. Please refer to below note for more information:
Note 1910762.1How Can I Use BI Publisher to Run SQL Against the Fusion Applications Database ?