E-BIP/XMLP: BI Publisher Report Using Bursting Run Through Query Report Scheduler Goes To "No Success" When Generating Empty Data
(Doc ID 2474380.1)
Last updated on JULY 07, 2020
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.
While running a BI Publisher process that uses bursting to output type of Email with no output created, the process goes to "No Success".
The following error message is received when reproducing the issue:
“Peoplecode Exit(1) Abort invoked by Application at PSXPQRYRPT.MAIN.ExecRpt. (108,543)”
In order to replicate the issue, follow the below steps:
1. Login into PIA.
2. Navigate to Reporting Tools > BI Publisher > Report Definition.
3. Edit a publisher report based on a query data source with bursting.
This issue only occurs when in the report definition “Bursting” is used.
4. Schedule a BI publisher report with destination e-mail for this report (make sure the query does not produce any output).
Navigation: Reporting tools > BI Publisher > Query Report Scheduler
5. Check the output in the Process Monitor.
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