http://softwaresetup.blogspot.com/2016/04/oracleappsxdoxdoexception.html
Excel Reports Completed with warning
+---------------------------------------------------------------------------+
Assets: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FAREGXLSUPD: Fixed Assets Register - Excel
+---------------------------------------------------------------------------+
Current system time is 14-APR-2016 11:59:11
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_BOOK_TYPE='PROD'
P_PERIOD='MAR-16'
P_PROPERTY_TYPE_CODE='ALL'
------------
Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
APPLLCSP Environment Variable set to :
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8
'.,'
Enter Password:
REP-0004: Warning: Unable to open user preference file.
Report Builder: Release 10.1.2.3.0 - Production on Thu Apr 14 11:59:12 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
3746985
+--------- 1) POST-PROCESSING ---------+
Beginning post-processing of request 1549379 on node ERP at 14-APR-2016 11:59:18.
-- Publishing output
Post-processing of request 1549379 failed at 14-APR-2016 11:59:18 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
CONC-POST-PROCESSING RESULTS
-- PUBLISH:
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException: /apps/prod/PROD/tmp/xdoytFXQvltrg041416_11591830413.fo (No such file or directory)
+---------------------------------------+
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 14-APR-2016 11:59:18
+---------------------------------------------------------------------------+
Solution
create tmp directory as said above
/apps/prod/PROD/tmp