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

Transactions Tables are not storing Data for few Transactions

Received Response
155
Views
2
Comments

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!