Workflow :: To Send Notifications To Multiple Supplier Email IDs?

Aug 26, 2013

I have a custom concurrent program which has a SQL query which returns multiple rows. Each row is a for each supplier e.g. 

Supplier1      sup1@gmail.com     123     5000Supplier2      sup2@gmail.com      456    4000Supplier3      sup3@gmail.com      789    3000 

This set is returned based upon some criteria mentioned in the where clause of the SQL.Ultimate aim is to send 1 notification to each of the email id's and those notification should have the corresponding attribute values. 3 notifications fired from a workflow triggered by the concurrent program (which actually returns this 3 rows in a SQL)Supplier 1 to receive  5000Supplier2 to receive  4000Supplier3 to receive  3000 My approach / or the only approach coming in mind is using a cursor for the SQL inside the concurrent program and using a for loop, initiating the workflow each time for a loop iteration i.e for each iteration of loop , workflow procedure will need to be initiated, so item type will be same but item key will of 3 different item key.  is it somehow possible to fire only one instance of workflow and not 3 different instances to send 3 notifications. Ad hoc role creation would not be option here because the number of rows may be large and not just 10-15.

View 0 Replies


ADVERTISEMENT

Workflow :: Send Attachments To Requester In AP Invoice Approval Workflow

Sep 4, 2012

We are on 12.1.3 Apps.

We want to be able to send attachments at the invoice header level with the invoice approval workflow email as attachments. The standard workflow does not provide this functionality.

We were able to achieve this functionality using the approach given here:

[URL]........

Basically we added a document type attribute to the notification message, and set a BLOB variable to it inside our custom procedure, which is set as the function for the notification: DOCUMENT_APPROVAL_REQUEST.

Now we are able to see the attachments coming as attachments in approval request emails to the approvers. But the issue is that the first approver on the list, the requester is not seeing the attachments. All the other approvers can see the attachments. We have checked the WF Role for the user and the Notification preference is set as MAILHTML

As far as i can see, same notification and same message is used to send the email to all approvers including requester. Then why only requester is not getting the attachments?

View 0 Replies View Related

Workflow :: When Set Vocation Rule - It Stuck All The Users Notifications

Sep 3, 2012

I am working on Workflow and the issue is When a person leaves for vacation he can set his vacation rules so that someone has to attend / approve his workflow notifications. But when we set vocation rules all notification goes into errors state and this error can resolve by refreshing/Retry this notification. And the error detail is mentioned below An Error occurred in the following Workflow.

Item Type = CONCSPL
Item Key = 086937-15990
User Key =

Error Name = 100
Error Message = ORA-01403: no data found
ORA-01403: no data found
Error Stack =
Wf_Engine_Util.Function_Call(cust_f_test.f_find_approver, CONCSPL, 086937-15990, 180198, RUN)

[code]....

Bottom line is all notifition should be successfully process and send to dedicated person.

View 2 Replies View Related

Server Administration :: Alert Email Notifications?

Mar 20, 2011

I'm trying to set up alert notifications. I have to program it myself, because SE isn't allowed to do it with OEM. As far as I can see from the documentation, this should be all that is necessary:

conn / as sysdba
exec dbms_aqelm.set_mailhost(mailhost=>'127.0.0.1')
exec dbms_aqelm.set_mailport(mailport=>25)
exec dbms_aqelm.set_sendfrom(sendfrom=>'alert@noreply')

[Code]......

but this gives me:

ORA-24940: invalid combination of ANONYMOUS namespace, default presentation and
e-mail receive protocol
ORA-06512: at "SYS.DBMS_AQ", line 737
ORA-06512: at line 11

I must be missing something! Probably something very basic. There is nothing in any trace files.

View 2 Replies View Related

Sending Email Notifications / Alerts Via Enterprise Manager 11g

Feb 24, 2013

I have Oracle 11g on Linux...and i have set up SMTP of my Enterprise Manager Database control. I click on Test and an email was sent successfully. What i don't know is how to add more emails as the recipient of the alerts.

I have setup metrics like number of sessions, cpu usage, buffer cache hits, swapping, tablespace usage, etc...Upon saving and waiting for transactions to come in, alerts were shown the the EM homepage..but i did not receive any emails.

View 2 Replies View Related

Test Instance With Oracle 11gR2 - EM Sending Email Notifications Too Late

Feb 18, 2013

On a test instance with Oracle 11gR2 with Enterprise Manager Database Control I try to activate the Email Notifications in Enterprise Manager, so that I can use them for monitoring.

So i configured following settings:

Under Setup -> Notification method I gave him a valid mail address with a vaild SMTP server. The test mail was send successfully.

Under Preferences -> General i gave SYS a valid mail address to receive. The execution plan i let in standard configuration, so every time at everyday i will get an email, when something happens. the test mail was send successfully too.

Now i created an own rule to test the configuration:

I went to Preferences -> Rules an add an rule. Name and description I named "test" and set "database instance". At availability I activated all checkboxed, so i should be informed when the instance goes down, comes up, getting an error, when the error is fixed, when agent is not available, when agent is available again, when there is a metric error, when the emetic error is fixed, when a blackout starts and when it ends.

Metrics, policies and jobs there wasn't defined anything in standard, so i let it so and set nothing here. I activate the checkbox for sending emails to sys and sending repeat emails every 15 minutes 3 times at all.

Now, to test this notification i logged into my testserver and killed the listener process, to see, what will happened. After 1 Hour waiting i didn't get any email, so i restarted the listener. after the listener was started my outlook was fluted by emails from the server, that the listener was down. But why i didn't get them earlier.

I checked the procedure with the database to, here i get it down by "shutdown abort" and "shutdown immediate". But i get the mails, that the database is down, when its up already. And thats to late!

When I want to use such email notifications for productive servers and someting is going wrong, for that a notifications is configured of course, I want to get the mail directly, when that happened and not, hen the problem is fixed!

For example, here an email from testing, where the listener was down, that i've get at 13:01 :

Target Name=LISTENER_<hostname>
Target Type=Listener
Host=<hostname>
Metric=Status
[code].........

View 2 Replies View Related

Workflow :: How To Get Response Of Notification Email From MS Outlook Express

Oct 20, 2012

I have two questions:

1. Our business users had a requirement to approve or reject the Workflow Notification Emails form their Email account on MS Outlook Express. When they perform action from MS Outlook Express it sends email to wfmailer but no action perform in application. The notification inbox in application shows this notification as OPEN notification and the requested function also shows 'Waiting for Approval'.

2. I need to hide Request Information button/link from the email notification send through Workflow mailer to user. There are three actions button available in email notification Approve, Reject and Request Information. I need to have only two button Approve and Reject. How to hide Request Information button.

View 3 Replies View Related

Workflow :: R12.1.3 Sourcing Award Approval Notification - Email Attachment

Oct 9, 2013

I have a requirement where I have to show attachment in R12.1.3 Sourcing Award Approval Notification.I am able to achieve this by adding #ATTACHMENTS attribute in the message and Attachment appears in the Notification in the E-Business work list but somehow its not appearing in "e-mail notification". 

View 0 Replies View Related

Scheduler :: How To Add Email Notifications To A Scheduler Program

Aug 9, 2013

We have a scheduler chain that calls 2 scheduler programs.The chains are controlled by a scheduler job that has job_type as CHAIN.My challenge is how to add email notifications on the failure or success of the programs.

I know about this procedure DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION, but this is only applicable to jobs and not programs(i believe). Is there an alternative way to trigger off emails for scheduler programs ?

View 0 Replies View Related

SQL & PL/SQL :: Send Email In Oracle?

Apr 24, 2013

what is the best way to send an email in oracle?

1.utl_smtp
2.utl_mail
3.utl_tcp

View 6 Replies View Related

SQL & PL/SQL :: How To Send Email With Attachment

May 4, 2010

I need to send email with attachment file. The input file is reside in the server. Currently, i can create and send file through the email. But it is not the file that i want from the server, it is actually create the attachment file. How can i get the file from server and put it as attachment? below is the codes :

create or replace
Procedure test_email_mt(p_sender IN VARCHAR2,
p_recipient IN VARCHAR2,
p_message IN VARCHAR2)
as

[code]...

View 5 Replies View Related

SQL & PL/SQL :: Send Email From Procedure

Dec 9, 2010

Need info regarding sending an excel file attachment from plsql.I am using utl_smtp package in procedure and want to attach some sql query results in excel file.Is it possible to use sql query in same stored procedure that i am using to send the email attachment or i need to use external directory path to load the file as attachment.

View 9 Replies View Related

Forms :: Send Email Through 6i?

Nov 11, 2011

i want to send email and message on mobile phone through forms 6i.

View 1 Replies View Related

SQL & PL/SQL :: Send HTML Email From Oracle?

Dec 21, 2009

Am trying to send email from Oracle using utl_smtp.

My issue is regarding Arabic character. I set the charset to windows-1256 and even tried with other different charset like UTF-8.

I used also: utl_smtp.write_raw_data(l_connection,utl_raw.cast_to_raw(dbms_lob.substr(data).

Before i set all these changes to the procedure i was receiving the Arabic text as '??????'

However, after above modifications, the text display changed to something like this : ÇäÇÓààååÑêå

Does the problem still in the DB side or it can be coming from mail server ?

View 24 Replies View Related

Forms :: How To Send Email From Oracle 10g

Sep 27, 2011

I wanted to send email from oracle 10g forms at any hotmail,yahoo and gmail so how can i send.

View 16 Replies View Related

SQL & PL/SQL :: Unable To Send Email From Oracle XE?

Jun 23, 2010

I have ORacle XE installed on my machine and everything works fine. I can connect to it using forms, run my application etc. Now, I wanted to write a proc which can send email from Oracle XE.So after investigating, I think UTL_SMTP and UTL_MAIL are my options. For which I need to enable the ut_mail package and one more which I have done. But everytime I run a package, I get the error

DECLARE
v_From VARCHAR2(80) := 'oracle@mycompany.com';
v_Recipient VARCHAR2(80) := 'test@mycompany.com';
v_Subject VARCHAR2(80) := 'test subject';
v_Mail_Host VARCHAR2(30) := 'mail.mycompany.com';
v_Mail_Conn utl_smtp.Connection;
crlf VARCHAR2(2) := chr(13)||chr(10);

[code].....

Ora 29278 SMTP transient error.

View 13 Replies View Related

Forms :: 10g - Send Email From Application?

May 28, 2013

I want to send an email from my Application forms 10g .But I receive

DECLARE
l_mailhost VARCHAR2(64) :=... //admin mail
l_from VARCHAR2(64) := ... //admin mail
l_to VARCHAR2(64) := ...//user mail
l_mail_conn sys.UTL_SMTP.connection;

[Code] ........

message displayed is: no internet connection !!

View 3 Replies View Related

Forms :: Email Send From Oracle 6i?

Jun 25, 2012

tell the setting and code how send email through oracle?

View 4 Replies View Related

PL/SQL :: Attached XML File And Send Email

Jan 18, 2013

I have ready xml file of around 100KB at location C: est.xml .

Now I just want to attached this file and send email to particular person using Oracle PL/SQ . can I get code for that?

View 1 Replies View Related

SQL & PL/SQL :: Send Email Using UTL_SMTP With UTF-8 Coding

Dec 30, 2011

I'm trying to send e-mail using UTL_SMTP with UTF-8 coding. I have a problem that the UTF-8 letters become `?`.

So here is the

p_to varchar2(250);
p_from varchar2(250):='email_address';
p_subject varchar2(250):='...vienotā...';
P_smtp_hostname varchar2(255) := 'IP';
P_smtp_portnum varchar2(5) := '25';
[code].......

The code is taken an example from internet source. Everything works fine but the UTF-8 not .

View 21 Replies View Related

Send Email With Attachment Using Stored Procedure?

Jun 17, 2011

I would like to send an email with attachment using a STORE PROCEDURE, with a PL/SQL, I was testing a package called SRW.RUN_REPORT but the problem is that the report generate a pdf file but this file is storage in application server because the report server run over the application, wo we can not get the physical file to send as attach.

the problem is generate the pdf file save in a place that we can get easier.

View 8 Replies View Related

Forms :: How To Send Pic And TEXT In Email Using PLSQL

Jun 13, 2010

I am create procedure send the message in form bulider10g to Internet email and the procedure is work .

but now I want to modify this procedure , I want to add picture of my country ( logo ) and the original message . why cant display the image in my email ?

this code of image

<p align="center"><img border="0" src="logo.gif" width="20" height="20"></p>

I Think the problem of this code because 'Content-type: text/html' not image ?????!!!!!!!

utl_smtp.data(v_Mail_Conn, 'MIME-Version: 1.0' ||CHR(13)|| CHR(10)||'Content-type: text/html' || CHR(13)||CHR(10)||mesg);

procedure

EMAIL_SEN VARCHAR2(250);
EMAIL_REC VARCHAR2(250);
DESC_EN VARCHAR2(250);
UB_SEQ NUMBER(10);
BEGIN
DECLARE
v_From VARCHAR2(80) :=admin@yahoo.com ;
[code].........

View 2 Replies View Related

Reports & Discoverer :: Send Report PDF Through Email

Jun 4, 2012

i have installed oracle application server forms and report services, and i am deploying my forms and reports on it and its working fine, now i have a new requirement to send email through reports. I am already generating reports on pdf form and displaying on screen. How can i send this report PDF as an attachment and send it to different email addresses or how can i setup oracle application report services to send emails as an attachment.

View 3 Replies View Related

Application Express :: Can't Send Email Using 3.0.1.00.07 Oracle 10g

Jul 17, 2012

Can't send an email using Application Express 3.0.1.00.07 on oracle 10g.

my code is:
DECLARE
l_body CLOB;
v_email varchar(30);
BEGIN

SELECT CONTACT_EMAIL
INTO v_email
FROM persal_info
WHERE TRIM(PERSAL)= TRIM(:P48_PERSAL);
l_body := 'Your access code for the Transport system is:'|| :P48_CODE ;
l_body := l_body || '

This access code is needed in order for you to complete the claim form. It is important to change this access code for the confidentiality of your information.';

apex_mail.send( p_to => v_email,
p_from => 'PietC@google.com',
p_body => l_body,
p_subj =>'Access Code'
);

View 1 Replies View Related

Forms :: How To Send Automated Email From Oracle Form

May 10, 2011

I have to send several reports to various branch via email, I created a branch table in which email of that branch is stored in a column. Now if report is generated for particular branch, its PDF should also be sent via email to that branch, How can this be done on When Button Pressed,

View 1 Replies View Related

SQL & PL/SQL :: Unable To Send Email Through Google To Private Domain

Dec 1, 2012

how to send email (PL/sql Procedure) to private domain through google mail.

View 2 Replies View Related

User-defined Metric Doesn't Send Email

Dec 18, 2010

I'm attempting configure User-defined Metric to send mails when happen warning or critical alerts .My environment is Cluster Database and I'm using OEM Grid Control

I created User-defined Metric for monitoring invalid object for example and scheduled this collect to every 5 minutes.On initial OEM page, I see alert violation, but don't receive mail for this. In my Notification Rules page, I added "User-Defined Numeric Metric" and includes object Check_Invalid_Objects, wich is my UDM.I receive several alerts violations, but don't UDM.

 UDM_Violation.png ( 116.68K )
Number of downloads: 0

 NotificationRule.jpg ( 218.78K )
Number of downloads: 0

 ScheduleNotification.jpg ( 373.64K )
Number of downloads: 0

View 6 Replies View Related

Reports & Discoverer :: How To Generate Report And Send Straight To Email

Apr 11, 2013

How to generate a report and straight send it to an Email? I want to match student reg number and the parents email provided .

View 1 Replies View Related

Server Utilities :: Send Email After Export Done (successfully Without And With Error )

Jun 16, 2011

I have a ORACLE 10g(10.2.0.1.0) database that I am running on windows. I have export backups batch file running every day through windows scheduler. I would like to know If there is some way that sends me an email after the backup is finished and also send me if it does not finish with error.

I have successfully done this om my SQL Server machine but don't know for ORACLE as I have not purchased it and have license

View 16 Replies View Related

SQL & PL/SQL :: Send Email Attachment Using Utl_mail.send_raw Utility And Not Successful

Jun 6, 2011

I am trying to send an email attachment using "utl_mail.send_raw" utility and not successful. Constantly I keep getting an error:

"ORA-20001: An error has occured: ORA-20001: ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "APPOWNER.SANDEEP_CT_FILE", line 103"

I think it's emanating from "ORA-06508: PL/SQL: could not find program unit being called".

a) this morning my production dba " utlmail.sql in DEVELOPMENT as sys.

b) Create or replace directory TEMP_SANDEEP as '/u01/data' (This was created so that BFILENAME could read it + "dbms_lob.fileopen" needs to access this from Oracle directory and not Operating system directory)

c) 'u01/data' exists on Unix development box.

d) Then I created the following procedure to create a text file (text file's name is currentdate.txt i.e. 06062011.txt) that has some information. Once created, the UTL_MAIL.SEND_RAW should pick this file up and email this to concerned parties(and in this case it's me as I am doing this on development environment).

Code for the above is as follows:

CREATE OR REPLACE procedure sandeep_ct_file is
/*Variable declarations */
v_dir_location varchar2(100);
v_file_name varchar2(100);
v_file_handle UTL_FILE.FILE_TYPE;
v_report LONG := chr(10)||'Prog Code' ||' '||
[code]....

Do I have to defined SMTP connections and parameters?

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved