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

User Prompt Results Causing ORA-01795 Error (IN statement 1000 expression max limit)

Received Response
edited Jan 4, 2021 1:55PM in Reporting and Analytics for HCM 2 comments


Need solution to get past ORA-01795 error caused by expressions returned from user prompts into an IN statement when selecting All



Appreciate any help with this issue as none of the possible solutions found have worked.


We currently have a report that gives the Job Profile (job code/title, description, etc.) to allow review of all items associated to a job in a single view.  It allows the user to select the Job, Job Group, and Job Sub-Group.  However, when the user runs the report without selecting anything (running wide open), it gives us the ORA-01795 ("Maximum Number of Expressions In The List is 1000).  I understand that the IN statement can only have a maximum number of expressions of 1000.  We need to find a way to get around this no matter how many items the

Howdy, Stranger!

Log In

To view full details, sign in.


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