Oracle XML Publisher

                                           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

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