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 FEBRUARY 13, 2017

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.

Symptoms

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.

MO_ORG_ACCESS_NO_DATA_FOUND
---------------------------
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.

Error stack
----------------------------
## 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
;

 
Example Setup
================
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

NOTE:
 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;

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