How to pass data perameter in Oracle Alerts?
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,