Report Does Not Return Data When the Input Query Parameter Is Set As Blank/Empty/Null (Doc ID 2407999.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

On Unifier : Any Version

ACTUAL BEHAVIOR
---------------
Custom Report does not return data when the input query parameter is set as blank/empty/null.


EXPECTED BEHAVIOR
-----------------------
The report should return data even when the input query parameter is set as blank/empty/null.

STEPS
-----------------------
The issue can be reproduced at will with the following steps, in this example the report has more than one (1) input query parameter:

1. Login Unifier
2. Navigate to the applicable work space and open the custom report
3. Select one value as the input parameter
4. Keep blank as the second input parameter
5. Click Report to show the result
6. No results are returned

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the report out when second parameter is blank/empty/null

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.