Oracle RDF Report or Printing using fnd_file.put_line ?
I am seeking for a efficient reporting methodology
We have a huge database of 2 TB and keep growing every month. Currently our reports are getting generated using fnd_file.put_line (fnd_file.output,
Since it is taking enourmous processing time based on data volume. will migrating to Oracle Reports(.rdf) is a good idea?
How does the RDF report print the output of the report. Does it print at one go ? or the same concept like printing one by one row similar to fnd_file.put_line?
what is the concept behind Oracle reports engine ? does the output post processor take care of all the post processing activity an improves the performance instead of printing in a loop using