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>
] 
Blog
Search
Help
Members
Register
Login
Home
