How do I register an XML Publisher report in Oracle Apps?

Set the Oracle Reports Report Output to XML

Table of Contents

Log in to your E-Business Suite instance.
Open the System Administrator responsibility.
Click the Define link from Concurrent: Program.
Click Run, if the Warning – Security window is displayed.
The Concurrent: Programs window appears.
In the Short Name field, enter ARXCOBLX.

What triggers are supported in data template?

There are two different triggers supported by Data Template:

Before Trigger.
After Trigger.

What is XML bursting?

XML Bursting can be used to split one XML File into multiple XML Blocks. These individual xml blocks can then be used to generate reports and even use different layouts. You can also deliver the reports to multiple destinations based on a XML Element.

What is XML bursting in Oracle Apps?

How do I create an XML report?

XML Publisher Report from XML Data Template

Create a RDF or SQL or PL/SQL procedure.
Register the RDF or SQL or PL/SQL report as a concurrent program and set the output to XML.
Run the above report and get the output and save it as a XML file.
Use the XML data in building the Template using Microsoft Word.

What is XML data template format?

The data template is the method by which you communicate your request for data to the data engine. It is an XML document whose elements collectively define how the data engine will process the template to generate the XML. The data engine supports the following functionality: Single and multiple data queries.

What is XML Publisher report bursting program?

How do I view an XML report?

If all you need to do is view the data in an XML file, you’re in luck. Just about every browser can open an XML file. In Chrome, just open a new tab and drag the XML file over. Alternatively, right click on the XML file and hover over “Open with” then click “Chrome”.

What is burst report?

Bursting is the process of running a report once and then dividing the results for recipients who each view a subset of the data. For example, salespeople in different regions each need a report showing the sales target for their country or region.

How do you use burst in XML Publisher?

You need to submit the “XML Publisher Report Bursting Program” Concurrent program after the XML Publisher Report is completed. You can either manually Submit the program or use the below SQL Code Snippet in the After Report Trigger to submit the bursting program once the XML Publisher Report is completed.