Get Started with Redwood for Oracle Cloud HCM Begin Now
Bursting Query in BIP Using Multiple Subject Area Data Model Not Working
Summary
Created a data model using multiple subject areas and I want to use both to burst, but the where clause is not working.Content
Hi all,
We have a requirement to send an email to an employee's personal email once they are hired into Oracle Fusion. I've created a data model using both the "Workforce Management - Person Real Time" (to get the personal email) and "Workforce Management - Worker Assignment Event Real Time" (to get the assignment creation date). I've tested the attached bursting query using my email as Parameter 1, and it works fine. When I adjust Parameter 1 to "Workforce Management - Person Real Time"."Person Email Addresses"."Email Address" it ignores the where clause and sends the email to everyone regardless of creation date.
Tagged:
0