You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Transactions Tables are not storing Data for few Transactions

Summary:

Hi Team,


I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any data related to those process names called Time Change Request Approval.


Below are the tables names having issue:


1. fa_fusion_soainfra.wftask

2. fa_fusion_soainfra.wftaskhistory

The above tables are not showing any Approver Names for Time Change Request Approval transactions.

SQL Query User:

SELECT DISTINCT Wft.Identificationkey,

txnh.object

FROM 

fa_fusion_soainfra.wftaskhistory WFT,

Fusion.Hrc_Txn_Header Txnh

WHERE

1=1

AND txnh.object = 'HWM_TM_REC_CHANGE_REQS'

And TO_CHAR(Txnh.Transaction_Id) = Wft.Identificationkey(+)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!