XMLP Format

XMLP format creates an XML file suitable for use with Oracle BI Publisher. Oracle BI Publisher expects the XML data file to consist of a root node with a set of related elements below.

This example shows the four rows of data returned for a simple query MSGSET that has two columns. The SQL for this query is:

SELECT A.MESSAGE_SET_NBR, A.DESCR
  FROM PSMSGSETDEFN A

Example XMLP File:

<?xml version='1.0'?>
<query numrows="4" queryname="MSGSET" xmlns:xsi="http://www.w3.org/2001/
XMLSchema-instance" 

xsi:noNamespaceSchemaLocation="">
  <row rownumber="1">
    <MESSAGE_SET_NBR>1</MESSAGE_SET_NBR>
    <DESCR>PeopleTools Message Bar Items</DESCR>
  </row>
  <row rownumber="2">
    <MESSAGE_SET_NBR>2</MESSAGE_SET_NBR>
    <DESCR>PeopleCode</DESCR>
  </row>
  <row rownumber="3">
    <MESSAGE_SET_NBR>3</MESSAGE_SET_NBR>
    <DESCR>General Tools Messages</DESCR>
  </row>
  <row rownumber="4">
    <MESSAGE_SET_NBR>4</MESSAGE_SET_NBR>
    <DESCR>Help Processor</DESCR>
  </row>
</query>