Technology Stack - EBS (MOSC)

MOSC Banner

How to pass data perameter in Oracle Alerts?

edited Aug 20, 2021 11:54AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Hello,

I'm building oracle alerts to lock unused responsibilities.

In alert definition in "Select Statement" is:

select USER_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, RESP_DESCRIPTION, RES_START_DATE

INTO

&UID, &RID, &RAID, &RD, &RSD

from XX_FND_USER_RESP_USE

where RESP_LAST_USED_DAYS>90 and USER_NAME='TESTUSER' and RESPONSIBILITY_ID in(53182,50680);

Important, the "RES_START_DATE" is Date type.

Then in actions I'm using Action type "SQL Statement Script" with code:

BEGIN

fnd_user_resp_groups_api.Update_Assignment(

user_id => &UID,

responsibility_id => &RID,

responsibility_application_id => &RAID,

start_date => &RSD,

end_date => sysdate,

description => '[UNUSED] '||&RD,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center