1 Reply Latest reply on Jun 19, 2013 9:04 PM by pontiacfan1

    Excel file is blank when bursting!

    pontiacfan1

      Hello All,

       

      RDBMS : 11.2.0.3.0

      Oracle Applications : 12.1.3

       

      I'm new to busting and I'm having a problem.  When my output-type is Excel the file that is attached to the email is completely blank!  If I simply switch the output-type to pdf, my data is there!

       

      Anyone know what's going on here?

       

      Here is my bursting control file, I have sanitized some of the data for public viewing..

       

      Any help is greatly appreciated!

       

      {code}

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

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

         <xapi:request select="/MWACIIER/LIST_G_INTERFACE_CONTROL/G_INTERFACE_CONTROL/LIST_G_ERRORS/G_ERRORS">

            <xapi:delivery>

               <xapi:email server="00.000.0.00" port="25"

                           from="errors@blah.com" reply-to="errors@blah.com">

                 <xapi:message id="123" to="someone@blah.com" cc="" attachment="true" content-type="text" subject="Test Bursting">

      <body>

      The attached Error Report is ready for you to review.<br /><br />

      Text here!<br />

      More text here!<br />

      </body>

                 </xapi:message>

               </xapi:email>

            </xapi:delivery>

            <xapi:document output="test2.xls" output-type="excel" delivery="123">

            <xapi:template type="rtf" location="/ua4001/oracle/MFSGUAT/apps/apps_st/appl/xbol/12.0.0/xml/MWACIIER.rtf"></xapi:template>

          </xapi:document>

         </xapi:request>

      </xapi:requestset>

      {code}

        • 1. Re: Excel file is blank when bursting!
          pontiacfan1

          Here is my issue, it's related to the mail tool I'm using to look at the attachment...

           

           

           

          You use Microsoft Outlook Web Access (OWA) 2007 to access a
          mailbox on a computer that is running Microsoft Exchange Server 2007 Service
          Pack 1. When you download an .xls file attachment and then try to open the
          file, the downloaded file is empty.

           

           

           

           

           

          This problem occurs if the .xls file contains XML data. In
          Exchange Server 2007, if a file that contains XML data is attached to a
          message, the XML content in files is removed when you open or save the
          attachment by using OWA.

           

           

           

           

           

          To resolve this problem, install Update Rollup 6 for Exchange
          2007 Service Pack 1.



          For more information about Update Rollup 6 for Exchange Server 2007 Service
          Pack 1, see the following Exchange Help topic:

           

           

          Description of
          Update Rollup 6 for Exchange Server 2007 Service Pack 1

           

           

          http://go.microsoft.com/fwlink/?LinkId=152555)

           

           

          For more information about how to obtain the latest Exchange
          service pack or update rollup, see the following Exchange Help topic: