Hi Apps DBAs,
We can activate Periodic Alert Scheduler in Oracle EBS Application
Step 1:Login to ORACLE EBS Application HOME PAGE with Alert Manager Responsibility
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 '%RAFI%';
USER_NAME
--------------------------------------------------------------------------------
RAFI
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 '%RAFI%';
RESPONSIBILITY_NAME
--------------------------------------------------------------------------------
TL System Administrator (Read Only)
TL System Administrator
Alert Manager
Step 2: We need to have alert Manager Responsibily 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.
Enjoy Apps DBA tasks....
Thanks,
Rafi
Nice post.
ReplyDeleteIt was very nice article and it is very useful to Oracle Apps DBA Commerce learners.We also provide Cub training software online training.
ReplyDeleteThx a lot For sharing such a nice information on
ReplyDeleteOracle 11g DBA Online Training
Valuable information thanks for sharing Oracle DBA Online Training
ReplyDeleteValuable information thanks for sharing Oracle DBA Online Training
ReplyDeleteThere are many more benefits of pursuing CAPM Certification Training in USA It draws out the hidden skills and increase your market value that can be much beneficial for the future.
ReplyDeleteNice Post & a good info. Persuing it is very beneficial CAPM Certification Training in USA This also increases the market value.
ReplyDelete