{"id":58,"date":"2008-02-06T03:59:35","date_gmt":"2008-02-06T03:59:35","guid":{"rendered":"http:\/\/ibizsoftinc.com\/blogs\/uncategorized\/save-with-xml-publisher"},"modified":"2008-02-11T20:26:11","modified_gmt":"2008-02-11T20:26:11","slug":"save-with-xml-publisher","status":"publish","type":"post","link":"https:\/\/www.ibizsoftinc.com\/blog\/save-with-xml-publisher\/","title":{"rendered":"Save $$$ with XML Publisher"},"content":{"rendered":"<p>After having worked with Oracle Reports in the last so many years, I have found that Oracle Reports is not a developer friendly tool and formatting of report take lot\u2019s of time ( and money) especially reports like<\/p>\n<p>\u2022\tInvoicing<br \/>\n\u2022\tCheck Printing<br \/>\n\u2022\tForms and labels<br \/>\n\u2022\tContracts etc <\/p>\n<p>And most of the customers have implemented 3rd Party Reporting tools. However these tools are really expensive, maintenance hassles, labor intensive, there are licensing and integration issues. <\/p>\n<p>But with the introduction of the XML Publisher, Oracle done a great job for developer community especially for e-Business Suite developer and hence the development cost involved. <\/p>\n<p><!--more--><\/p>\n<p>Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite. It provides a new approach to design and publish reports by integrating familiar desktop word processing tools with existing E-Business Suite data.  XML Publisher leverages standard, well-known technologies and tools, so you can develop and maintain user defined (custom) report formats.<\/p>\n<p>With XML Publisher<br \/>\n\u2022\tWe can use desktop tools like Microsoft word, excel, acrobat etc to design our Templates.<br \/>\n\u2022\tIt supports data from the multiple sources e.g. Oracle, Sql Server, People soft, Java etc.<br \/>\n\u2022\tPrint the output in pdf, rtf, Excel, HTML etc .format.<br \/>\n\u2022\tRoute the report to Fax, email, printer etc.<br \/>\n\u2022\tOnce we have a Template, with one Template we can have multiple outputs.<br \/>\n\u2022\tWe can print the Forms in pdf.<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_1.JPG' title='xml_1.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_1.JPG' alt='xml_1.JPG' \/><\/a><\/p>\n<p>It not only supports outbound, but also supports the inbound data from the various documents like word, excel, PDF by receiveing the data, converting the data into XML and feeding it back to the database.<\/p>\n<p>Oracle E-business (11i10) is fully integrated with the XML Publisher and almost all modules from HR to Order Management are utilizing the XML Publisher.<\/p>\n<p>Below is example of how to design and publish CUSTOM\/Standard  report with XML Publisher for Oracle Ebusiness.<\/p>\n<p>1.\tDownload and Install the XML Publisher tool from <a href=\"http:\/\/www.oracle.com\">Oracle<\/a> website on your windows client machine<br \/>\n2.\t Once the template Builder has been installed on your computer an additional toolbar (Template Builder) will be displayed in Microsoft Word<br \/>\n3.\tYou are ready to design the layout of the report in RTF format, for eg. you can add all types of fonts, colors, table logos, Barcode, pictures etc. This will form the template for the report.<br \/>\n4.\tCreate a program to generate the XML data .XML data can be generated from multiple sources. But in this document we will take the case when XML data will be generated by Oracle Application Concurrent Program (for Oracle Reports). Store the XML data in the local computer.<br \/>\n5.\tOnce the Layout\/Template of the report and XML data in available Map the XML with the layout.<br \/>\n6.\tRegister the XML Data definition and XML Template with Oracle application.<br \/>\n7.\tRun the Report.<\/p>\n<p>Now, let&#8217;s take a look at each step in detail with pictures. <\/p>\n<p><strong>Step1\/2:<\/strong> Install the XML Publisher tool.<\/p>\n<p>After the tool installation, we can see additional tabs in Microsoft word.<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_2.JPG' title='xml_2.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_2.JPG' alt='xml_2.JPG' \/><\/a><\/p>\n<p><strong>Step3:<\/strong> Design the Layout in Microsoft word in RTF. (This layout is about how you want to generate your report). You can add all types of  fonts, colors, table logos, Barcode, pictures etc.<\/p>\n<p><strong>Step4:<\/strong> Create a source to generate the XML Data. In our case this can be a Concurrent Program for Oracle Reports as shown below.<\/p>\n<p>1.\tBy creating an Oracle Report we can elimate the need to do any formatting.<br \/>\n2.\tMove the file to respective APPL_TOP and register the report as concurrent Program<br \/>\n3.\tAbove 2 steps are  required if you want to create new report, but in case you want to convert existing Oracle report into XML Publisher report, query the concurrent program <\/p>\n<p>Concurrent Program Responsibility&#8211; > Application Developer &#8211;> Navigation &#8211;> Concurrent program <\/p>\n<p>Query for a Report, as shown in the example below<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_3.JPG' title='xml_3.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_3.thumbnail.JPG' alt='xml_3.JPG' \/><\/a><\/p>\n<p>Rename the concurrent program name and Change the Format from Text to XML.<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_4.JPG' title='xml_4.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_4.thumbnail.JPG' alt='xml_4.JPG' \/><\/a><\/p>\n<p>Attach New report with Responsibility.<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_5.JPG' title='xml_5.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_5.thumbnail.JPG' alt='xml_5.JPG' \/><\/a><\/p>\n<p>Run the Report. Report will generate the XML Output, save the file on the Window client.<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_6.JPG' title='xml_6.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_6.thumbnail.JPG' alt='xml_6.JPG' \/><\/a><\/p>\n<p><strong>Step5:<\/strong> Open the layout designed in Step 3 and load the XML data into Layout. <\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_7.JPG' title='xml_7.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_7.thumbnail.JPG' alt='xml_7.JPG' \/><\/a><\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_8.JPG' title='xml_8.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_8.thumbnail.JPG' alt='xml_8.JPG' \/><\/a><\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_9.JPG' title='xml_9.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_9.thumbnail.JPG' alt='xml_9.JPG' \/><\/a><\/p>\n<p>Map the Layout with the data. (Map the XML data generated in Step 4 with the Layout designed in Step 1)<\/p>\n<p><strong>Step6:<\/strong> Register the XML Data definition and XML Template with Oracle application.<\/p>\n<p>Responsibility &#8211;> XML Publisher Administrator <\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_11.JPG' title='xml_11.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_11.thumbnail.JPG' alt='xml_11.JPG' \/><\/a><\/p>\n<p>Navigation &#8211;> Templates<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_12.JPG' title='xml_12.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_12.thumbnail.JPG' alt='xml_12.JPG' \/><\/a><\/p>\n<p>Register the data Definition (Please note : Data definition Code should be same as concurrent program Short name)<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_13.JPG' title='xml_13.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_13.thumbnail.JPG' alt='xml_13.JPG' \/><\/a><\/p>\n<p>Register the Template (Please Note : Template Code should be same as concurrent program Short name)<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_14.JPG' title='xml_14.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_14.thumbnail.JPG' alt='xml_14.JPG' \/><\/a><\/p>\n<p><strong>Step7:<\/strong> Run the report (Please note the Layout Name needs to be  the same XML Template, registered above)<\/p>\n<p><a href='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_15.JPG' title='xml_15.JPG'><img src='https:\/\/www.ibizsoftinc.com\/blogs\/wp-content\/uploads\/2008\/02\/xml_15.thumbnail.JPG' alt='xml_15.JPG' \/><\/a><\/p>\n<p>Final output will show up in the same format designed using MS Word (as discussed above). <\/p>\n<p>Contact us at support@ibizsoftinc.com for any support or consulting requirements. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>After having worked with Oracle Reports in the last so many years, I have found that Oracle Reports is not a developer friendly tool and formatting of report&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-58","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.ibizsoftinc.com\/blog\/wp-json\/wp\/v2\/posts\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ibizsoftinc.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ibizsoftinc.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ibizsoftinc.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ibizsoftinc.com\/blog\/wp-json\/wp\/v2\/comments?post=58"}],"version-history":[{"count":0,"href":"https:\/\/www.ibizsoftinc.com\/blog\/wp-json\/wp\/v2\/posts\/58\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ibizsoftinc.com\/blog\/wp-json\/wp\/v2\/media?parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ibizsoftinc.com\/blog\/wp-json\/wp\/v2\/categories?post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ibizsoftinc.com\/blog\/wp-json\/wp\/v2\/tags?post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}