OPP Issue in EBS 12.2

[raja]

Hi Erman

In our EBS 12.2, some of the concurrent request which uses OPP for post processing are failing out with errors

[7/13/20 8:27:56 AM] [317249:RT6395635] Completed post-processing actions for request 6395635.
[7/13/20 8:28:01 AM] [OPPServiceThread0] Post-processing request 6395636.
[7/13/20 8:28:01 AM] [317249:RT6395636] Executing post-processing actions for request 6395636.
[7/13/20 8:28:01 AM] [317249:RT6395636] Starting XML Publisher post-processing action.
[7/13/20 8:28:01 AM] [317249:RT6395636]
Template code: XXBOL_INV_1328_EXCESS_MET_REP
Template app:  XNOV
Language:      en
Territory:     00
Output type:   EXCEL
[7/13/20 8:28:01 AM] [317249:RT6395636] Output file was found but is zero sized - Deleted
[7/13/20 8:28:01 AM] [UNEXPECTED] [317249:RT6395636] java.io.FileNotFoundException: /u03/applcsf/tmp/xdoHv2zIPYjsA071320_0828017248.fo (No such file or directory)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:171)
        at oracle.apps.xdo.common.tmp.TmpFile.createTmpFileJDK118(Unknown Source)
        at oracle.apps.xdo.common.tmp.TmpFile.createTmpFile(Unknown Source)
        at oracle.apps.xdo.template.FOProcessor.getTmpFOFile(Unknown Source)
        at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
        at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5984)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3475)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3564)
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:311)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:185)

[7/13/20 8:28:01 AM] [317249:RT6395636] Completed post-processing actions for request 6395636.
[GC 61619K->12455K(398336K), 0.0053680 secs]
[GC 61095K->12519K(398336K), 0.0072010 secs]
[GC 60647K->12487K(397312K), 0.0054120 secs]
[GC 60103K->12535K(397312K), 0.0031340 secs]

[raja]

Hi Erman

Also, this path /u03/applcsf/tmp/xdoHv2zIPYjsA071320_0828017248.fo (No such file or directory)

doesn't exist physically in the server

[raja]

APPLCSF points correctly to some other location and concurrent log and out files are getting generated there.
This instance was cloned from prod and not sure why OPP logs says that it is pointing to PROD location(/u03/applcsf/tmp)

[ErmanArslansOracleBlog]

This seems to be related with the "XML Publisher Administrator: Properties -> General -> Temporary Directory"


Action plan:

Create the required OS directory
Give permissions read and write to applmgr OS user
Change the Temp directory accordingly -> XML Publisher via : XML Publisher Administrator: Properties -> General -> Temporary Directory.
Restart the OPP( if the issue persists, a full concurrent manager restart may help)
Retest

[raja]

Thanks Erman. Issue was resolved by changing the path in XML Publisher Responsibility>>Administration>Select General and then had to put the correct $APPLCSF value