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

Group By Function Error

edited Jan 6, 2021 6:12PM in Reporting and Analytics for HCM 2 comments

Content

Hello,

I'm trying to used the ranked last function and group by Person Number to pull the employee's latest assignment, but I keep receiving the below error. I've used the Group By function before, but for some reason it's not working on this report.

 

State: HY000. Code: 42020. [nQSError: 42020] GROUP BY clause, [Dim - Employee.Person Number], is inconsistent with the projected columns in the SQL query request. (HY000)

Version

20D
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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