Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL query to map Overdue tasks in checklists

MaeHCMApr 28 2022

Im trying to pull employees allocated checklists overdue tasks in BI Publisher. I am lookin at these tables, PER_ALLOCATED_CHECKLISTS and PER_ALLOCATED_TASKS however I am unable to find any fields related to Overdue or Due Date. Although when I check on the configuration of the lookups ORA_PER_CHK_FILTER_DUE_DATE under Checklist Templates module. I am unable to find which table and field to use in order to map this and get the values? Any advise.

Comments

Post Details

Added on Apr 28 2022
0 comments
1,821 views