Xml Publisher Report Basics

Steps to Register XML Pub report in Oracle Apps


1] Create the Report(Data Model or we can say the .Rdf file) using Oracle Report Builder.

2] Set the user parameter as p_conc_request_id.

3] Add the default values to the Before Report and After Report triggers(not mandatory)

4] FTP the Report to the Cust_Top/Report/Us.

5] Open the Oracle Apps , go to Sysadmin>Concurrent>Program>Executables, Here we have to create one executable file for that Rdf.

6] Then go to Sysadmin>Concurrent>Program>Define, Here we have to make a Concurrent Program for that Executable. Make sure that the output format must be XML.

7] Goto the Sysadmin>Security>Responsibility>Define. Query for the Xml Publisher Administrator. See the Request Group attached to this.
 Attach the Concurrent Program to this Request Group.

8] Design the template in Ms Word(Using the .Rtf file).

9] Goto responsibility XML PUBLISHER ADMINISTRATOR.
Then Goto HOME>DATA DEFINITION>CREATE DATA DEFINITION and create a new data definition.
Make sure that your Data Definition’s Code should be same as Concurrent Program’s Short Name used by you to create the Rdf file.

10] Now go to XML Publisher Administrator> Home> Template. Create a new template with template type=’Rtf’. Then upload the RTF File by browsing the path.

12] Now go to the Responsibility and run the request