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

HCM Extract| Advanced filter criteria

Received Response
17
Views
2
Comments

Summary:

I am working on an extract, where the business requirement is to fetch the oldest_assignment who falls between financial start date and financial end date.

In the assignment data group under advanced filter criteria, I gave below condition but it is not working, could you please let me know where the issue is?

Financial Year is ( 6 April to 5 April)

Effective Date Parameter - Always financial end date which is 5 April YYYY will be passed

Advanced Filter Criteria-

and asg.effective_start_date in 

 (SELECT min(asg_inner.effective_start_date)

  from PER_ALL_ASSIGNMENTS_M asg_inner 

  where  

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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