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
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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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