+3I want to change the Email Addresses in a event action Type E-Mail with a pl/SQL script.
I found the function FND_EVENT_ACTION_API.Modify
and prepared the Parameter:
Client_Sys.Add_To_Attr('ACTION_PARAMETERS', rec_.new_param, attr_);
But unfortunately it is not working. There is no error message but the text is not changed.
Can somebody help me?
Hello
This queue is for data migration topics.
To have an answer I recommend you to move this to the proper queue.
BR
+22
Normally, if you have a custom event action of type E-Mail the email address can’t be changed by using PL/SQL code. Maybe some screenshots with what you are trying to do would be beneficial.
+3Hallo Marcel,
thank you for your response.
I just noticed, that we have only 20 events, that use hard coded email addresses, so we decided to change them manually.
But perhaps you have an idea without making much effort.
I wanted to change this email addresses per PL/SQL script. I wrote a script with a loop, that looks for all events with a specific domain.
No error occurs but the address wasn’t changed.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
