BI Publish an Output File to the File System

Use a bursting control file attached to the BI Publisher Data Definition.

For example:

<?xml version="1.0" encoding="UTF-8" ?>

<!--                                                                                           -->

<!-- ######################################################################################### -->

<!-- Application : XX General Ledger                                                           -->

<!-- Module      : C4GL075                                                                     -->

<!-- Author      : Oracle Apps Tech Taylor                                                                -->

<!-- Date        : 03-June-2013                                                                 -->

<!-- Description : XML Publisher Bursting Control File to publish a HYPERION data extract, in  -->

<!--               MS Excel format, to the directory /erp/FTP/HYPERION/out                     -->

<!--                                                                                           -->

<!-- Modification History                                                                      -->

<!-- ====================                                                                      -->

<!-- Date      Name              Ver  Comments                                              -->

<!-- ===========  ================  ===  ===================================================== -->

<!-- 03-June-2013  Oracle Apps Tech       1.0  Created.                                              -->

<!--                                                                                           -->

<!-- ######################################################################################### -->

<!--                                                                                           -->

<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi">

  <xapi:request select="/XXGL075/FILESET">

    <xapi:delivery>

      <xapi:filesystem id="file1" output="/erp/FTP/HYPERION/out/HSP_TEXT_CELL_VALUE.xls" />

    </xapi:delivery>

    <xapi:document output-type="excel" delivery="file1" >

      <xapi:template type="xsl-fo" location="xdo://XXGL.C4GL075.en.00" />

    </xapi:document> 

    <xapi:delivery>

      <xapi:filesystem id="file2" output="/erp/FTP/HYPERION/out/archive/HSP_TEXT_CELL_VALUE.xls.${REQUEST_ID}" />

    </xapi:delivery>

    <xapi:document output-type="excel" delivery="file2" >

      <xapi:template type="xsl-fo" location="xdo://XXGL.XXGL075.en.00" />

    </xapi:document>

  </xapi:request>

</xapi:requestset>