This discussion is archived
0 Replies Latest reply: Dec 2, 2013 5:22 AM by Surya Karanam-OC RSS

XML Bursting with template type as "Excel"

Surya Karanam-OC Newbie
Currently Being Moderated

Hi,

Am working on  XML Bursting with template as "rtf" and completed the task successfully.

Got one more requirement with template type as "excel" where am getting some issues.

Designed the excel template using fusion middlewasre concept and attached to the application using XML Administrator Responsibility.

 

Here is my control file.

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

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

<xapi:request select="/ReportName/Immediate Group">

<xapi:delivery>

<xapi:email id="email123" server="${CF_SERVER_ADDRESS}" port="25" from="dd@ff.com" reply-to="${CF_REPLY_TO_ADDRESS}">

<xapi:message id="email123" to="dd@ff.com" cc="" attachment="true" subject="vvvvvvvvvvvvvvvvvv">

----------------

${CF_INSTANCE_NAME}

</xapi:message>

</xapi:email>

</xapi:delivery>

<xapi:document  output="${CUSTOMER_NUMBER}" output-type="excel" delivery="email123">

<xapi:template type="excel" location="xdo://excelname.xls .en.00/?getSource=true">

</xapi:template>

</xapi:document>

</xapi:request>

</xapi:requestset>.

 

The error was as below.

--Exception

/tmp/112713_025738394/5416.xls (No such file or directory)

java.io.FileNotFoundException: /tmp/112713_025738394/5416.xls (No such file or directory)

at java.io.FileInputStream.open(Native Method)

at java.io.FileInputStream.<init>(FileInputStream.java:120)

at java.io.FileInputStream.<init>(FileInputStream.java:79)

at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.zipOutputFiles(JCP4XDOBurstingEngine.java:523)

at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:292)

at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

 

In the application i was registered the template type as Microsoft Excel and in the control file using to bursting the output used template type as "excel" getting the above error.

 

 

 

Please help me on this.

 

Thanks,

Surya.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points