Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood 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.
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 -
0