How to create XML publisher Report with parameter in Oracle apps R12 using data template Approach

Code:

Steps Involved:
how to create XML publishers report with data template approach

1. Using Pl SQL
2. Using Report Buileder

We are creating thorough data template approach

Lets start
Steps involved

1.Create data template
2.Go to XML publishers and Create data definition and attach datatemplate in .XML format
6.Run the program and got the XML file
7.Using XML File create RTF template and attach in template XML publishers
8.Run the Program

XXFIRST_REPORT_DATA_TEMPLATE ===Report Name ====p_deptno Parameter

===============================================================================

Finally report competed

Let me know in case any confustion will try to explain

i will attach this step in my blog and link will be share in description

Thanks for watching...

Tags:
xml publisher data template multiple queries,
grouping in xml publisher data template,
xml publisher data template with lexical parameter,
formula column in xml data template,
steps to create xml publisher report in oracle apps,
sum function in xml data template,
how to send xml publisher report by email to users,
the file should be in xml-data-template format,

[imranimmi]

All good but that would be extremely helpful if you could explain the things. Process is crystal clear but than showing the process explanation would be more beneficial and easy to understand. Thank you very much

[vaibhavsingh]

How I can use to and from date as input parameter and compare it by between operator

[venkatrambabu]

At 4:10 min how can i know my executable name any one help me..?