| Re: Issue Running Report in OTM - too much data
Hi Nick...the problem with scheduling the report is thatit will send a PDF file and not a CSV file which our settlement team needs.
From what Oracle told us, it wasn't necessarily a time-out issue but rather the amount of rows that OTM cannot handle. We optimized this report so that it uses a materialized view and when you run the report in PL/SQL, we get all the results in 10 seconds or less. The same if we run the report in OTM against the mview - we get results in html in about 10 seconds but when we try to export to Excel, that is where the issue starts. |