Articles on Emerging Technologies, Cloud Computing and Cyber Security

Wednesday, July 11, 2018

How To Setup An Event Alert To Monitor The Updated Profile Options

How To Setup An Event Alert To Monitor The Updated Profile Options

Define an Event Alert to Monitor all updates on Profile Options.

Every time a Profile Option is updated the Event Alert will Trigger and an E-mail will be delivered showing the Profile Option updated, the User that updated the Profile Option, the Value that was entered and the Level the Profile Option was updated

1) Follow the Setup from Note:577392.1 How To Check Oracle Alert Setup?

2) Define the Alert on Table : FND_PROFILE_OPTION_VALUES
But as Select use
SELECT fu.user_name,
po.profile_option_name,
pv.profile_option_value,
pv.last_update_date,
pv.level_id,
DECODE (TO_CHAR (pv.level_id),
'10001', 'SITE',
'10002', 'APP',
'10003', 'RESP',
'10004', 'USER',
'???')
INTO &user_name,
&profile_option_name,
&profile_option_value,
&last_update_date,
&level_id,
&decode_level_id
FROM fnd_profile_options po, fnd_profile_option_values pv, fnd_user fu
WHERE po.profile_option_id = pv.profile_option_id
AND fu.user_id = pv.last_updated_by
AND pv.last_update_date > SYSDATE - 1
AND pv.ROWID = :ROWID

3) As Output Under Actions / Action Details
For Action Type : Message enter your E-mail Address in the To field and as Text enter

Profile Option Update Details :
Updated By, Profile Option, Value, Update date, Updated at X Level
&USER_NAME, &PROFILE_OPTION_NAME, &PROFILE_OPTION_VALUE, &LAST_UPDATE_DATE, &LEVEL_ID, &DECODE_LEVEL_ID

0 Comments: