R12: MO: Security Profile is Called Only Site Level and MO_ORG_ACCESS_NO_DATA_FOUND Error is Occurred
(Doc ID 1663512.1)
Last updated on MARCH 11, 2019
Applies to:Oracle E-Business Tax - Version 12.1.3 and later
Oracle Payments - Version 12.1.3 and later
Oracle Applications Framework - Version 12.1.3 and later
Information in this document applies to any platform.
When you attempt to access Payments Manager, or Tax Manager, MO_ORG_ACCESS_NO_DATA_FOUND error is occurred.
However MO: Security Profile is set correctly and MOAC - Multi-Organization Access Control is not used.
This error is occurred only OAF pages.
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.
## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: 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 1
MO: Security Profile
Site Level: Setup Business Group
Responsibility level: AAA_BG
MO: Default Operating Unit
Site Level: NULL
Responsibility Level: NULL
MO: Operating Unit
Site Level: AAA_OU1
Responsibility Level: AAA_OU1
1. If you try to get FND debug logs, you cannot get any error logs.
2. If you set MO: Security Profile with AAA_OU1 at the Site Level, this error is not reproduced.
3. If your Setup Business Group is related with some operating units, this error is not reproduced.
For 3, if you get records with following SQL, this error is not reproduced.
HR.BUSINESS_GROUP_ID = 0 is Setup Business Group.
SELECT hr.organization_id organization_id
, hr.name name
FROM HR_OPERATING_UNITS HR
WHERE HR.BUSINESS_GROUP_ID = 0
AND hr.usable_flag is null;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|1. Bug Summary|
|2. Fixed Files|
|3. Recommended Patches|
|4. Solution Steps|