E-QY/CQ/BIP: AE Process Example PSXPQRYRPT - Goes To No Success When There Are No Rows - 'Parent query %1 returned no rows' (Doc ID 1598896.1)

Last updated on OCTOBER 14, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 to 8.53 [Release 8.4]
Information in this document applies to any platform.

Symptoms

On : 8.52 - 8.53 version,

While running a connecting query, the AE process (PSXPQRYRPT ) goes to No Success when there are no rows returned for the parameters entered. here is the message I get.

ERROR
-----------------------
Parent query %1 returned no rows. (241,248) PT_CONQRS.CONQRSMGR.OnExecute Name:Run PCPC:21760 Statement:510


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. submit the Connected Query (CQ) such that no rows are returned for the parameters entered
2. observe the AE PSXPQRYRPT goes to No Success

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users see No Success when there are no rows, rather than Success, as expected.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms