Manage Approval Transactions counts new and 'Abandoned' transactions (Doc ID 2219522.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

The system cleared all errored transactions but it still shows in Manage Approval Transactions with complete count of new and old transactions which were abandoned via script


Customer wanted not to consider the abandoned transactions which were earlier errored.

Steps to reproduce the issue
----------------------------
1) Pic any failed approval transaction
2) Abandon the transaction as per

==============================================================================

UPDATE hrc_txn_data
SET status ='ABANDON'
WHERE transaction_id IN
(xxxxx)

commit;
==============================================================================

3) Abandoned transaction still being considered in Manage Approval transaction page.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms