Oracle EBS fnd_file problem
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: "oracle-l-freelist" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 28 Feb 2013 08:47:08 -0500
Getting error that fnd_file unable to create a file.
From manager log we see:
declare
*
ERROR at line 1:
ORA-20100: Error: FND_FILE failure. Unable to create file, l0127129.tmp in the
directory, f:\oracle\orapcomn\temp.
You will find more information in the request log.
ORA-06512: at "APPS_APPLMGR.FND_FILE", line 386
ORA-06512: at "APPS_APPLMGR.FND_FILE", line 526
It is NOT a permissions error. If I look in that directory, I DO SEE the file
there as being empty. However, the date/time on the file is later than that of
the request getting the error. Appears that something else is creating a file
with the same name. I looked at a log from a run of this job on 2/19 and it is
referencing the SAME tmp file as in the error message from a 2/11 log! Is this
supposed to happen this way?
I did some googling and found a script which I altered to do:
select cp.plsql_log, cr.request_id
from apps_applmgr.fnd_concurrent_requests cr,
apps_applmgr.fnd_concurrent_processes cp
where cp.plsql_log is not null
and cp.concurrent_process_id = cr.controlling_manager
and cp.plsql_log = 'l0127129.tmp'
order by cr.request_id;
This script returned a lot of rows. I checked a couple of the requests and they
matched to a workflow concurrent request job along with our failing job. Where
does Oracle get the file name from? Really appears that another process is
using the same name causing our problem.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
--
//www.freelists.org/webpage/oracle-l
Other related posts:
