By Tim Dexter-Oracle on Oct 26, 2007
A few weeks back I made a call for templates for a demo of the new Reports Repository demo at OpenWorld. As I mentioned this is going to be a repository for us and hopefully you to share your templates with the Publisher community at large. I got a few templates but I'd love to get more.
Doug Fortnam at Protege Software Services contacted me with a great example of a sharable template - its not for an invoice report but actually a custom report but its very useful. I'll share his insights here.
This XML Publisher Report is a report to document any Forms Personalizations present in Oracle Apps 11.5.10. I presented it at the New England OAUG in Massachusetts in June of this year. I think it is a good example of a useful, shareable template because it documents the setup of Forms Personalizations, either select Personalizations or all Personalizations in the database. The sql query to generate the flat file was developed in TOAD and then used in the Report Wizard to create the data template. This example makes extensive use of re-grouping and conditional logic to display the data in a fashion similar to what is displayed in the Oracle Forms. If I had to do it over again, I would develop a data template with grouping to simplify the rtf template. Not sure if there is a performance hit because of all the re-grouping.
Doug shared the template and you can get it here.