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

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

Send me the following outputs:
1)
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 '%/app/PMTG/apps/apps_st/comn/java/classes/oracle/apps/media%';

2)
select translate(ltrim(value),',',' ')
from v$parameter
where name = 'utl_file_dir';