Scribd
Upload
476 views5 pages

XML Publisher Report XML Data Template Example

1. Create a concurrent program in Oracle Applications with XDODTEXE as the executable and XML as the output. Define parameters for the SQL query and XML structure. 2. Add the concurrent program to the "All Reports" responsibility group for the Payables application. 3. Create an XML template defining the data query, parameters, data structure, and triggers to execute the report.

Uploaded by

unnikallikattu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
476 views5 pages

XML Publisher Report XML Data Template Example

1. Create a concurrent program in Oracle Applications with XDODTEXE as the executable and XML as the output. Define parameters for the SQL query and XML structure. 2. Add the concurrent program to the "All Reports" responsibility group for the Payables application. 3. Create an XML template defining the data query, parameters, data structure, and triggers to execute the report.

Uploaded by

unnikallikattu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

How to create a simple XDODTEXE XML Publisher Report

1. Navigate to System Administrator->Concurrent->Program->Define and create a new


concurrent program as below with Executable as “XDODTEXE” and output as “XML“.

Then click on parameters button and enter the parameter as below

2. Navigate to System Administrator->Security->Responsibility->Request, query request group


as “All Reports” & application as “Payables“(Its the request group attached to Payables
responsibility).Then add the newly created concurrent program to it.
3. Below is the Data Definition template XML which is created and its explanation.

Data Query : The SQL query with bind parameter specifying the data to be fetched.
Parameters : Definition of each bind parameter defined in the query.
Data Structure : Definition of the Output XML Structure.
Data Triggers : Triggers that should be executed before or after the data query execution.
Triggers are used to either do initialization or do some post query operation.
4. Navigate to XML Publisher Administrator->Home->Data Definitions, click on “Create Data
Definition” button and create Data Definition as below.Data Definition Code should be same as
the Concurrent Program Short name which we created.Then click on Apply button.

Attach the Data DefinitionTemplate XML which we created in step 3.

5. Navigate to Payables, Vision Operations (USA)->Concurrent->Requests and submit the


newly created concurrent program.

Once the program is completed, click on View output button and save the output in XML format.
6. Open MS Word->BI Publisher->Sample XML and load the output XML file which we saved in
previous steps.(Ensure BI Publisher Desktop is installed)
7. Then click on Oracle BI Publisher->All Fields

Above is the report format. Save the document as RTF file (Rich Text Format)

7. Navigate to XML Publisher Administrator->Home->Templates and click on Create Template


button.
Assign the Data Definition template which we created in step 4 to this template and set Output
type as PDF. Also Set the type as RTF and assign the RTF file created in previous step.
Create the Template as below and Apply.

8. Navigate to Payables, Vision Operations (USA)->Concurrent->Requests and once again


submit the newly created concurrent program. Now if you click the output we can see the report
which we created.

You might also like