Send BI Publisher XML file in an email

[pcongi1969]

Has anyone sent (or have an idea) the XML file produced in a BI Publisher Report in an email as an attachment?

 

[Abhishek Chhajer]

This looks similar to UBE output.
You can access the print Queue from Report End Event and attach the XML in Print Queue in email.

 

[jileto]

Has anyone sent (or have an idea) the XML file produced in a BI Publisher Report in an email as an attachment?

Just found this Oracle doc while researching other stuff... https://support.oracle.com/epmos/faces/DocContentDisplay?id=964292.1

You create a XSL template - the document refers to it as an "Identity" XSL. The XSL is coded to produce a copy of the XML as output (something like multiplying a number by 1 produces the same number). Use that XSL template in the report def and set the report def to email the output.

The Oracle document has a sample XSL. I'm pasting it below...

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xslutput method="xml" version="1.0" encoding="UTF-8" indent="yes" omit-xml-declaration="no"/>
<!-- Identity template -->
<!-- from http://www.w3.org/TR/xslt section 7.5 -->
<xsl:template match="@*|node()">
<xsl:if test=". != '' or ./@* != ''">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:if>
</xsl:template>
</xsl:stylesheet>