add

About Me

My photo
Oracle Apps - Techno Functional consultant

Sunday, August 7

Create XML Publisher Report(With out RDF file)

Required Files:

Template file: XXXX_TEST.rtf
Data Template: XXXX_TEST.xml

Define Concurrent Program
Navigate to System Administrator->Concurrent->Program->Define
Provide folliowing information as shown in the picture.
Program: XML Publisher Test Report
Short Name: XXXX_TEST
Application: Payables
Executable Name: XDODTEXE
Format: XML

Points To Note:
1.Note down short name. We need to use this XML Publisher defintion to refer this CP.
2.Select executable name as "XDODTEXE" if xml data source is data template(XXXX_TEST.xml). Method is Java Concurrent Program. If you are generating xml data using Oracle Reports(RDF), then you must define executable(System Administrator->Concurrent->Program->Executables) for this CP and provide it's name in CP define window. Method will be Oracle Reports in this case.
3.XML Publisher engine needs data input in XML format. So always select format is XML.( Final output will be PDF/RTF/HTML.. as selected by you in report submission.)
4.If you want to see final output in XML format then you need set format type as Text instead of XML.

CP definition looks like this after creation.

Add new CP to the Request Group, then add Request Group to your Responsibilty.

Create Data Definition
Navigate to XML Publisher Administrator->Data Definitions
Click Create Data Definition button.

Provide folliowing information as shown in the picture.
Code: XXXX_TEST
Name: XML Publisher Test Report(your choice)
Application: Payables(your choice)
Click Apply
In the second part of the same page upload file XXXX_TEST.xml as the Data Template.
Click Save.

Points To Note: 1.Value given in the Code field must be same as the short name of the CP 'XML Publisher Test Report'.
2.XXXX_TEST.xml is the data template file which holds Paramters, Data Query, Triggers, Data Structure of the report.

Definition looks like this after creation.


Create Template

Navigate to XML Publisher Administrator->Templates
Click Create Template button.

Provide folliowing information as shown in th picture.
Code: XXXX_TEST(your shoice)
Name: XML Publisher Test Report(your choice)
Application: Payables(your choice)
Type: RTF
Data Definition: XML Publisher Test Report
Upload template XXXX_TEST.rtf.
Click Apply

Template looks like this after creation.


Submit Request
If you want final output in different format(RTF, HTML, etc), click Options button and change the Format type. Default is PDF.

No comments: