XMl Publisher Reports Fail with java.io.FileNotFoundException on Temp Directory After Cloning

摘自metalink[1189764.1]

Applies to:

BI Publisher (formerly XML Publisher) -Version 11.5 to 12.0 [Release 11.5 to 12.0]
Information in this document applies to any platform.

Symptoms

After cloning it is not possible to view the XMLoutput for XML Publisher reports.

ERROR
-----------------------
Template code: XLAACCPB01
Template app: XLA
Language: en
Territory: US
Output type: RTF

java.io.FileNotFoundException :  /usr/tmp/ GEBSPRD/xdoVd662pSV0H081910_0326124500.fo (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
at oracle.apps.xdo.common.tmp.TmpFile.createTmpFileJDK118(TmpFile.java:146)
at oracle.apps.xdo.common.tmp.TmpFile.createTmpFile(TmpFile.java:113)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:987)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1659)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:969)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5926)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3458)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3547)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:259)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:172)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Clone environment
2. Run XML Publisher
3. View Output
4. Output only displays the raw xml tags

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot view XML Output on the cloned environment

Cause

The Temporary directory for XML Publisher has not beenmodified after making the clone

Check the setup in the XML Publisher administrator responsibility
XML Publisher Administrator: Properties -> General -> Temporary Directory

Note that the value Post Clone is still the same as the value on the Sourceenvironment

Solution

1) Create a new Temporary Directory on OS level for thecloned environment
2) Make sure that the APPLMGR can Read and Write this directory
3) Setup this new directory for XML Publisher via : XML PublisherAdministrator: Properties -> General -> Temporary Directory
4) Restart the Server
5) Test again with a XML Publisher Report