Cause: FDPSTP failed due to ORA-20100: FND_FILE could not write to file

They were trying to import items from the items menu thru the inventory responsibility. In the logs it shows

**Starts**21-MAY-2018 18:13:02

**SQL error and free**21-MAY-2018 18:13:02

ORACLE error 20100 in FDPSTP

Cause: FDPSTP failed due to ORA-20100: FND_FILE could not write to file l0263903.tmp.

An operating system error occurred during the write operation.

Contact your system administrator. (TEMP_DIR=/dbapps/tmp)

ORA-06512: at "APP21-MAY-2018 18:13:02

Solution

Check if $APPLPTMP on the application server node is the same as the utl_file_dir parameter on the database. In this example mine was /dbapps/tmp

• On the application server node environment 
• $ echo $APPLPTMP
• /dbapps/tmp
• On the database 
• SQL> show parameter utl_file_dir
• 
  
• NAME                                 TYPE        VALUE
• ------------------------------------ ----------- ------------------------------
• utl_file_dir                         string      /dbapps/tmp
• Run this on the database

1. • exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
   • BEGIN FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST'); END;
   • SQL> show user
   • USER is "APPS"
   • SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
   • BEGIN FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST'); END;
   • PL/SQL procedure successfully completed.
   • 
     
   • SQL>
   •   2  /
   • 
     
   • PL/SQL procedure successfully completed.

• Go to the /dbapps/tmp directory on the DATABASE node!!! 
• cat the last file that was generated
• -rw-r--r-- 1 oracle dba  0 May 21 23:17 o0263921.tmp
• -rw-r--r-- 1 oracle dba 30 May 21 23:17 l0263921.tmp
• ! R12D2:ghoul.ecp.priv:/dbapps/tmp> cat l0263921.tmp
• THIS IS A TEST
• THIS IS A TEST
• ! R12D2:ghoul.ecp.priv:/dbapps/tmp>
•