My Oracle Support Banner

E-BI/XMLP: BI Publisher Reports Do Not Get Distributed Via E-mail To All Distribution IDs (Doc ID 2037921.1)

Last updated on FEBRUARY 04, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.54 [Release 8.4]
All Platforms


The issue is specific to only PeopleTools 8.54.05 up to PeopleTools 8.54.14 patch levels.

When attempting to schedule BI Publisher Reports to Email output type, User IDs or Roles specified for distribution under the "Distribute To" list in Distribution Detail page may not receive the emailed report, depending on the settings in the Report Definition for that particular report. If the Report Definition has Report Viewers defined under the Security tab, then the problem does not occur. If however, the Report Viewers list is blank, then email functionality (using the Process Scheduler Request "Distribution" link) will be affected.

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

1. Login to PIA
2. Navigate to Reporting Tools > BI Publisher > Query Report Scheduler
3. Add a new value
4. Select a Report definition that does not have any user IDs specified under the Report Viewers list under Security tab
5. Click Run, then Select Email output type with any output format, then Click Distribution, then Add at least one additional User ID to the Distribute to
6. Click OK
7. The process goes to success but email is not sent to all User IDs. Instead it is sent only to the user who initiated the process.




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

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