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

URL from HCM Cloud page with one of the parameters = NUL not opening BIP report

Hello

We had a requirement to open a report from HR Help desk page. Initially we had OTBI report with 2 parameters, Primary Person ID and Affected Person ID. Even if the Affected Person ID is null, OTBI report used to open. We changed it to BIP report and changed the URL . Now the issue is if both the parameter has values, Report (BIP) opens in a new window, and it works fine. But if Affected Person ID is NULL/Blank, in the URL it is passing NULL, and BIP report does not open. (no error, just nothings open).

We have also tried to use NVL in the Query but it does not work.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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