4 Replies Latest reply on May 21, 2014 9:13 PM by Hussein Sawwan-Oracle

    ORA-20100: Error: FND_FILE failure. Unable to create file




      I am executing the Layer Cost Worker concurrent program.

      It completed with a warning because it shows this error:

      ORA-20100:Error: FND_FILE failure. Unable to create file, o0111002.tmp in the directory,/usr/tmp.


      Any ideas?


      Other jobs are working fine, creating output, below is some setup data.

      I show in my /usr/tmp directory 4.46gb free out of 5gb.

      There are 777 permissions on the directory /usr/tmp and the linked to directory /var/tmp.

      Yet I still show that I am unable to write out to the /usr/tmp directory.


      In the APPS Context File: <APPLTMP oa_var="s_appltmp">/tst_orainst/HFTTST/inst/apps/TEST_myappltst01/appltmp</APPLTMP>

      <APPLPTMP oa_var="s_applptmp" osd="UNIX">/usr/tmp</APPLPTMP>


      APPS TIER myappltst@myappltst01:/var/tmp $ ls -ltr /usr/tmp

      lrwxrwxrwx    1 bin      bin               8 Mar 19 2012  /usr/tmp -> /var/tmp


      myappltst@myappltst01:/usr/tmp $ df -g .

      Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on

      /dev/hd9var       5.00      4.46   11%    8930     1% /var


      The parameter: MYDBTST – show parameter utl_file_dir

      /usr/tmp, /hft/inv/inbox, /hft/inv/outbox, /hft/po/inbox, /hft/po/outbox, /hft/ar/inbox, /hft/ar/outbox, /hft/ap/inbox,/hft/ap/outbox,/hft/gl/inbox,/hft/gl/outbox, /oradump/faxes/prod, /usr/tmp,/tst_ora/MYTST/db/tech_st/11.2.0/appsutil/outbound/MYTST_myrdbtst01, /usr/tmp


      Select responsibility XML Publisher Administrator. >Home>Administration> Focus Properties > General > Temporary directory > Site Value >  /tst_myorainst/HFTTST/inst/apps/MYTST_myappltst01/appltmp