workflow administration 裡面的 download location 值不正確

## Oracle ERP路徑:

1. Navigation Path : Workflow Administrator Web (New) > Administration > Workflow Configuration
2. In Region of JInitiator, Download Location is : http://terp01.nbwde.com.cn:8001/OA_HTML/oajinit.exe

## 問題描述:

 The workflow configuration page shows the JInitiator download location is:
http://terp01.nbwde.com.cn:8001/OA_HTML/oajinit.exe

這是不正確的

## 檢查過程:

Checking WF_RESOURCES shows:
WF_PLUGIN_DOWNLOAD - http://terp01.nbwde.com.cn:8001/OA_HTML/oajinit.exe

其實這台server的8001 port 並沒有服務

JInitiator can be downloaded from forms without problem as there is no reference to the wrong server in the context file or the forms configuration.

## 參考資料:

Cannot Configure Global Preferences Since Jinitiator Preferences Do Not Exist For WF 11i (Doc ID 220212.1)

The note explains :
WF_RESOURCES table is populated with JInitiator information from appsweb.cfg ($FORMS60_WEB_CONFIG_FILE).
If the values are incorrect, please manually update appsweb.cfg and/or WF_RESOURCES table with the correct values.

appsweb.cfg and wf_resources 的值應該要相同，如果不同，要手動修正，使之相同

##　檢查參數 appsweb.cfg:

 The value of parameter sun_plugin_url in file $FORMS60_WEB_CONFIG_FILE is correct.
=> /appl/prodcomn/html/bin/appsweb_PROD_perpap1.cfg

=> sun_plugin_url=http://perpap.cmo.com.tw:80/OA_HTML/oajinit.exe

這是正確的

## 檢查XML file

vi $APPL_TOP/admin/*.xml

也是正確的

## 檢查 table wf_resources:

select substr(name,0,18) Name, substr(text,0,55) Value
from wf_resources
where name in
('WF_WEB_AGENT',
'WF_ADMIN_ROLE',
'WF_VERSION',
'WF_CLASSID',
'WF_PLUGIN_DOWNLOAD',
'WF_PLUGIN_VERSION');

發現wf_resources真的有terp01未被更改的值

## 解決方式:

1. 備份:

create table apps.wf_resources_20120305_bak as
select * from wf_resources;

2. 更正:

update applsys.wf_resources
set text = 'http://perpap.cmo.com.tw:80/pls/PROD'
where name = 'WF_WEB_AGENT';

update applsys.wf_resources
set text = 'http://perpap.cmo.com.tw:80/OA_HTML/oajinit.exe'
where name = 'WF_PLUGIN_DOWNLOAD';

commit;

## 解釋:

1. Function of JInitiator Download Location :
http://docs.oracle.com/cd/B25284_01/current/acrobat/115wfag.pdf
Page 40:
Oracle Workflow uses JInitiator to launch Oracle Applications forms linked to notifications.

That's to say this url will be used when end user access form function via workflow notification.

只有當user收到的wf notification如果有link到form需要開啟的話，才會引用到這個參數。

2. The workflow administrator role, LDAP, local system, and JInitiator information is saved to the Oracle Workflow resources table.

Jinitiator資訊儲存在wf_resources table中。

3. The answer to your question is to manually update wf_resources against the incorrect parameter value

解決方式是update wf_resources 的值成為正確的值。