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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Aggregate function on ValueSet is not working

edited Jul 21, 2021 7:11AM in Reporting and Analytics for HCM 2 comments

Summary

Aggregate function on ValueSet is not working

Content

I have attached my query containing the where clause which is not working. Even the below value set is not working. I understand that parameter is not getting passed. Kindly help on the same.

From clause:(SELECT TO_NUMBER( LEVEL) - 1 n  FROM DUAL  CONNECT BY LEVEL <= 1000000 ) n
Value Column Name:n.n
ID Column Name:n.n
Where clause:n.n=(SELECT  :{PARAMETER.Person_ID} FROM DUAL)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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