Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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
Tagged:
3