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