FDPSTP failed due to ORA-20100

shiyihai發表於2011-02-10

When having a try to print non-manual invoice by printing manual invoice,We got an error just like this:
Current system time is 10-FEB-2011 07:31:42
**Starts**10-FEB-2011 07:31:42
ORACLE error 20100 in FDPSTP
Cause: FDPSTP failed due to ORA-20100: File l0042269.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at "APPS.FND_FILE", line 407
ORA-06512
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

[@more@]


To fix this problem, you shoule be careful that the value of $APPLPTMP must exist in UTL_FILE_DIR.
SQL> show parameter utl_file

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string /stage/tmp, /usr/tmp, /oracle/
proddb/10.2.0/appsutil/outboun
d/PROD_xxxxxoraap, /stage/edi/
output_files, /stage/edi/input
_files, /stage/sqlcom/outbound
, /stage/sqlcom/inbound, /stag
e/sqlcom/out, /stage/sqlcom/lo
g, /stage/PROD_xxxxxta/input_f
iles, /stage/PROD_xxxxxta/outp
ut_files
SQL>

Here,$APPLPTMP=/stage/tmp,IF you want to change the UTL_FILE_DIR, It's necessary to restart DB in order to update it.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/38542/viewspace-1045773/,如需轉載,請註明出處,否則將追究法律責任。

相關文章