Mail Notification [message #655562] |
Fri, 02 September 2016 02:28 |
|
udaykuditipudi
Messages: 8 Registered: July 2016 Location: hyderabad
|
Junior Member |
|
|
Hi
How to get the notification if new internal organization is added to the master org (particular organization) in oracle.
|
|
|
|
|
Re: Mail Notification [message #655566 is a reply to message #655562] |
Fri, 02 September 2016 03:43 |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Is this an EBS database? Is so, you could look at using a Workflow or an Alert to invoke the utl_mail code to send the email.
|
|
|
Re: Mail Notification [message #655569 is a reply to message #655562] |
Fri, 02 September 2016 07:22 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
udaykuditipudi wrote on Fri, 02 September 2016 02:28Hi
How to get the notification if new internal organization is added to the master org (particular organization) in oracle.
There is nothing in an oracle database that knows anything about "internal organizations" or "master org". As Littlefoot said, you need to write a trigger or perhaps a recurring, scheduled transaction specific to your application. Or as John suggested, your application (EBS ??) may already have something you could leverage. But that would be specific to your application and beyond the scope of this forum.
As for how to use utl_mail if you end up having to write your own trigger or procedure, you should start with the documentation: http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/u_mail.htm#ARPLS384 Your quick response when Littlefoot mentioned this (only four minutes later)indicates you didn't even bother to look it up for yourself. People are here because they want to help when you get stuck, but it is expected that you show a little initiative . . .
|
|
|