ERPstuff - Oracle EBS Community

Dear All
I am facing the some problems while defining the key flex fields in GL (R 12.0.4) I have found the following error:

DECLARE
*
ERROR at line 1:
ORA-20100: Error: FND_FILE failure. Unable to create file, o0779562.tmp in the
directory, c:\temp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 526
ORA-06512: at "APPS.GL_GLCOAM_PKG", line 531
ORA-06512: at line 8

The Log shows the following statement:

Concurrent Manager encountered an error while running SQL*Plus for your concurrent request 4400361.
Review your concurrent request log and/or report output file for more detailed information.


The concurrent request which displayed the error was ?Program - Generate Ledger Flexfield?


Please lead towards a solution.

Thank you.

Best regards
Zeeshan

Hi,

Please try following solution:

Cause
The issue is caused by the parameter utl_file_dir in the pfile is being taken as a complete string.

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


Thanks & Regards,

Siva