Oracle EBS Standard Reports by Module and Sample XML for BI Publisher

Run a standard report and get sample XML

1. 1Log in with a responsibility for the module and choose View > Requests, then Submit a New Request, and select Single Request.
2. 2Search the program name, enter the parameters, and submit. If it is missing, your request group does not include it; ask an administrator to add it.
3. 3Check the output in View > Requests and confirm the output format. For BI Publisher reports, the program generates XML first and then applies a template.
4. 4To get raw XML, run the program with output format XML where the program allows it, or use the XML Publisher Administrator tools to retrieve data for a data definition, and download the output file.
5. 5Save the XML to a file, open Word with the BI Publisher Desktop add-in, and use Insert > Sample XML to load it.
6. 6Build the template with fields, tables and groups from the XML, then upload it as an RTF or Excel template in XML Publisher Administrator under the matching data definition.
7. 7Submit the program again with the template and check layout, totals and page breaks.

What sample XML looks like

<?xml version="1.0" encoding="UTF-8"?>
<DATA_DS>
  <P_ORG_ID>204</P_ORG_ID>
  <G_ORDERS>
    <ORDER_NUMBER>10045</ORDER_NUMBER>
    <CUSTOMER_NAME>Acme Industrial</CUSTOMER_NAME>
    <ORDER_DATE>2026-09-14</ORDER_DATE>
    <G_LINES>
      <LINE_NUMBER>1</LINE_NUMBER>
      <ITEM_CODE>AB-1001</ITEM_CODE>
      <ORDERED_QTY>25</ORDERED_QTY>
      <UNIT_PRICE>112.50</UNIT_PRICE>
    </G_LINES>
  </G_ORDERS>
</DATA_DS>

Common pitfalls

• !Designing a template on made-up XML whose structure differs from the real data.
• !Forgetting that the report is not in the responsibility's request group.
• !Editing a delivered template in place instead of copying it.
• !Using only one or two sample rows, then failing on long text or empty values.
• !Changing layouts in production without testing and a rollback copy.