Use a bursting control file attached to the BI Publisher Data Definition.
For example:
<?xml version="1.0" encoding="UTF-8" ?> <!-- --> <!-- ######################################################################################### --> <!-- Application : General Ledger --> <!-- Module : GL004 --> <!-- Author : David Taylor --> <!-- Date : 07-NOV-2011 --> <!-- 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-FEB-2011 David Taylor 1.0 R12 version created, based on GL075 v1.0 --> <!-- 27-FEB-2015 David Taylor 2.0 Changed xsl-fo to xslfo following 12c dbase upgrade --> <!-- --> <!-- ######################################################################################### --> <!-- --> <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi"> <xapi:request select="/C4GL004/FILESET"> <xapi:delivery> <xapi:filesystem id="file1" output="${OUT_DIR}/HSP_TEXT_CELL_VALUE.xls" /> </xapi:delivery> <xapi:document output-type="excel" delivery="file1" > <xapi:template type="xslfo" location="xdo://C4GL.C4GL004_01.en.00" /> </xapi:document> <xapi:delivery> <xapi:filesystem id="file2" output="${OUT_ARCH_DIR}/HSP_TEXT_CELL_VALUE.xls.${REQUEST_ID}" /> </xapi:delivery> <xapi:document output-type="excel" delivery="file2" > <xapi:template type="xslfo" location="xdo://C4GL.C4GL004_01.en.00" /> </xapi:document> </xapi:request> </xapi:requestset>