Home » Fusion Middleware & Colab Suite » Business Intelligence » BI Publisher Report (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production)
BI Publisher Report [message #674975] Tue, 26 February 2019 15:40
vharish006
Messages: 64
Registered: August 2015
Location: Chicago
Member
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:request select="/XXPQ_EDI_INV_STS_RPT/LIST_XXPQ_EDI_INV_STS_RPT">


<xapi:delivery>


<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">

<![CDATA[
<html>
    <body>
<p>Hi,</p>

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

<p>Thank You.</p>
</body>
     </html>
]]>
</xapi:message>

</xapi:email>

</xapi:delivery>


<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>

</xapi:document>

</xapi:request>

</xapi:requestset>
Previous Topic: MddsException when consuming WebService on Data Model
Next Topic: custom report end total
Goto Forum:
  


Current Time: Sun Jul 21 18:40:22 CDT 2019