Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error with setting Multi Org Access in SQL Developer

John OApr 22 2021 — edited Apr 22 2021

Hi,
When I run the following script in SQL Developer I get an Error

begin
mo_global.init('M');
mo_global.SET_POLICY_CONTEXT('M', null);
end;

Below is the Error message I get .
"Error starting at line : 1 in command -
begin
mo_global.init('M');
mo_global.SET_POLICY_CONTEXT('M', null);
end;
Error report -
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile includes any operating unit or the profile option MO: Operating Unit is set.
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.MO_GLOBAL", line 36
ORA-06512: at "APPS.MO_GLOBAL", line 757
ORA-06512: at "APPS.MO_GLOBAL", line 700
ORA-06512: at line 2"

Comments

Processing

Post Details

Added on Apr 22 2021
0 comments
751 views