ORA-20100 : Temporary file creation for FND_FILE failed.

Scenario:
———

Request completed with the following error:

ORA-20100 : Temporary file creation for FND_FILE failed.

Log file shows the following :
————————————
+—————————————————————————+
Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDOAMCOL: OAM Applications Dashboard Collection
+—————————————————————————+

Updated system property java.protocol.handler.pkgs to HTTPClient
Refreshing All …
Refreshing Applications System Status …
Refreshing Activity …
Refreshing Configuration Changes …
Refreshing Throughput …
Refreshing Exceptions Summary …
Refreshing User Alert Summary …
Collecting metric values for each aplication tier node …
Collecting metric values for each database instance …
Done Refreshing All …
Checking collected data for alerting …
Checking long running requests for alerting …
SQLException:
java.sql.SQLException: ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.

Action: Check that the directory is a valid directory with write permissions on the database server node and is listed under utl_file_dir para
ORA-06512: at “APPS.FND_FILE”, line 319
ORA-06512: at “APPS.FND_FILE”, line 364
ORA-06512: at “APPS.FND_FILE”, line 421
ORA-06512: at “APPS.FND_OAM_COLLECTION”, line 2786
ORA-06512: at line 1

Oracle error : An unexpected system error has been detected in Application code. Please contact System Administrator for assistance.Successfully resubmitted concurrent program FNDOAMCOL with request ID 84242340 to start at 31-MAY-2017 23:45:52 (ROUTINE=AFPSRS)

+—————————————————————————+
No completion options were requested.

Output file size:
—————————————————————————-+

Reason:
———

The APPLPTEMP location points to a directory which is not in the utl_file directory in the database. So when the application user is trying to create a temp file in the location it is not allowed.

grep -i APPLPTMP $CONTEXT_FILE
         <APPLPTMP oa_var=”s_applptmp” osd=”UNIX”>/doyen/app/DOYENSYS/fs2/inst/apps/DOYENSYS_sara1/temp</APPLPTMP>

when i check the utl_file, It shows the following :

/usr/tmp

 Solution:
=======

1. Either add the following location in utl_file dir and restart the db /doyen/app/DOYENSYS/fs2/inst/apps/DOYENSYS_sara1/temp    or
2. Change the s_applptmp value to /usr/tmp and run autoconfig and try running the report again.

  • May 31, 2017 | 25 views
  • Comments