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

OTBI Analysis Error: Subquery contains too many values for the IN predicate.

edited Jul 21, 2020 7:55PM in Reporting and Analytics for HCM 3 comments

Summary

State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)

Content

Hi,

I have a OTBI report which needs to pull the Person NUmber, Manager Number, Dept, Location, Legal Employer from Workforce Management - Worker Assignment Real Time subject area. and Need to check if the person's Bank account number is null or branch number is null or bank account number/branch number comprises only of 0 or number of characters in bank account number is not 8(it must be 8) or number of characters in bank branch number is not 6 (it must be 6 to be valid bank detail). For checking all these 6 conditions, I have used the Payroll -

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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