Hi,
I am working in an implementation project.
I have created a report using XML template and sending emails using XML Bursting. Inside XML bursting, I was using
<xapi:template type="rtf" location="xdo://PO.PO_REPORT.en.00/?getSource=true"/> , it was running fine.
Now under XML Publisher Administrator -> Template -> Under template, I have placed two RTFs, PO_ENG with language as ENglish. and PO_FRENCH with language as FRENCH.
In order to dynamically choose the RTF from this location, I replaced the xml template code as follows,
<xapi:template type="rtf" location="xdo://${TEMP_LOCATION}/?getSource=true"/>
But after including this variable, I am getting the below error,
c:\temp\031114_083555516\SN_PO_89.pdf (The system cannot find the file specified)
java.io.FileNotFoundException: c:\temp\031114_083555516\SN_PO_89.pdf (The system cannot find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at java.io.FileInputStream.<init>(FileInputStream.java:66)
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)
I am choosing the location details from below query,
Select application_short_name||'.'||lob_code||'.'||language|| '.'||territory
INTO l_chr_template_loc
from xdo_lobs
where lob_code = 'XXPO_TEMPLATE'
and file_status = 'E' and xdo_file_type = 'RTF' and language = <input_language>;
As UAT is going on, due to this issue, user are holding the approval for sign off.
I need help to make the variable {CF_LOCATION} to recognize the value and to dynamically apply the location inside the tag.
Thanks,
Senthil