Order Management APIs Fail with ORA-20001 in MO_GLOBAL.INIT
Last updated on MAY 28, 2017
Applies to:Oracle Order Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Sep-2012***
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms