Unable to fetch few tasknumber from approval related tables — 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

Unable to fetch few tasknumber from approval related tables

edited May 3, 2018 2:14PM in Reporting and Analytics for HCM 1 comment

Content

Hi Team,

We have a requirement to generate report for approval transactions (i.e approved/rejected).
For that we have built a query based on the below tables

1)hrc_txn_fnd_bpm_task_vl
2)fnd_bpm_task_history_vl
3)hcm_fusion_soainfra.wftask
4)hcm_fusion_soainfra.wftaskhistory

The query is working fine but there are some cases where I don't see few tasknumbers in the report
which was created 2-3 days ago.

Ex: Title for one of the tasknumber is "Termination for an employee"

Is there any other way of getting those tasknumbers (or) any frequency/process to insert data in above tables?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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