BI Publisher (MOSC)

MOSC Banner

Bursting BIP Report to email and sftp

edited Aug 5, 2025 2:53PM in BI Publisher (MOSC) 4 commentsAnswered ✓

Customer Problem Description
---------------------------------------------------

Problem Summary
---------------------------------------------------
Bursting schedule job executes successfully, but no emails are received by recipients

Problem Description
---------------------------------------------------
Hi,
We are using Oracle BI Publisher (on-premise) and have configured a bursting report with the delivery channel set to EMAIL.

The bursting SQL returns valid recipient rows, including the required columns (KEY, TO_ADDRESS, DEL_CHANNEL, TEMPLATE, etc.), and the job completes successfully without any errors.

SELECT
agency AS KEY,
'ICM_External_agency_Plan_SACT_NSUB_brusiting_rpt' AS TEMPLATE,
'en-US' LOCALE,
'PDF' AS OUTPUT_FORMAT,
'EMAIL' AS DEL_CHANNEL,
'report_' || agency || '.csv' AS OUTPUT_NAME,

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