BI Publisher Report Is Getting Wrong Results During Bursting When the Report Is Executed With ALL Values in Parameter (Doc ID 2912697.1)

Last updated on DECEMBER 07, 2022

Applies to:

Symptoms

Wrong results are received in mailer during bursting when the report executed with ALL values in parameter, although it gives correct values whenever only one value is selected in the parameter

Steps:

   1.  Configure bursting for a BI Publisher report by using below Bursting Query:

"
select
bursting_key as key,
TEMPLATE,
LOCALE,
OUTPUT_FORMAT,
SAVE_OUTPUT,
TIMEZONE,
CALENDAR,
DEL_CHANNEL,
OUTPUT_NAME,
PARAMETER1,
PARAMETER2,
PARAMETER3,
PARAMETER4,
PARAMETER5,
PARAMETER6,
PARAMETER8
from PNL_MAILER_SCHDL_TBL
where REPORT_NAME = '<Report_Name>'

"

   2. Schedule the report with ALL values in in one of the report parameters.

Results: The bursting key is not taking place properly when selecting "All" in the report parameter. The report executes for all the Codes in the report parameter and separate emails are sent for each code but with wrong values in growth columns.

Cause

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