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.
