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
2
Views
1
Comments
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    

       (SELECT 

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

       FROM

       PER_ALL_ASSIGNMENTS_M  

       WHERE 

       assignment_type='E' 

       and system_person_type='EMP'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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