ORA-20100: Error: FND_FILE failure

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: OAM Applications Dashboard Collection concurrent request is failing


SQL> exec fnd_file.put(fnd_file.log,'TESTING');
BEGIN fnd_file.put(fnd_file.log,'TESTING'); END;

*
ERROR at line 1:
ORA-20100: Error: FND_FILE failure. Unable to create file, o0018180.tmp in the
directory, /applogs/admin/conc/appltmp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 456
ORA-06512: at line 1




After this see if the issue has been fixed.


Work Around:


Modifying APPLPTMP to /usr/tmp and make /usr/tmp first entry on the utl_file_dir did solve the issue.

1 - Be sure to have a valid Backup
2 - Execute autoconfig.
3 - Bounce the database
4 - Stop all Application Services
5 - Run autoconfig at the Application Tier
6 - Start all Services
7 - See if the issue has been resolved


Solution:




Review and Apply: Note 749491.1 - ORA-20100: Error: FND_FILE Failure, Unable To Create File , be sure it willbe done at both nodes.


and


test the procedure as described in Note 74268.1 - Using utl_file, how file permissions are determined

Get Oracle Certifications for all Exams
Free Online Exams.com