• Posted in: Home
• 22
• Author: admin

HeMvZbjDi4/UBudVFAhlVI/AAAAAAAABBs/hJSzsPrWnOw/s1600/Download_BIPublisher.png' alt='Install Bi Publisher Windows' title='Install Bi Publisher Windows' />Log in to Oracle BI Publisher. In the Get Started section of the Home page, click the Download BI Publisher Tools menu, and select Template Builder. The Product Key Card makes installing Microsoft Office 2010 fast and easyno disks needed. Just follow these steps. RRkqiAdZY/VZzS52J2sfI/AAAAAAAAC1o/0Xq7qAd5w_w/s1600/step16.png' alt='Install Bi Publisher Windows' title='Install Bi Publisher Windows' />XML Publisher BI Publisher. Overview Oracle XML Publisher is a template based publishing solution delivered with the Oracle E Business Suite. It provides a new approach to report design and publishing by integrating familiar desktop word processing tools with existing E Business Suite data reporting. At runtime, XML Publisher merges the custom templates with the concurrent request data extracts to generate output in PDF, HTML, RTF, EXCEL HTML, or even TEXT for use with EFT and EDI transmissions. Basic Need for XML Consider the following scenarios. Word.jpg' alt='Install Bi Publisher Windows' title='Install Bi Publisher Windows' />We have a RDF report with tabular layout which prints in English. New Requirements User. Report needs to be printed in Spanish. User. 2 wants the Same Report needs to be printed in chart format. User. 3 wants the Same Report output in Excel. User. 4 wants the Same Report output to be published on intranet or internet. User. 5 wants the Same Report output eliminating few columns and adding few other. A new RDF needs to be created for each requirement stated above or an existing RDF needs to be modified with huge amount of effort but whereas with XML Publisher it can be done very easily. XML Publisher separates a reports data, layout and translation components into three manageable pieces at design time at runtime all the three pieces are brought back together by XML Publisher to generate the final formatted, translated outputs like PDF, HTML, XLS and RTF. In future, if any there is any change in layout we just need to addmodify the Layout file. Data Logic Data extracted from database and converted into an XML string. Layout The layout templates to be used for the final output are stored and managed in the Template Manager. Translation The translation handler will manage the translation that is required at runtime. In brief the steps are as follows a. Create a procedure and register it as Concurrent Program so that we write XML  tags  into output file. Build a Data Definition XML Template using XML Publisher. Create a relation between XML Template Concurrent Program and run the concurrent program. Requirements for XML Data Object Reports. Oracle XML Publisher Release 5. Template Builder 5. Template builder is used to create templatelayout for your report. Usually Template builder 5. Oracle XML Publisher patch itself but you can also download it from http edelivery. First select Oracle Application Server Products then select your platform and then locate the Oracle XML Publisher Release 5. Media Pack v. 1 for Microsoft Windows, as below Download the Desktop edition from the below When you download the XML Publisher Desktop edition you get a Zip file containing setup for  XML Publisher Desktop Install Shield, this installs some components into Microsoft Word. After installing, the Word Add Ins is attached to the menu bar for the word document. This menu lets you attach an XML data source document, add the XML data to your template, set preferences and preview the output. In detail along with screenshots A concurrent program is written that spit out an XML file as output such concurrent program can be of type SQL or PLSQL or Oracle Report or any other supportable type, provided it can produce a XML output. Here I have a very simple PLSQL procedure, which fetch the records from AR tables and write the output in xml tags. CREATE OR REPLACE PROCEDURE APPS. DemoXMLPublisher errbuf VARCHAR2,retcode NUMBER,vcustomerid VARCHAR2. Cursor to fetch Customer Records. CURSOR xmlparent. SELECT   customername, customerid. FROM      racustomers. WHERE   customerid tonumbervcustomerid. Cursor to fetch customer invoice records. CURSOR xmldetailpcustomerid. NUMBER. SELECT ra. FROM  racustomertrxall ra, arpaymentschedulesall aps. WHERE  ra. shiptocustomerid pcustomerid. AND aps. customertrxid ra. AND      ROWNUMlt 4. First line of XML data should be lt FNDFILE. PUTLINEFNDFILE. OUTPUT,lt xml version1. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt CUSTOMERINFO. FOR vcustomer IN xmlparent. For each record create a group tag lt PCUSTOMER at the start. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt PCUSTOMER. Embed data between XML tags for ex lt CUSTOMERNAME ABCDlt CUSTOMERNAME. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt CUSTOMERNAME vcustomer. CUSTOMERNAME. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt CUSTOMERID vcustomer. CUSTOMERID. FOR vdetails IN xmldetailvcustomer. For  customer invoices create a group tag lt PINVOICES at the start. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt PINVOICES. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt CUSTOMERTRXID. CUSTOMERTRXID. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt CUSTOMERID. CUSTOMERID. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt INVOICENUMBER. INVOICENUMBER. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt AMOUNTDUEORIGINAL. AMOUNTDUEORIGINAL. Close the group tag lt PINVOICES at the end of customer invoices. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt PINVOICES. Close the group tag lt PCUSTOMER at the end of customer record. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt PCUSTOMER. Finally Close the starting Report tag. FNDFILE. PUTLINEFNDFILE. OUTPUT,lt CUSTOMERINFO. FNDFILE. PUTLINEFNDFILE. Entered into exception. END DemoXMLPublisher. Create an executable Sample. Xml. Report for the above procedure DemoXMMLPublisher. Go to Application Developer Responsibility Concurrent Executable. Create a new concurrent program Sample. Xml. Report that will call the Sample. Xml. Report executable declared above. Make sure that output format is placed as XML. Go to Application Developer Responsibility Concurrent Program. Make sure we declare the parameters for the procedure. Add this new concurrent  program with Receivables request group. Either using the following code or through below application screen. DECLARE. FNDPROGRAM. PROGRAMSHORTNAME  CUSTXMLSAMPLE. PROGRAMAPPLICATION AR. REQUESTGROUP       Receivables All. GROUPAPPLICATION   AR. Object already exists. Go to System Administrator Responsibility Security Responsibility Request. From the receivables responsibility depends on which responsibility we added our concurrent program here it is receivablesFrom the menu View Requests Submit A New Request Single Request. Note The layout field is blank as we havent attached any Template or layout to this concurrent program yet. By submitting the above request we get the output in xml depending on procedure as follows lt CUSTOMERINFO lt PCUSTOMER lt CUSTOMERNAME UNIV OF CHICAGO HOSPlt CUSTOMERNAME lt CUSTOMERID 1. CUSTOMERID lt PINVOICES lt CUSTOMERTRXID 9. CUSTOMERTRXID lt CUSTOMERID 1. CUSTOMERID lt INVOICENUMBER 2. INVOICENUMBER lt AMOUNTDUEORIGINAL 8. AMOUNTDUEORIGINAL lt PINVOICES lt PINVOICESlt CUSTOMERTRXID 9. CUSTOMERTRXID lt CUSTOMERID 1. CUSTOMERID lt INVOICENUMBER 2. INVOICENUMBER lt AMOUNTDUEORIGINAL 3. Delete Software Distribution Folder Windows 7 there. AMOUNTDUEORIGINAL lt PINVOICES lt PINVOICES lt CUSTOMERTRXID 8. Dazzle Devices. CUSTOMERTRXID lt CUSTOMERID 1. CUSTOMERID lt INVOICENUMBER 2. INVOICENUMBER lt AMOUNTDUEORIGINAL 6.