Oracle standard reports can be modified to meet the needs of the business users and given a more acceptable look to it through the use of built-in XML publisher functionality coupled with Oracle BI Publisher Desktop utility. This can turn a huge amount of unused oracle standard reports into the useful reporting documents and save a great amount of time consumed in building the reports and maintaining them manually. Here is how to do it.
XML Publisher explained•Using data logic of Oracle standard reports and designing user defined template, thereby presenting the standard oracle report on a format that a user needs.
•Running reports within Oracle EBS just like the other concurrent requests.
•Enables us to make use of 100s of extremely useful oracle reports that are so far staying unused.
•Application customization remains a constraint in the usefulness of this utility.
•Running reports within Oracle EBS just like the other concurrent requests.
•Enables us to make use of 100s of extremely useful oracle reports that are so far staying unused.
•Application customization remains a constraint in the usefulness of this utility.
How to customise standard report using XML Publisher
• Change existing report output to XML using system administrator responsibility (make a note of report short name)
• Run report (using standard concurrent process) and save XML output
• Open BIP desktop (MS Word Having Template Builder installed)and load XML Data
• Design template and set layout.
• Create ‘data definition’ in XML Publisher administrator. (using report short name)
• Create template definition and upload template. (Using report short name)
• Set default template for report from system administration in Oracle EBS.
•Run report from concurrent process normally and view output.
Add Your Perspective
Use the discussion below to respond to the article, extend the argument, or add implementation perspective from your own work.
No comments yet.
Be the first to add a response to this article.