如何從後台設定Profile

如果不小心刪除 Profile:MO Operating units Site-Level 設定值時，會導致整個Oracle EBS無法登入("Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit has been detected in FND_GLOBAL.INITIALIZE. )，此時就只能從後台來設定Profile，可以用下列SQL進行設定。

DECLARE
stat BOOLEAN;
BEGIN
DBMS_OUTPUT.DISABLE;
DBMS_OUTPUT.ENABLE(100000);
stat := fnd_profile.SAVE('ORG_ID', 101, 'SITE');

IF stat
THEN
DBMS_OUTPUT.put_line('Stat = TRUE - profile updated');
ELSE
DBMS_OUTPUT.put_line('Stat = FALSE - profile NOT updated');
END IF;

COMMIT;
END;