What's new in Customer Journeys?

Connect and learn more! ×
HCM Extract | Aggregate Function in value set — Cloud Customer Connect
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 | Aggregate Function in value set

Received Response
edited Feb 17, 2022 6:56AM in HCM Extract 1 comment

Hi ,

Requirement ->This value set returns minimum assignment effective start date for the given person and date range coming from fast formula( Extract rule type).

I used this logic, which looks good to me , inner query is returning the data but outside not returning the data . Could you please let me know where am I doing wrong?

select n.n

from (select level n from dual connect by level <= 1000000)n

where n.n = (select a.val from    


 to_number(to_char(MIN(EFFECTIVE_START_DATE), 'yyyymmdd')) val





       and system_person_type='EMP'

Howdy, Stranger!

Log In

To view full details, sign in.


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