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

Last updated on MAY 28, 2017

Applies to:

Oracle Order Management - Version 11.5.10.1 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Sep-2012***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms