Oracle eBS經驗分享

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

有一個已經Allocate的Move Order的Sales Order Line被Cancel, 但Move Order Line卻未被Close, 造成Reserve住庫存, 致使新的Move Order無法順利執行Allocate

解決方法，可參考Notes:338740.1，有一設定值可使用

Go into the responsibility: Inventory
Goto Inventory > Setup > Organization > Parameters
Goto the first tab "Inventory Parameters"
Select checkbox 'Auto Delete Allocations at Move Order Cancel'

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

資料來源

11i Customer Interface Vs Oracle Base table

Here is summarize information for interface Vs base table. Once Customer Import get completed successfully , the data moved to these tables: