EBS XML报表输出管理器跑请求报错

跑报表时报警告：

具体的报错信息：

      SELECT FCPP.CONCURRENT_REQUEST_ID REQ_ID,       
       FCP.NODE_NAME,       
       FCP.LOGFILE_NAME
  FROM FND_CONC_PP_ACTIONS FCPP,       
       FND_CONCURRENT_PROCESSES FCP
 WHERE FCPP.PROCESSOR_ID = FCP.CONCURRENT_PROCESS_ID      
   AND FCPP.ACTION_TYPE = 6
   AND FCPP.CONCURRENT_REQUEST_ID = 730748--请求编号

日志报错信息：

[12/14/18 9:01:21 AM] [UNEXPECTED] [267606:RT2961649] java.io.FileNotFoundException: /ebsapp/prod/inst/apps/PROD_ebsappzb/logs/appl/conc/out/xdof2KzeSz3e6121418_0901213690.fo (A file or direc
tory in the path name does not exist.)
        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:1665)
        at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)

修改opp配置文件内存参数

update FND_CP_SERVICES set DEVELOPER_PARAMETERS ='J:oracle.apps.fnd.cp.gsf.GSMServiceController:-Xmx1024m' where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES  where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
如果是12.2.4，则还可以通过前台管理器界面 环境按钮，进入修改参数界面，参考值:-Xms 512M -Xmx 1024M
修改完成后，重启管理器即可。

参数修改之后提交请求还是报错：

参考官方文档：

XML Publisher Reports Fail with java.io.FileNotFoundException on Temp Directory After Cloning (Doc ID 1189764.1)

操作：

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

总结：

      新克隆的环境，报表输出管理器配置文件中，输出文件目录没有更换，保留源环境信息，一次生成临时文件报错。一次后边把临时文件输出目录更改现有目录就可以了。

(笔者原创文章，转载请注明出处：https://blog.csdn.net/LFCuiYs）谢谢！