Oracle EBS fnd_file problem

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Thu, 28 Feb 2013 08:43:52 -0500
Message-Id: <512F18C80200000B004FCF55_at_groupwise.gcrta.org>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 28 2013 - 14:43:52 CET