Get Started with Redwood for Oracle Cloud HCM Begin Now
Approved timecard filter in OTL HCM EXTRACT
Summary:
We have created an HCM Extract for changes only timecard which is working correctly. Only issue is i want to filter only those timecards that have been approved. I am using the below filter :
tc.START_TIME_TRUNC in (
select TRUNC(START_TIME)
from hwm_tm_rec_grp_sum htrgs
where htrgs.status='APPROVED'
)
But still HWM_EXT_CALCULATED_TIMECARD_HDR_UE UE is fetching submitted or entered timecards. How can this be avoided ?
Thanks!
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
0