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