How to Cancel an HCM Extract Schedule

To Cancel the extract

1. Navigator > My Clients Group > Payroll > Flow Submission and Results -> View Flows.
2. Search for the extract.
3. Click on the Action link (3 dots ...  Link).
4. Select option to cancel flow and recurring schedule.

To cancel a process with another user than the one submitting the flow:

1. Log in as a user who has an IT security manager role.
2. Navigate to Tools > Scheduled Processes.
3. Search for the Scheduled Job.
4. Cancel this job from Actions > Cancel Process.

Use the following query(Please note call_id is the process ID)

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 = 'Call_id%'

order by requestedstart desc;