For more information, please refer to this announcement explaining best practices for getting answers to questions.
Script to Find Progress of any Absence Batch Job
Content
This script returns total number of records picked up for processing, records successfully processed, records errored and records yet to be processed. This SQL can be run for Absence Batch jobs that are currently in Running or Completed Status.
SELECT
COUNT(*) Total_Record_Count,
SUM(DECODE(action_status_cd,'U',1,0) ) Unprocessed_Count,
SUM(DECODE(action_status_cd,'E',1,0) ) Error_Count,
SUM(DECODE(action_status_cd,'P',1,0) ) Processed_Count
FROM
ben_person_actions
WHERE
benefit_action_id IN
( SELECT benefit_action_id
FROM ben_benefit_actions
WHERE request_id = <1529871> ) -- Replace <1529871> with Parent Process ID