Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Tuesday, April 16, 2013

Oracle XML Publisher


why we are going for xml publisher instead we are having oracle reports because of these advantages
1) reduce complexity
2) reduced cost
3) development productivity
4) rich formatted reports
normally we go for layout in reports 6i but now we go for xml publisher and remaining is the same procedure
steps to develop a xml publisher report and register it as a concurrent program
1) develop the report as .rdf file as per the client requirement but no need of layout
go to data model and write the query
2) save the .rdf file
3) open the ms word application and design the layout enter the labels(boiler plate text )like
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrp-9Xv2WpHoClsfXMwOMZ2EUwslmA2RvqzX2Y19oY83Iq5UXP-pW2UvKEExpsAhffJxeYptJLWnl4fTqYwqruTwJpnRUY5o26N__BHzjrRj8MuBrSk_8Gopl2_czFAd9NTn8a4-XfPrQ/s320/1.JPG
4)take the text formfield into the begin space , double click on it and enter the name,select the button called "add help text" and enter the following code
note: g_vendor_id nothing but report builder guery group name
5) Take the text form field into the place,double click there and enter the name,select the button called "add help text" and enter the following code
< ? vendor_id ? >------to dispaly vendor_id
Repeat the same process for the remaining columns
6) Take the text formfield into the place and enter the following code for end
< ? end for-each ? > ---- to end the repeating frame
7) Save the word fiel with extension as .rtf (rich text format)
8) Now we have to register both the .rdf and .rtf files
9) Register the rdf file as a concurrent program by using standard process only change is the concurrent program format is XML
10) Copy the concurrent program name
11) Now go to xml publisher administrator
12) Select the data definition form from the xml publisher responsibility
13) Select the button called create data definition and enter the following fields
Name: any name
Application: oracle purchasing
Code: concurrent program short name
Start-date: today date
14) Select apply button and remember the data definition name
15) select the template tab and select create template button enter the following
Name: any name
Code: concurrent program short name
Data definition: data definition name what ever you have created
Start date: today date
Type: rtf
File: browse and select the .rtf that you developed
Language: English
Territory: united States
16) Select the apply button
17) Go to responsibility and submit the concurrent program from SRS window, when we select the program in SRS window it will automatically select the template we can find that in the field called layout
18) Submit button --> find --> view report

No comments:

Post a Comment