Re: java.sql.SQLException: ORA-20100: ORA-20100: File o5605765.tmp creation failed.

Posted by ErmanArslansOracleBlog on Oct 11, 2016; 11:21am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/java-sql-SQLException-ORA-20100-ORA-20100-File-o5605765-tmp-creation-failed-tp1366p1372.html

The directory pointed in your error message is actually $OA_MEDIA.


Send me the following output:

1)echo $APPLTMP
2)echo $APPLPTMP
3)env |grep media
4)select o.application_id,
      o.profile_option_name,
      t.user_profile_option_name,
      t.description,
      v.profile_option_value,
      v.level_id
from   FND_PROFILE_OPTIONS_TL t,
      FND_PROFILE_OPTIONS o,
      FND_PROFILE_OPTION_VALUES v
where  o.profile_option_id = v.profile_option_id
and    o.profile_option_name = t.profile_option_name
and    t.language = 'US'
and    v.profile_option_value like '%media%';