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

  • From: Priyank Jain <mail2priyank@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Mon, 10 May 2010 12:45:55 +0100

Hi,

Check your APPLPTMP environment variable and see to it that this directory
is included in utl_file_dir in init.ora.
Also, check for space in this directory.

Cheers,
Priyank.


On Mon, May 10, 2010 at 10:02 AM, Prasanna Pandian <
prasanna.pandian@xxxxxxxxx> wrote:

> 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: