Thursday, October 6, 2016

ORA-20100: Temporary file creation for FND_FILE failed

Scenario:
-----------

While running a report in Payables or any of the program errored out and the log file shows the following error in R12.2.4

ORA-20100: Temporary file creation for FND_FILE failed

Error in Log file :
----------------------

Enter Password:
MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20100
MSG-00103: Error Message : 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.AP_APPROVAL_PKG", line 10672
MSG-00000: When Others:User-Defined Exception
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20100
MSG-00103: Error Message : 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", lin

Solution:
-----------

1. Check the APPLPTMP for ex. /usr/tmp/SARA
2. check whether that exsists in utl_file_directory.
Note : Better to check with gv$ view like below
select name,value FROM gv$parameter2 WHERE name='utl_file_dir' and value like '%SAR%';

If it is not same which is in APPLPTMP. then

a) Change the APPLPTMP location to any one location which is there in UTL file in env file and XML and bounce the concurrent
or
b) Add the same value which is in APPLPTMP to the UTL file location and bounce the db.






No comments: