今天試著新增一個員工帳號, 步驟如下:

1. 輸入帳號

2. 輸入預設密碼 x 2

3. 選擇 Employee

4. 存檔

5. 到 "Direct Responsibilities" 頁面選擇一 Responsibility (這邊我選擇 HR Foundation)

6. 再存檔

結果卻跳出 ORA-20002 [WF_NO_USER] NAME=XXX ORIG_SYSTEM=NULL ORIG_SYSTEM_ID=NULL has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT 的錯誤

找了一下 Google, 發現了兩個解法, 不過第一個就解了, 所以我就沒試第二個了 (BTW, 11i 就已經有這個問題了, Metalink 上也找不到相關的問題, 是都沒人反應吧 @@)

 

方法一: 改變一下建立步驟. 將上面的步驟改為以下

1. 輸入帳號

2. 輸入預設密碼 x 2

5. 到 "Direct Responsibilities" 頁面選擇一 Responsibility (這邊我選擇 HR Foundation)

6. 再存檔

3. 選擇 Employee

4. 存檔

 

方法二:

1. Submit Program "Workflow Directory Services User/Role Validation" with parameters like:

"100000, USERNAME, , Y, Y, N, "

Parameters

• Batch Size: Number of records that will be processed per commit cycle
• Fix dangling user/roles: Removes any user/roles where the user and/or the role does not exist in WF_LOCAL_ROLES
• Add missing user/role assignments: Adds any user/roles that are present in WF_LOCAL_USER_ROLES but missing in WF_USER_ROLE_ASSIGNMENTS
• Update WHO columns in WF tables: Controls the updating of who columns when corrupt records are corrected

2. Set the Enable Security Groups profile option to Yes at application level for the application relevant to the responsibility

3. Submit Program "CREATE FND_RESP WF ROLES"

創作者介紹

Aloz 的 Oracle ERP 天地

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