Create Alerts in Oracle Fusion using Alerts Composer

[@ayatelnabawy6696]

Hi Nareesh, usually in EBS we create sql to build the "WHERE CONDITION" for firing the alert. Ex: when customer limit is consumed by 80%, send to the customer contact email. Now in your video, I can't see what is the condition for triggering the alert; Can you Please clarify? Thank You!

[@TechTalkwithNaresh]

@user I have few more videos on alert. Please go through that, if still u have questions write me back.

[@gopinathblr84]

Hi naresh if you can please explain how do we get demo fusion instance

[@TechTalkwithNaresh]

@Gopinath You can get it from Oracle or any external vendor.

[@kalyanisundaram3790]

Very useful keep up the good work 👍👍.

[@TechTalkwithNaresh]

@Kalyani Thanks for Acknowledgement. Subscribe to get latest updates.

[@malligasellam3251]

How do we preview the Birthday email image notification in the alert history

[@TechTalkwithNaresh]

@User Try to use filter and check.

[@venugopalreddy7268]

Nice content sir...

[@TechTalkwithNaresh]

@Venu Thanks for Acknowledgement

[@DaynaRobinson-t5x]

But the alert didn't have any criteria for the prompt...like a change in vendor master or NSF check return...something like that

[@TechTalkwithNaresh]

@User Can you please elaborate what you have to say.

[@DaynaRobinson-t5x]

@@TechTalkwithNaresh for example: maybe I want to receive an alert that tells me everytime a customer pays...like shouldn't the alert be based on some type of event?

[@madhuripatil6887]

Nice contents

[@TechTalkwithNaresh]

@Madhuri Thanks for Acknowledgement

[@youcandoitbwb3221]

Naresh, in this specific demo, it appears you had an issue getting the Alert to run. You had specified a destination of 'Worklist', but believe due to the changes you were making to the Alert scheuled start date, it did not fire. Would have been nice to see how the results looked based on the formatting specified. The setup of the Alert through Composer looks odd compared to Alerts in EBS.

[@TechTalkwithNaresh]

@Brian Thanks for the info, what you suggest.

[@youcandoitbwb3221]

@@TechTalkwithNaresh Would be good to at least see what the end result formatted Alert email/workslist item looks like. You spent quite a bit of time on how to setup, access, and create the Alert. But did not show how it would appear to the recipients of the Alert.

[@TechTalkwithNaresh]

@Brian I will upload the new video including all soon.

[@p51mustang31]

Is this Alert Composer only for the HCM module, or can I use it for the ERP/SCM modules as well?

[@TechTalkwithNaresh]

@P52 If any activity of SCM is listed in the comploser then we can use it for SCM or other modules as well

[@urmadhu6367]

Can we pass any dynamic attributes in the expression? For example . i want the minimum of activity date condition. i have used below query. TRUNC(sysdate)+1 = (SELECT Min(Trunc(c.ACTIVITY_DATE)) FROM wlf_li_classes_f a ,wlf_li_activities_f b ,wlf_li_activity_details_v c WHERE 1 = 1 AND a.Delivery_mode = 'ORA_BLENDED' AND a.LEARNING_ITEM_ID = b.PARENT_LEARNING_ITEM_ID AND b.PARENT_LEARNING_ITEM_ID = c.OFFERING_LEARNING_ITEM_ID AND c.ACTIVITY_DATE IS NOT NULL AND c.COURSE_ASSIGNMENT_RECORD_ID = ${assignmentRecordId} ) but it is not giving the records. It is giving the records when we hardcode the values like below. TRUNC(sysdate)+1 = (SELECT Min(Trunc(c.ACTIVITY_DATE)) FROM wlf_li_classes_f a ,wlf_li_activities_f b ,wlf_li_activity_details_v c WHERE 1 = 1 AND a.Delivery_mode = 'ORA_BLENDED' AND a.LEARNING_ITEM_ID = b.PARENT_LEARNING_ITEM_ID AND b.PARENT_LEARNING_ITEM_ID = c.OFFERING_LEARNING_ITEM_ID AND c.ACTIVITY_DATE IS NOT NULL AND c.COURSE_ASSIGNMENT_RECORD_ID = 300000173679110 ) could you please suggest something please? severity- high, please respond.

[@TechTalkwithNaresh]

@Madu I had not tryed any time with the dynamic attribute. I will try to create a case and revert you asap.

[@urmadhu6367]

@@TechTalkwithNaresh sure thanks in advance

[@LeelaRek]

can you please explain how does 'on demand' run option works? can I fire an alert based on the condition?

[@TechTalkwithNaresh]

@Leela Yes you can fire the alert based on the conditions. As the ise of alert is to send the notification on specific conditions.

[@421murthy]

Hello Naresh, Can you please let me how to add images in Alert composer. We are adding images but not displaying the images

[@TechTalkwithNaresh]

@Murthy What error you are getting?

[@p51mustang31]

@Tech Talk's with Naresh - Is there some kind of event I can subscribe to when a CMK (Collaboration Messaging) message in Fusion is created that has a particular status of "Failed" or "Error" that I can monitor/alert for in real-time?

[@TechTalkwithNaresh]

@P51 I had explained in video how to monitor the alert, you can perform same.

[@p51mustang31]

@Tech Talk's with Naresh My question is whether I can subscribe to a CMK message being created with this tool? The only events I saw in this Alert Conposer was for HR related events.

[@mcbbuyer]

Hi Naresh, I want a alert/Message Prompt to the PO receiver. If the receiver is correcting the receipt, and if the invoice is already created for the PO, receiver should get a message that the invoice exists for the PO. So basically, can we have a message prompt based on some logic while the user is performing a transaction.? Thanks in Advance.

[@TechTalkwithNaresh]

@Mcb Can you try by providing/using the SQL in the Alet.

[@kalyanisundaram3790]

If we scheduled the alert ended within one day. It will be there or gone.can we schedule it after end date passed.

[@TechTalkwithNaresh]

@Kalyani Yes we can use same alert which last schedule is ended for responding.

[@snigdhajain9427]

The requirement is that whenever Supplier is created in the system, an alert should be sent to specific users. Is it possible

[@TechTalkwithNaresh]

@Snigdha How you are trying to send the alert and for what purpose?

[@snigdhajain9427]

@@TechTalkwithNaresh Client wants whenever he creates any New supplier in Oracle cloud post go live , an alert should be sent to Purchasing team that a new supplier has been created in the system

[@TechTalkwithNaresh]

@Snigdha You can send alert if the row count is increased in the supplier table. After sending the count u can update the current count in custom table and check with that count instead of hard coding. This is one approch you can find any other approch also if possible. Upload me on the solution.