Rollback a Self Service Transaction through API (hr_transaction_api.rollback_transaction)

By | June 27, 2015

In this article of Oracle HRMS Overview, I am going to share API to rollback a self service transaction. This will purge the data from self service transaction main tables and its relevant PQH history tables.

This API is used normally when any transaction gets hanged due to session hang or any workflow error and we want to remove this transaction at all from the system. As a result of this API, transaction will be completely removed from the system.

hr_api_transaction_api

–Rollback a Self Service Transaction
declare
sshr_transaction_id number := 23456787;

p_item_type varchar2(10):=’HRSSA’;

p_item_key varchar2(10) := ‘123456’
begin

–It aborts the workflow of the transactions

wf_engine.abortprocess (p_item_type, p_item_key);

–It deleted the data of transaction from HR_API_TRANSACTIONS tables but data in PQH tables still remains in database for history purpose.

hr_transaction_api.rollback_transaction
( p_transaction_id => sshr_transaction_id ,
p_validate => false );
dbms_output.put_line(‘Transaction Rolled back’);
exception when others then
dbms_output.put_line(‘Exception ‘||SQLERRM);
end;

Related Posts

List of Ready Made Solutions for Beginners
Profile Values in Forms Personalization
Apps Interview Questions
Free Online Assessment
10 Steps for XML Bursting in Oracle Apps