SolutionS

Error:  FDPSTP failed due to ORA-20100: Error: FND_FILE failure.

           Unable to create file, o8819870.tmp in the directory, /usr/tmp

Description: while running concurrent requests getting error unable to create file o8819870.tmp

                     in the directory, /usr/tmp

Solution:  

1. Check APPLPTMP is set to a valid directory

                 applusr:

                 Login to the applusr

                 echo $APPLPTMP

                 /usr/tmp      

 

                 orauser:

                cd $ORCLE_HOME/dbs

                Check the parameter in initsid.ora  utl_file_dir = /usr/tmp

      

2. Check the availbe free space if not delete the delete the tmp files under  tmp directory.

  

                 rm -rf *

  

3. Ensure that particular file is exits  or not if it is exits delete it that file /usr/tmp/

               

 Eg: o8819870.tmp

  

4. check the permissions(Read and Writer) utl/tmp directroy  if not    login to the root give this

     

       chmod -R 755 usr

      

5. Run the Concurrent Requests again.

 

Sources: Troubleshooting ORA-20100 on Concurrent Processing [ID 261693.1]