My Oracle Support Banner

E-BIP/XMLP: BI Publisher's "Query Report Viewer" Pop-Up Message/Error "Parent query returned no rows. (241,248) Parent Query does not returned any rows. Please check Query prompt values (if any)" Instead of Expected Prompts. (Doc ID 2775955.1)

Last updated on MAY 17, 2021

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.

Symptoms

When attempting to use the query report viewer for connected query as data source type, the Users are noticing that any connected query having prompt(s) in the parent query shows a message popup box after hitting "View Report" link, as follows:

"Parent query returned no rows. (241,248)
Parent Query does not returned any rows. Please check Query prompt values (if any)."

The issue can be reproduced at will with the following steps:

1. Navigate to Reporting Tools > BI Publisher > Report Definition.
2. Open the delivered HCM report definition for the "BREREG02" report.
3. Go to the "Properties" tab, then select the PeopleTools settings from Property Group.
4. Configure the "psxp_cq_report_viewer" property to "True".
5. Save the report definition so that the report can be viewed in Query Report Viewer.
6. Navigate to Reporting Tools > BI Publisher > Query Report Viewer and search for the "BREREG02" report.
7. Click on the "View Report" link to view the report.
8. Observe the pop-up message/error instead of expected prompts.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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