Help BIP Report not pulling correct info — Cloud Customer Connect
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: Oracle Cloud SCM and Purchasing

Help BIP Report not pulling correct info

edited Oct 26, 2020 6:37PM in Reporting and Analytics for HCM 3 comments

Summary

We recently went Live with OLC. One of the reports we built is a BIP report with several parameters.

Content

Here is the WHERE Clause with parameters.

For some reason when entering DUE_DATE no results are returned.  If I enter a value on DUE_DATE_FROM and leave DUE_DATE blank, results are returned.  Any ideas how I could fix?  Thank you

  WHERE     d1.c18 = NVL (:p_display_name, d1.c18)
         AND d1.c9 IN (:p_course_name)
         AND NVL (d1.c16, '1') = NVL (:p_coordinator, NVL (d1.c16, '1'))
         AND d1.c2 IN (:p_completion_status)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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