Order Management APIs Fail with ORA-20001 in MO_GLOBAL.INIT (Doc ID 973664.1)

Last updated on AUGUST 26, 2024

Applies to:

Symptoms

You are finding that eBusiness Suite APIs which complete successfully when run on the Server in 'native' SQL*Plus mode (that is to say, from the 'SQL>' prompt) are sometimes failing when run in client mode from a PC, either in SQL*Plus or SQL*Developer or similar.

The error message displayed is similar to:

ERROR at line 1:
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 498
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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.