Concurrent Processing - ORA-20100: Error: FND_FILE Failure, Unable to Create File

Concurrent Processing - ORA-20100: Error: FND_FILE Failure, Unable to Create File [ID 749491.1]
		Modified 14-APR-2011 Type PROBLEM Status ARCHIVED

In this Document
Symptoms
Cause
Solution

---

Applies to:

Oracle Application Object Library - Version: 12.0.4 and later [Release: 12 and later ]
Oracle Concurrent Processing - Version: 12.0.0 to 12.0.6 [Release: 12 to 12]
Information in this document applies to any platform.
Checked for relevance on 02-Mar-2011

Symptoms

On Real Application Cluster (RAC) environment, when attempting to run concurrent requests or 'exec FND_FILE.PUT(FND_FILE.LOG, 'TESTING');' from the command line, the following error occurs:

ORA-20100: Error: FND_FILE failure. Unable to create file, o0040178.tmp in the
directory, /usr/tmp.
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

Cause

The issue is caused by the parameter utl_file_dir in the pfile as being taken as a complete string. The utl_file_dir is currently defined in the following manner:
utl_file_dir=/usr/tmp,/oraapp/inst_finp/apps/finp_u914403/appltmp,/oraapp/inst_finp/apps/finp_u914404/appltmp
Modification to the pfile resolved the issue.

Solution

1. On the Database created pfile from spfile.
2. Modified pfile with the entries, utl_file_dir='/usr/tmp','/oraapp/inst_finp/apps/finp_u914403/appltmp','/oraapp/inst_finp/apps/finp_u914404/applt
mp' .
3. Started the DB only on 1 node.
4. Tested the FND_FILE procedure, it completed successfully.
5. Created the spfile from the pfile.
6. Started up all the services (using the spfile).
7. Submitted the concurrent request and it completes successfully

---

Related Products Oracle E-Business Suite > Applications Technology > Application Object Library > Oracle Application Object Library Oracle E-Business Suite > Applications Technology > Application Object Library > Oracle Concurrent Processing Errors ORA-20100; ORA-6512; 620100 ERROR; 20100 ERROR

Back to top