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

Too much SQL!

edited Nov 2, 2020 8:51PM in Reporting and Analytics for HCM 6 comments

Summary

Prompt not limiting by another field - Support have advised too much SQL

Content

Hi

I'm getting an "unexpected token" error message when trying to limit one field in a dashboard prompt based on results from another (within the hierarchy)

Support have advised its because in admin we have lots of security roles and this is generating too much SQL causing the prompt to error.  The exact message is:

When a user has a lot of roles it will generate a lot of SQL Where clauses in the back-end and then the values returned to the prompt will fail.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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