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

[Roshan]

Hello Erman,

we have encountered the error shown below:
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20100: ORA-20100: File o5605765.tmp creation failed.
File could not be opened or operated on as requested.

Action: Make sure the directory - /app/PMTG/apps/apps_st/comn/java/classes/oracle/apps/media - is a valid directory with write permissions and is accessible from the
ORA-06512: at "APPS.FND_FILE", line 319
ORA-06512: at "APPS.FND_FILE", line 364
ORA-06512: at "APPS.FND_FILE", line 421
ORA-06512: at "APPS.IBY_FD_USER_API_PUB", line 682
ORA-06512: at "APPS.IBY_FD_USER_API_PUB", line 325
ORA-06512: at "APPS.AP_PAYMENT_UTIL_PKG", line 926
ORA-06512: at line 1


I have checked the permission, all is ok. Still the issue persists. Do you think the user is running the package as a different user?

[ErmanArslansOracleBlog]

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

[Roshan]

Sorry for late reply.

No rows returned for first script

for second script:
SQL> select translate(ltrim(value),',',' ')
from v$parameter
where name = 'utl_file_dir';   2    3

TRANSLATE(LTRIM(VALUE),',','')
--------------------------------------------------------------------------------
/usr/tmp  /D01/Bank/MUR  /D01/Bank/FOREX  /app/PMTG/db/tech_st/11.1.0/appsutil/o
utbound/PMTG_erpprod

[ErmanArslansOracleBlog]

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%';

[ErmanArslansOracleBlog]

Also send me the following;

5)echo $OA_MEDIA (in apps tier)
6)cd $OA_MEDIA/../ ; ls -al|grep media (in apps tier)
7 cd /app/PMTG/apps/apps_st/comn/java/classes/oracle/apps/media/../ ; ls -al|grep media (in apps tier)

[Roshan]

1) /app/PMTG/inst/apps/PMTG_erpprod/appltmp

2) /usr/tmp

3) OA_MEDIA=/app/PMTG/apps/apps_st/comn/java/classes/oracle/apps/media

4) no rows

[Roshan]

6) APPLPROD>cd $OA_MEDIA/../ ; ls -al|grep media
drwxrwxrwx    4 applprod dba          344064 Jul 15 2011  media

7) APPLPROD>cd /app/PMTG/apps/apps_st/comn/java/classes/oracle/apps/media/../ ; ls -al|grep media
drwxrwxrwx    4 applprod dba          344064 Jul 15 2011  media

[ErmanArslansOracleBlog]

What is the output of following;

SELECT logfile_name, outfile_name 
FROM fnd_concurrent_requests where actual_start_date > sysdate-1

2016-10-11 14:38 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

6) APPLPROD>cd $OA_MEDIA/../ ; ls -al|grep media
drwxrwxrwx    4 applprod dba          344064 Jul 15 2011  media

7) APPLPROD>cd /app/PMTG/apps/apps_st/comn/java/classes/oracle/apps/media/../ ; ls -al|grep media
drwxrwxrwx    4 applprod dba          344064 Jul 15 2011  media

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/java-sql-SQLException-ORA-20100-ORA-20100-File-o5605765-tmp-creation-failed-tp1366p1375.html

To start a new topic under EBS 12.1/12.0, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[Roshan]

log11.lst

[ErmanArslansOracleBlog]

What is the name of this program?

[ErmanArslansOracleBlog]

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

[ErmanArslansOracleBlog]

Also please provide the following :

SQL> 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%';

--Note that this time MEDIA in upper CASE ..