Sql query required to identify time card approver and assignee details — Cloud Customer Connect
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

Sql query required to identify time card approver and assignee details

in Reporting and Analytics for HCM 2 comments

Sql query required to identify time card approver and assignee details.

We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. But the fa_fusion_soainfra.wftask table dosent contain Identificationkey or not same as the Transaction_id. Hence we could not go with these tables. So we are reaching out the oracle community for a help. If anybody has table details which stores Time card approver and Assignee details please share with us.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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