XLAACCPB Create Accounting runs with “Completed” / “Warning” status

This issue occurred in the new cloned instance while in the source PRODuction instance  program runs OK.

XLAACCPB module: Create Accounting runs with “Completed” / “Warning” status.

There are several oracle support documents discussing this issue but if those do not solve your error, you could be hitting the same issue as we did.
In our case this was caused by the “Temporary Directory” setting in ‘XML Publisher Administration’

To troubleshoot this specific issue follow the illustrated steps below.

A sample log file for Post Processor service:

2/29/12 2:13:20 PM] [26877:RT465327] Output file was found but is zero sized - Deleted
[2/29/12 2:13:20 PM] [UNEXPECTED] [26877:RT465327] java.io.FileNotFoundException: /usr/tmp/xml/xdoGyOSH48blc022912_0213202910.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: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)

Concurrent Request logfile
Screen shot of Concurrent Create Accounting request logfile

Navigate to Output Post Processor service log file

Click Output post processor to view details

Click View Process

Select an Active process then Click View Log

Select an Active process then Click View Log

within Logs window 'ctrl+F' search for the Concurrent Request ID of Create accounting with error

From the logs window, we see that the error “java.io.FileNotFoundException: /usr/tmp/xml/”. This error will be triggered if the instance was cloned from a different machine and the ‘/usr/tmp/xml’ path does not exist.  The path is a result of a configuration within the ‘XML Publisher” as shown below:

As a user with 'XML Publisher Admin' responsibility. Navigate to Administration - general properties - temporary directory

The value in ‘temporary directory’ corresponds to the error log’s missing folder and should be recreated in the new OS target host and grant the application ‘applmgr’ user write access to it.

Resubmit the ‘Create Accounting’ concurrent program to validate the solution.


About this entry