BI Publisher report not delivering as expected due to large size

User_SI7HK

Hi, we are using OAS 7.0, EBS 12.2, OBIA7.6.4, Oracle 19 db on linux set up. We have a BI Publisher report that has around 500K rows that we are exporting in .xlsx file. Due to large data volume the report execution times out and so we are planning to use this report by scheduling. Server config attachment limit is increased from default 300 MB to 500 MB. The report (150 MB in size compressed to 75 MB) did deliver once or twice as attachment. But now it is not delivering and job status says 'Problem'. We have cleared the server cache but not effect. Upto 170 MB reports gets displayed upon running but when the same report is scheduled it, sort of attempts to make a bigger attachment (wrapping-up bigger size then actual) and fails. We understand that the size is not conventional but is there a way to make this report (under 500 mb size) work as attachment. Also, is there any other way (other than FTP) to deliver this BIP report like a link (similar to Home Page alert of an agent report), such that report stays on the server and is accessed by a link (there by not clogging the mail server and user outlooks). Any input is highly appreciated.

User_SI7HK

Thanks Riyaz, we have tried all options to reduce the size of the report. We found an option that we were looking for at xmlpserver : Administration > Delivery: Delivery Configuration > Email Output as URL, applied that and testing to see if that delivers the output as URL (as oppose to compressed file).

Riyaz Ali-Oracle

Check Mail Server Limits: Even though you've increased the BI Publisher attachment limit to 500 MB, some mail servers impose their own message size restrictions.Ensure the email server supports large attachments.

1. Try Reducing unnecessary columns.
2. Splitting reports into multiple smaller scheduled reports.
3. Exporting to CSV instead of XLSX, which typically has a lower overhead.

Use Compressed Delivery: If using email attachments, ensure compression settings are fully enabled at the BI Publisher output level rather than just at the OS level.

User_SI7HK

Hi Riyaz, so it worked, we got the output as URL, but this setting will affect the delivery across the board for all jobs, though it is preferable than attachment but needs buy-in from leadership & communication to user groups, before enforcing the change.

Riyaz Ali-Oracle

The limit of 15 MB is set at the SMTP server configuration across all the Fusion Application Fleet and cannot be changed.

Please review the below KM note:

Oracle Fusion BI Publisher: Report outputs larger than 15 MB do not get delivered via Email (Doc ID 2114473.1)

You can try UCM (Universal Content Manager) for Report Storage as alternative approach. Instead of emailing the report, store it in UCM and generate a download link for users.

Users can access the report via a secure URL without clogging email servers.