Home » Fusion Middleware & Colab Suite » Business Intelligence » BI Publisher Report (Oracle Database 11g Enterprise Edition Release - 64bit Production)
BI Publisher Report [message #674975] Tue, 26 February 2019 15:40
Messages: 70
Registered: August 2015
Location: Chicago
Hi All,

How do I attach timestamp to my BI publisher output excel file. I want to attach the SYSDATE to the file name that I give in bursting file that will be generated daily.
Is there any specific tag that need to be defined in the bursting file. I gave below in bursting file

<xapi:document delivery="123" output-type="excel" output=" Invoice Status Report_${P_DATE}">

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

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



<xapi:email from="applmgr@hdhdjdj.com" port="25" server="itmail200.aa1.pqe" id="123">

<xapi:message id="123" subject=" Invoice Status Report" content-type="text/html" attachment="true" to="hhardhhdhd@dhdhhd.com" cc="hardhhdhd@dhdhhd.com">


<p>PFA  ProQuest - EDI Invoice Status Report.</p>

<p>Thank You.</p>



<xapi:document delivery="123" output-type="excel" output="Invoice Status Report_${SYSDATE}">

<xapi:template type="rtf" filter="" location="xdo://XXPQCUSAPP.XXPQ_EDI_INV_STS_RPT.en.US/?getSource=true"> </xapi:template>



Previous Topic: MddsException when consuming WebService on Data Model
Next Topic: custom report end total
Goto Forum:

Current Time: Sat Mar 02 04:07:19 CST 2024