INTRODUCTION

•Integrated in ERP suite.

•Consistent User Interface.

•Report in multiple formats.

•Language and locale options.

•Faster deployment.

•Reduced maintenance.

•Focus on business requirements.

•High productivity.

•Focus on data provisioning.

ADVANTAGES

Design Time

•Create any program which can be setup as Concurrent Program and can produce XML output OR Create the RDF file (Oracle has a mechanism to covert the RDF output to XML)

•Register the Program as a Concurrent Program in Oracle Applications with the output type as XML

•Run the Concurrent Program and save the XML output on to our desktop.

•Develop a RTF Template using MS Word. (use the XML file to preview the output)

•Create a Data Definition in Oracle Applications for the Conc. Program

•Create a template definition. Register the RTF Template in Oracle Applications against the Data Definition and Conc. Program

•Add desired Translations to the RTF template in Oracle Applications

HOW DOES IT WORK?

Run Time

•Select the XML Publisher Program in the Standard Request Submission Window, choose the parameters.

•Click on View options button-> Choose the desired Language and Territory in the Language Settings (if the program has multiple translations)

•Choose the desired Template Name from the Options Button

•Also choose the desired Output Format for Template (PDF, HTML, EXCEL, RTF)

•Submit the Request.

•Once the Request is completed, View the output from View Output button.

•If we are printing the output to specific printer, The Printer has to be registered in Oracle Application and it should be PASTA enabled.

•Download the Template Builder (Patch# for XMLP Version 5.6.2 is 5027437) and Install on your desktop

•Once it is installed the following toolbar would appear in the MS Word

•Design your Report Layout in the MS Word, Use the formatting features of your word processing application. (This would be static data such as labels, logo, drawings etc)

•Use the XML Publisher simplified tags, for populating the Dynamic Data (coming from the Concurrent Program XML) in the Word file. Save the file as RTF.

•Load the XML File using the Template Builder Menu Navigation: Data Load XML Data

•Preview the Output using the Template Builder Menu Navigation: Preview PDF

Place holders :

<?XML element tag name?>

eg.; <?INVOICE_NUMBER?>

Groups :

<?for-each:XML group element tag name?>

<?end for-each?>

e.g.; <?for-each:G_LINE_NUMBER?>

<?end for-each?>

Conditions:

<?if:condition?>

<?end if?>

e.g.; <?if: CF_LINE_PLUS_TAX>10 ?> Yes

<?end if?>

RUN TIME: RUN THE REPORT – VIEW OUTPUT

XML Publisher Allows us to attach multiple Translation Files to a single Template, to translate the Labels in the template layout into multiple Languages.

More Information on how to use the Language Translation is described in the below attached document

We can create Barcodes in XML Publisher Reports by using the Barcode fonts.

Client has created the following Custom utility functions to

overcome the Challenges faced while Implementing XML Publisher

•For Using XML Publisher Reports in Request Sets

•Adding Start and Stop bit characters for Barcodes

•Emailing the XML Publisher Output from RDF file

•Adding Emailing feature to XML Publisher reports using Request Sets

For more details on using the above features, refer the following

attached MD70 document

References