Difference between processing of e-text and rtf XMLP templates
Oracle has given rtf templates which generates rtf outputs for Account Analysis Report or Trial Balance Report etc. This was not very useful for our users as they couldn't perform regular calculations and verifications etc or to use the output as a feed to other systems. So, the requirement was to generate the output in EXCEL format. We just changed the output type to EXCEL while submitting the concurrent program. Since the data was a little huge (14 columns, 36-58 thousand rows) the concurrent program was not getting completed or after several hours Output Post Processor would fail.
So, as a workaround, we developed delimited e-text templates. For the same amount of data, with this template, concurrent programs completed relatively faster (in fact much faster, within 0.5-2 hrs).