Search from 700 + Posts

Jan 6, 2018

APP-ALR-04020: Oracle Alert was unable to execute "&VALUE"

Solution to fix -APP-ALR-04020: Oracle Alert was unable to execute "&VALUE"


My a time execution of oracle trigger raised
---------------------------------
APP-ALR-04020: Oracle Alert was unable to execute "&VALUE" in Oracle alerts


BEGIN MO_GLOBAL.SET_ORG_ACCESS(0, null,'M'); END;

*
ERROR at line 1:
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.APP_EXCEPTION", line 72
ORA-06512: at "APPS.MO_GLOBAL", line 710
ORA-06512: at "APPS.MO_GLOBAL", line 727
ORA-06512: at "APPS.MO_GLOBAL", line 740
ORA-06512: at line 1
---------------------------------

Most common cause for this error is incomplete setup .Please validate & Complete below setup 

1. Navigate to : Alert Define
2. Button : Alert Details => Tab : Installations => Verify that the Alert is enabled for all Operating Units you want to use the Alert for.

Please note that as per Oracle this setup is very important as it will be included in the Alert Trigger definition.

The Alert database trigger will only fire if the Operating Unit set in the alert definition matches the org_id for your session.
The session org_id depends on the profile options : MO: Operating Unit, MO: Security profile and MO: Default Operating Unit

No comments:

Post a Comment