How to create XML publisher Report with parameter in Oracle apps R12 using data template Approach
Code:
https://youngindiayoutube.blogspot.co...
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
3.executable -XDODTEXE
4.concurrent program
5.attach a reqeust group -----OM Concurrent Programs
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,
