Re: ORA-20100: File l1380173.tmp creation for FND_FILE failed

  • From: Prasanna Pandian <prasanna.pandian@xxxxxxxxx>
  • To: ora-apps-dba <ora-apps-dba@xxxxxxxxxxxxx>
  • Date: Mon, 10 May 2010 10:02:02 +0100

Hi,

Do check whether the "tmp" folder has enough space and also 'applmgr'
account has write permission on that folder.

Thanks,
Prasanna


On Mon, May 10, 2010 at 9:49 AM, <abmian1981@xxxxxxxxx> wrote:

> Hi Lads,
>
> While running HRI Load All Assignment Events Fact in Daily Business
> Intelligance Administrator i am Facing following error . On other hand
> my all other requests working fine , utl_file_dir is properly setup.
>
> Human Resources Intelligence: Version : 11.5.0
>
> Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
>
> HRI_ASGN_EVENTS module: HRI Load All Assignment Events Fact
>
> +---------------------------------------------------------------------------+
>
> Current system time is 10-MAY-2010 11:09:25
>
>
> +---------------------------------------------------------------------------+
>
> **Starts**10-MAY-2010 11:09:25
> **Ends**10-MAY-2010 11:10:30
> SUCCESS
>
> +---------------------------------------------------------------------------+
> Start of log messages from FND_FILE
>
> +---------------------------------------------------------------------------+
> WARNING: Error processing assignment_id 1551
> ORA-20100: File l1380173.tmp creation for FND_FILE failed.
> You will find more information on the cause of the error in request log.
> In log_process_info
> Exiting log_process_info
> Error at step
> ORA-20100: File l1380173.tmp creation for FND_FILE failed.
> You will find more information on the cause of the error in request log.
> Error raised by the process, marking the ranges as error
> Inside set_range_error
> 551 range records marked as Error
> exiting set_range_error
> error in process_range =ORA-20100: File l1380173.tmp creation for
> FND_FILE failed.
> You will find more information on the cause of the error in request log.
> SQLCODE = -20100
> Inside watch_child_processes
> 3 threads to watch for
> Exiting watch_child_processes
> A problem was encountered in this child process. See below for further
> details.
> In log_process_info
> Exiting log_process_info
> In log_process_end
> In get_mthd_action_id
> Exiting log_process_end
>
>

Other related posts: