Forum Stats

  • 3,770,480 Users
  • 2,253,121 Discussions
  • 7,875,481 Comments

Discussions

Error with setting Multi Org Access in SQL Developer

John O
John O Member Posts: 18 Blue Ribbon
edited Apr 22, 2021 3:26PM in SQL Developer

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"