Concurrent Requests Fail with FDPSTP failed

fact: Oracle Application Object Library 11.5

symptom: cause: fdpstp failed due to ora-20100: file o0000005.tmp creation
for fnd_file failed

symptom: ORA-6512 at apps.fnd file line 419

symptom: Concurrent requests fail

symptom: Oracle error: 20100 in fdpstp

change: Fresh install of Applications 11.5

cause: The concurrent program was unable to write to the specified
temporary file because the virtual path assigned to the APPLPTMP environment
variable is not referenced in the UTL_FILE_DIR.



fix:

APPLPTMP is a special directory used only for PLSQL temporary files. When a
concurrent program uses the FND_FILE package, the concurrent manager uses
APPLPTMP as the directory to which it writes temporary files. FND_FILE uses the
UTL_FILE package, which can only write to directories specified in init.ora.
Thus, APPLPTMP must be one of the directories listed in init.ora in order for
FND_FILE to work.

Ensure that the virtual path assigned to the APPLPTMP environment variable is
valid, writable, and is referenced at the beginning of the UTL_FILE_DIR
database parameter.

Example:
In the initSID.ora
utl_file_dir = /usr/tmp, /u01/sql/tmp, /u02/sql/tmp
In the SID.env,
APPLPTMP = /usr/tmp
(or any of the directories listed above that applmgr has
read/write permissions to).

Make sure that the value for APPLPTMP comes first in this listing for
UTL_FILE_DIR, as this is the key to this solution.

转载于:https://www.cnblogs.com/ebs-blog/archive/2007/06/05/2167399.html