We need to Login the Oracle EBS Application HOME PAGE with Alert Manager Responsibility or else assign the responsibility to the User
In the Database we can login with ‘Apps’ user and check the user exists
SQL> SELECT USER_NAME from fnd_user where USER_NAME like ‘%ABC%’;
USER_NAME
——————————————————————————–
ABC
How to check responsibilities assigned to a user:
SQL> SELECT B.RESPONSIBILITY_NAME
FROM FND_USER_RESP_GROUPS A,
FND_RESPONSIBILITY_VL B,
FND_USER C
WHERE A.responsibility_id = B.responsibility_id AND
C.user_id = A.user_id AND
(to_char(A.end_date) IS NULL
OR A.end_date > sysdate)
AND C.user_name like ‘%ABC%’;
RESPONSIBILITY_NAME
——————————————————————————–
TL System Administrator (Read Only)
TL System Administrator
Alert Manager
Step 2: We need to have alert Manager Responsibility to do this task.
We need to Navigate to Alert Manager Responsibility
Navigate to alert ->Define ;Go to Request->Schedule
there we can see periodic Alert Scheduler =>Active it (Click on Activate button)
Screenshot below for reference.
