目前分類:System Admin (38)

瀏覽方式: 標題列表 簡短摘要

Valid Values for Profile Oracle Applications Look and Feel that can be set at any of the Site, Application, Responsibility or User levels:

There are six profile values we can choose

  • ABS Desktop Look and Feel (Order to Cash)
  • Base Desktop Look And Feel : the root of all LAF implementations.
  • Browser Look And Feel : the default LAF that conforms to Oracle’s corporate UI guidelines.
  • Minimal Look And Feel : Generates "minimal" content to reduce the size of HTML pages and overall network overhead.
  • Siebel CRM OnDemand Look and Feel
  • Simple Desktop Look And Feel

So far , I don’t find what’s the difference ?

文章標籤

SomebabyTina 發表在 痞客邦 留言(1) 人氣()

Error Message :

Trading Community Manager is not a valid responsibility for the current user. Please contact your System Administrator.

image

[Solution]

Responsibility : Functional Administrator

image

image

[Result]

image

image

No error now.

文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

今天,我想實現一個東西,我想透過Oracle sequecne 功能,實現User想要的sequence給號。我的需求是每年度要重新給號,實現這個功能,我們可以用DB sequence,設定recycle,但我想做的是透過設定,每個不同的帳本,可以依照自己想要的編碼方式取得想要的號碼,就像GL的sequence一樣。

不囉嗦,就來看我怎麼實現囉…..

Oracle ERP version : 11.5.10.2

首先我要讓我的客製Table在Oracle Document Category可以選擇的到,於是我必須先將我的Table 註冊到Oracle Database Table中....請先參考<How to register table into Oracle ERP applicaiton> 文章。

文章標籤

SomebabyTina 發表在 痞客邦 留言(3) 人氣()

============================================================

文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

What is different look and feel when we set different value in the profile ?


Value : generic

image 

Value : oracle

image

文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

SELECT apps.fnd_web_sec.validate_login (GUEST, 'password') FROM DUAL

image

文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

Personalize Self-Service Defn profile value 的功能差異

Personalize Self-Service Defn : Yes

image

Personalize Self-Service Defn : No

image

文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

FND: Indicator Colors

Valid values are "Yes", "No", or null (defaults to "Yes".) When this profile option is set to "Yes":

    • Required fields are displayed in yellow.
    • Queryable fields are displayed in a different color while in enter-query mode.
    • Read-only fields are rendered in dark gray.
文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

SELECT fnd_web_sec.validate_login ('TINALEE', 'xxx')
  FROM DUAL

 

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

並不是所有Oracle Table都有支援儲存Multi-language data.

當你在Oracle Form Toolbar上看到小地球的icon,就代表我們可以儲存多國語言資訊。

image

image 

提供給大家參考囉

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

Turn on前

image

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

  • Module : Web Applications Desktop Integrator (BNE)
  • Responsibility : Desktop Integration

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

資料來源:夏普視野

直接改iexplore捷徑,加入-nomerge ("C:\Program Files\Internet Explorer\iexplore.exe" –nomerge ),完成。

image

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

Responsibility : System Administrator

Path : Install > Territories

image

建議如果要新增新的國家,還是先上Oracle Metalink找找看有沒有path可以上。

避免Code取的不一樣,進而在相關貿易文件上出差錯。

Ex. Metalink Notes ID 430189.1 => Create new territories for Serbia and Montenegro

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

如何查找目前環境是否有上某個Oracle Path.

image

出現Web 查找畫面

image

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

Oracle ERP改成Web Login後造成有些Function無法Launch Form

 

Oracle的建議請參考(Metalink: 149358.1 )

重點Responsibility Key不要用特殊字,中文字,還有 空白

如果採用Data Fix, 需更新下面3個Table

FND_RESPONSIBILITY
WF_LOCAL_ROLES

WF_LOCAL_USER_ROLES

 

UPDATE FND_RESPONSIBILITY
     SET RESPONSIBILITY_KEY = 'DHC_WORK_IN_PROCESS'
WHERE RESPONSIBILITY_ID = 51645;


UPDATE WF_LOCAL_ROLES
     SET NAME='FND_RESP|OFA|AYK_FA_ACC_USER|STANDARD'
WHERE NAME='FND_RESP|OFA|AYK_FA列婚_USER|STANDARD';


UPDATE WF_LOCAL_USER_ROLES
     SET ROLE_NAME='FND_RESP|OFA|AYK_FA_ACC_USER|STANDARD'
WHERE USER_NAME='MIKECHEN'
     AND ROLE_ORIG_SYSTEM_ID=51898
     AND ROLE_NAME='FND_RESP|OFA|AYK_FA列婚_USER|STANDARD';

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

ERP 中選不到國別

Reference : Notes, 277121.1與404331.1.

新增SQL如下 :

INSERT INTO FND_TERRITORIES (TERRITORY_CODE,
                             LAST_UPDATE_DATE,
                             LAST_UPDATED_BY,
                             CREATION_DATE,
                             CREATED_BY,
                             LAST_UPDATE_LOGIN,
                             ISO_NUMERIC_CODE,
                             NLS_TERRITORY,
                             OBSOLETE_FLAG,
                             ISO_TERRITORY_CODE)
                     VALUES ('ME',
                             SYSDATE,
                             1168,
                             SYSDATE,
                             1168,
                             0,
                             499,
                             'MONTENEGRO',
                             'N',
                             'MNE');

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

image

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

資料來源:Symplik

 

 

How to do that
Assuming the original login page is

http(s)://[APPL_TOP Server]:[port]/OA_HTML/AppsLocalLogin.jsp
For simplicity, this URL is represented by
[Apps URL]/OA_HTML/AppsLocalLogin.jsp
To goto the Apps Home Page (i.e. Navigator Page) without entering the username and password, you can use the URL:
[Apps URL]/OA_HTML/fndvald.jsp?username=[login name]&password=[password]
If you want to create another Login Page rather than using the the one provided by Oracle, you can include this HTML code in your page:
<form method="post" action="[Apps URL]/OA_HTML/fndvald.jsp">
  <input type="text" name="username" value=""/>
  <input type="password" name="password" value=""/>
  <input type="submit" name="login" value="submit" />
</form>

To launch any Form or OA Framework Page using direct URL, you must obtain the Form or page URL from the Navigator Page, as shown in here:


Move your cursor to the the link, right click, and select "Copy Shortcut"
For Forms, the shortcut looks like (this is the OM Sales Order Form):

javascript:launchForm('[Apps URL]/OA_HTML/RF.jsp?function_id=5522&resp_id=50349&resp_appl_id=660&security_group_id=0&lang_code=US&oas=129LdJJoQltOPAQwtQlOFQ..')
Just take the javascript function parameter, remove the last query string parameter, and it will look like:
[Apps URL]/OA_HTML/RF.jsp?function_id=5522&resp_id=50349&resp_appl_id=660&security_group_id=0&lang_code=US
For OA Framework Pages, copy the shortcut and it looks like (this is the Workflow Notification Page):
[Apps URL]/OA_HTML/RF.jsp?function_id=2043&resp_id=50349&resp_appl_id=660&security_group_id=0&lang_code=US&params=HjNYXS4MZviS3zdx5xBFd7eSJJ8O3MKDbqmDsTMdo7E&oas=FQvfEQgSdW25KedN-Jstpw..
Again, remove the last query string parameter and it will look like:
[Apps URL]/OA_HTML/RF.jsp?function_id=2043&resp_id=50349&resp_appl_id=660&security_group_id=0&lang_code=US

Next, you need to URLEncode this URL string, like using this page to do it:
[Apps URL]%2fOA_HTML%2fRF.jsp%3ffunction_id%3d2043%26resp_id%3d50349
%26resp_appl_id%3d660%26security_group_id%3d0%26lang_code%3dUS

Finally, the Direct URL for launching a Form or page will be:
[apps URL]/OA_HTML/fndvald.jsp?username=[username]&password=[password]&requestUrl=[urlencoded URL string]

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

故障現象:操作oracle系統時,不能把復制的文本粘貼到系統裡面,Paste菜單是灰色的。同時剛開啟oralce的時候,oracle畫面下面有黃色的條幅-錯誤畫面沒有抓下來。

解決方法:到一個正常的oracle系統安裝路徑裡面搜索identitydb.obj文件,取代掉有問題電腦的這個文件,就可以了。

資料來源:http://www.itpub.net/showthread.php?s=8a3c0ddb1ba1ded55b0ea6dfcbe8a727&threadid=168393&perpage=15&pagenumber=1

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

1 2