Disable Time Out Notification Functionality

Posted on by

Oracle SSHR  AME , Oracle Workflow 

All old notifications are sent to Top Approver. Our requesting how to stop it or how to update the timeout value for all old active workflow process so that timeout notification will not triggered for them.

 

Solution: 

You can resolve this issue by running the concurrent request: Complete Defunct HR Workflow Processes .

For the following action plan always run in clone first and test .

1. For the count

select item_type,count(*) from WF_ITEMS
where ITEM_TYPE = ‘HRSSA’ and END_DATE is null
and begin_date < sysdate – 360
group by item_type

2. Run the concurrent request – Complete Defunct HR Workflow Processes (As System Administrator responsibility)
Parameters:
Item Type: HR
Age : 360 — Please use as per you business need.
Transaction Type: ALL
Submit.

3. Run the SQL again for the count:
select item_type,count(*) from WF_ITEMS
where ITEM_TYPE = ‘HRSSA’ and END_DATE is null
and begin_date < sysdate – 360
group by item_type