台灣最大程式設計社群網站
線上人數
2273
 
會員總數:245973
討論主題:189551
歡迎您免費加入會員
討論區列表 >> Blog精華文章 >> IE7-->Concurrent: Client Filename Characterset
[]  
[我要回覆]
回應主題 加入我的關注話題 檢舉此篇討論 將提問者加入個人黑名單
IE7-->Concurrent: Client Filename Characterset
價值 : 0 QP  點閱數:591 回應數:0
樓主

花旗蔘 版主
高級專家
10938 129
4319 516
發送站內信

環境:

OS:win2k3 sp2

EBS:R12.1.3

DB:11.2.02

------之前ap人員發現

當Browser為IE7時,要是有中文檔名的output  file,當Click "View Output" 會 get error 如下
 

ERROR
------------------------------------------
Internet Explorer cannot download FNDWRR.exe.
Internet Explorer was not able to open this Internet site.The requested site is either unavailable or cannot be found.Please try again later.

這問題只有發生在IE7,IE6,IE8 and Firefox 是沒問題的,而File Format : EXECL or PDF

後來log SR ,oracle 回覆歷程:

1、Please login Database as APPS user and execute following SQL and update the results into SR:

SELECT pot.user_profile_option_name,
pot.profile_option_name "NAME" ,
DECODE (TO_CHAR (pov.level_id), '10001', 'SITE' , '10002', 'APP', '10003', 'RESP', '10004', 'USER', '???') "LEV" ,
DECODE (TO_CHAR (pov.level_id) , '10001', '', '10002', app.application_short_name , '10003', rsp.responsibility_key, '10004', usr.user_name, '???') "CONTEXT",
pov.profile_option_value "VALUE"
FROM fnd_profile_options_tl pot,
fnd_profile_options po,
fnd_profile_option_values pov ,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp
WHERE pot.profile_option_name = 'FND_CLIENT_FILENAME_CHRSET'
AND po.profile_option_name = 'FND_CLIENT_FILENAME_CHRSET'
AND pov.application_id = po.application_id
AND pov.profile_option_id = po.profile_option_id
AND usr.user_id(+) = pov.level_value
AND rsp.application_id(+) = pov.level_value_application_id
AND rsp.responsibility_id(+) = pov.level_value
AND app.application_id(+) = pov.level_value
ORDER BY "NAME",
pov.level_id,
"VALUE";

 

回答:---The SQL's result

no rows selected

2、Please check that whether profile "Concurrent: Client Filename Characterset" exists in your EBS system ?
If yes, what is the value of the profile ?
 


回答:it's blank

3. Please try profile "Concurrent: Client Filename Characterset" value of "ZHS16CGB231280" and "UTF8" to retest the issue.
If that is no help, please keep the value of "Concurrent: Client Filename Characterset" to blank, and then continue to provide remaining action plan information.

回答:正解在下面,以下是我的測試結果
--1'
ZHS16CGB231280 :can open the FILE ,but the filename is incorrect

--2'
UTF8 :not work

--3'
AL32UTF8(NLS_CHARACTERSET) :not work

--4'
AL16UTF16(NLS_NCHAR_CHARACTERSET):can open the file,but the filename is english

--5'
ZHT16MSWIN950 :can open the file and the filename seems right!


------------->OK
 


本篇文章發表於2011-12-14 10:41
== 簽名檔 ==
Oracle/EBS/MS SQL DBA
--My BLOG
http://itgroup.blueshop.com.tw/benchenBEN/blog
目前尚無任何回覆
   

回覆
如要回應,請先登入.