Search This Blog

Wednesday, October 26, 2016

Oracle R12 Cancel/Delete Workflow in SSHR for Pending Approval Transactions

Requirement: to delete the transaction if leave applied by mistake or transaction hanging with no approvers.

As per the doc id (Doc ID 780290.1)

0. Go to Workflow Administrator > Status Monitor> search for the employee transactions> Select the transaction>
Click Workflow History button>
Click the Cancel Workflow Button
Copy the item key in the confirmation window.

1. Run 'Purge Obsolete Workflow Runtime Data' with appropriate age parameters such that the workflow item gets deleted.

Parameters:
Item Type : HR
Item Key : <from step 0>


2. Go to status monitor and make sure the item is deleted (select 'Any Status' and search)


3. Run "Complete Defunct HR Workflow Processes" with appropriate age parameters

Parameters:
Item Type : HR

4 comments:

  1. Dear Afzal

    When you will cancel the workflow, what will happen with the transaction it was handling...?


    Farhan

    ReplyDelete
    Replies
    1. The Workflow status will be changed as 'Cancel'. And the Aprroval status will show still as 'pending for Approval'. So to delete the records we need to run above concurrent programs.

      Delete
  2. What as up, I read your blogs like every week. Your writing style is awesome, keep up the good work!
    best site to learn spring boot
    spring boot online course

    ReplyDelete