XML Publisher using a Data Template and XDODTEXE
Create a concurrent program: Use the output format as XML
Define a Data Definition for the concurrent program:
Concurrent program short name and Data definition code has to be same.
Create the data template file and upload it while defining in the data definition
Save the output as .XML file:
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
XML Publisher Concurrent program - XMLP
In this blog post I will detail the step by step process of developing a XML publisherreport using an RDF type report concurrent program in oracle apps.
· The XML data output of the concurrent program will look like this pic below
· Save this XML data file as filename.xml say FNDWRR.xml
The XML publisher windows desktop patch has to be applied in you PC before developing the XML template
Overview
• XML Publisher is a template based publishing solution by Oracle which allows us to create visually rich documents with numerous formatting options. (Available in ver.11.5.10)
• XML Publisher makes use of the data retrieved from Reports 6i.
• The template, designed by the developer is used as the layout for the report.
• The template will contain the layout with tags that are mapped to the data model of the report.
• At runtime the data from reports is merged onto the designed template to produce the final report.
Here it goes:
Before we see the step by step process, I will brief the main points:
· Create a report and register it as Concurrent Program of type XML
· Build a Data Definition & XML Template using XML Publisher
· Create a relation between the XML Template & Concurrent Program
Develop a RDF Report concurrent program in oracle apps:
1. Develop a RDF report and register it in oracle apps
· Develop the Report (Report Name: Sample XML Report) Data model
· Develop the Report Layout model
· Define the RDF executable
· Assign this concurrent program to a responsibility
The RDF report concurrent program is complete, now we have to get the XML data file from the concurrent program and create the .xml file:
2. Run the report from a responsibility after changing the output format of the concurrent program to XML.
· The XML data output of the concurrent program will look like this pic below
If you map the oracle report data model and the xml data file. It will look like this
Create the .rtf file. Before you do this, check whether XML publisher desktop patch is applied in your local machine. check the blog post for installing the XML publisherdesktop patch:
http://oracleapps4u.blogspot.com/2011/04/installing-oracle-bi-publisher-xml.html
http://oracleapps4u.blogspot.com/2011/04/installing-oracle-bi-publisher-xml.html
3. Load the XML data file to MS Word and save it as .rtf file
· Using table wizard, form the template layout
If you map the xml data file to the word template. It will look like this
We can develop the template layout with out the table wizard, by marking up the text form fields with the corresponding tags.
11. Insert a Text Form Field from the Forms tool bar (ViewàToolbarsà Forms)
2. Place the Text Form field in a position where you desire.
3. Double click on the form fieldàClick on the Add Help Text button.
4. Go to the Status Bar Tab and type your tag in the text field available.
It will look like this
A Bit of XML publisher
1. Go to “XML Publisher Administrator” Responsibility and define the XML Data Definition & XML Template. Also create a relation between the XML Template and the concurrent program.
· Create the data definition
Define the values as below:
Name: Sample XMLP Report – XML Output (Any Unique name in theApplication)
Application: Receivables (Any Application)
Code: XXSMPRPT (This should be same as the Concurrent program short name)
Start Date: Leave default (sysdate)
· Create the template
Define the values as below:
Name: Sample XMPL Report Template (Any Unique name in theapplication)
Application: Receivables (Any Application)
Data Definition: Sample XMLP Report – XML Output (This should be same as the XMLP Data Definition Name)
Code: XXSMPTMP (Any Unique name)
Start Date: Leave Default (sysdate)
Type: RTF
Default Output Type: PDF (As your wish)
· Create relation ship between the XML Template and the concurrent program
In the XML Data Definition the Data Definition code should be same as the concurrent program short name. As the XML Template has the XML Data Definition name, this actually creates a relationship between the XML Template and the concurrent program.
Concurrent program
|
XML Data Definition
|
XML Template
|
Code: XXSMPRPT
|
Code: XXSMPRPT
| |
Name: Sample XMLP Report – XML Output
|
Name: Sample XMLP Report – XML Output
|
No comments:
Post a Comment