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

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

What is the output of the following;

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    o.profile_option_name like '%IBY_XML_TEMP%'