Bursting: java.io.FileNotFoundException (No such file or directory)

Anilkumar Dasi

Summary

Bursting: java.io.FileNotFoundException (No such file or directory)

Content

Hi All,

My Bursting program completes in error with the exception

--Exception

/slot/ems3321/appmgr/apps/apps_st/appl/xdo/12.0.0/temp/1559614.xml (No such file or directory)

java.io.FileNotFoundException: /slot/ems3321/appmgr/apps/apps_st/appl/xdo/12.0.0/temp/1559614.xml (No such file or directory)

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:156)

I set up the temp folder in the administration tab and still i face this issue.

My Control file is as below --

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

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

<xapi:request select="/XXXDPTAXML/LIST_G_TRX/G_TRX">.

<xapi:delivery>

<xapi:filesystem id="outbound_inv_xml" output="/tmp/${CUSTOMER_TRX_ID}.xml" />

</xapi:delivery>

<xapi:document output-type="xml" delivery="outbound_inv_xml" >

<xapi:template type="XSL" location="xdo://XXX.XXXPTAXML.en.US/?getsource=true" />

</xapi:document>

</xapi:request>

</xapi:requestset>

I tried setting up the XDO.cfg file with the system-temp-dir property to /tmp directory and still facing this issue.

Please help in resolving the issue with  bursting.

Thanks

Anil

Brajesh Shukla-95078

The error can come with below reason, you can verify each (ignore if already checked)

1. Please check the physical path exists in Unix application server which you specify under Administration tab. And you should have write access to that folder. It will be great if you can provide screen shot of the path you set

2. specify document tab as below

   <xapi:document output="/tmp/${CUSTOMER_TRX_ID}" output-type="xml" delivery="outbound_inv_xml">

3. Verify that XSL file XXXPTAXML registor under territory US, you can check this by below sql

         

            select TERRITORY from xdo_lobs where lob_code = 'XXXPTAXML';

      if it gives territory as 00 then change template tag as

         

            <xapi:template type="XSL" location="xdo://XXX.XXXPTAXML.en.00/?getsource=true" />

Anilkumar Dasi

Hi Brajesh

1. Please check the physical path exists in Unix application server which you specify under Administration tab. And you should have write access to that folder. It will be great if you can provide screen shot of the path you set

The /temp path exists in the application server and the same is specified in Administration Tab. The Folder has all the access granted.

2. specify document tab as below

   <xapi:document output="/tmp/${CUSTOMER_TRX_ID}" output-type="xml" delivery="outbound_inv_xml">

-- Still the same error

3. Verify that XSL file XXXDPTAXML registor under territory US, you can check this by below sql

i verrified it using the below query

SELECT APPLICATION_SHORT_NAME||'.'||

TEMPLATE_CODE||'.'||

DEFAULT_LANGUAGE ||'.'||

DEFAULT_TERRITORY

FROM XDO_TEMPLATES_VL

WHERE TEMPLATE_CODE like 'XXXDPTAXML'

-- XXX.XXXDPTAXML.en.US

Also, Please let me know if the template tye should be XSL or XSL-XML, tried both but the same error

Thanks

Anil

Brajesh Shukla-95078

This error prompt that template is not getting picked up properly .....Can you specify template type as "xslxml" and try as below

<xapi:template type="xslxml" location="xdo://XXX.XXXPTAXML.en.US/?getsource=true" />