Oracle XML Publisher Bursting Sample Program


<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
    <xapi:request select="/../../LIST_G_INVOICE/G_INVOICE">
         <xapi:delivery>
              <xapi:filesystem output="/server/outputfolder/${TRX_NUMBER}.pdf" id="1234" />
         </xapi:delivery>
     <xapi:document output-type="pdf" delivery="1234">
        <xapi:template type="rtf" location="xdo://AR.INVOICE.en.US/?getSource=true">
        </xapi:template>
      </xapi:document>
   </xapi:request>
</xapi:requestset>

Here we are trying to send the PDF output to Server Output Folder. 

xapi:delivery - Explains where the output should be delivered
xapi:filesystem - explains the output is destined to filesystem
xapi:template - specifies the template shortcode prefixed with app short code, for eg: AR.INVOICE - AR-app short code and INVOICE is the xml template short code.

location="xdo://AR.INVOICE.en.US/?getSource=true"

Above line is very important, it takes care of pulling the latest template uploaded in the XML Publisher Administrator responsibility, you don't need to put your template hanging in any UNIX servers.

en - Language
US - Territory code (when you create template definition, you make sure that you select United States or other country)

The same above example holds good for sending the output through email, fax, etc.,







No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...