FUSION GLOBAL HR: Unable To Find Pending Transaction in Transaction Console (Doc ID 2945231.1)

Last updated on JANUARY 11, 2024

Applies to:

Symptoms

On : 11.13.22.10.0 version, Global Human Resources

ACTUAL BEHAVIOR
---------------
User is unable to find pending transaction when searching by transaction ID within transaction console.


EXPECTED BEHAVIOR
-----------------------
Pending transaction appears in query results in Transaction Console.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Tools - Transaction Console
2. Search by Transaction ID
3. No results display

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot terminate pending transaction

The below query was used to find the pending transaction

SELECT h.transaction_id, d.state,d.status,h.module_identifier, h.INITIATOR_USER_ID,h.CREATED_BY, h.CREATION_DATE
FROM HRC_TXN_HEADER h,HRC_TXN_DATA d
WHERE h.Transaction_id = d.Transaction_id
AND ( h.subject_id IN
( select distinct person_id from fusion.per_all_assignments_m where
assignment_number like '%<**Person_Number**>'))

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.