PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Query Report Viewer (psxp_cq_report_viewer) connected query issue with parent query prompt

edited Jan 11, 2021 8:51PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

Hi, we are on pt 8.57.15 for hcm 9.2. While using the query report viewer for connected query as data source type, I'm noticing that any connected query that has prompt in the parent query shows a message popup box that said "Parent query returned no rows (241, 248) Parent Query does not returned any rows. Please check Query prompt values (if any)." therefore no report was being created. I heard from another person on the functional reporting team: "I had another connected query that I had created, which had a prompt in the parent query.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center