Alert not firing Conc. prog.
Date: Tue, 22 Jun 1999 16:37:31 -0700 (PDT)
From: Nirmal Kumar appsdev_99@yahoo.com
Subject: URGENT:Problems in Alert
Hi Folks,
I am working on oracle application 11.0.2.Server is solaris 2.6. I got a problem with
alert.I got a concurrent program as alert member.When the event occurs ,oracle alert
couldn't run the concurrent program.It's saying APP-04050-Oracle alert could not submit
the concurrent program CONCURRENT OE SALOESOD '5000001', '50000001'.Contact ur support
reprentative. Could any one pls help me on it?
Thank You
Alert not working in Rel 11.03 in NT
Date: Thu, 24 Jun 1999 18:02:02 -0700 (PDT)
From: siddhartha nandi sid_nandi@yahoo.com
Subject: Alert not working in Rel 11.03 in NT
Hi,
does alert works on NT in REL 11.03. We are trying with Oracle without success so far. Did
anybody has success so far. Your help is appreciated.
Thanks,
Sid.
===
Sid Nandi
Sr. Principal Consultant
Millennia Vision Corporation
Snandi@mvsn.com
650-232-6330 (230)
Alert - Indexes near max. extents
Date: Tue, 13 Jul 1999 10:13:19 +0300
From: Kik Nichol m_sharawy@tccbce.com
To: "'Ora App'" oraapps-l@cpa.qc.ca
Subject: Alret problem
when I tried to define actions for alert (indexes near maximum extents) I got
FRM-40735:POST-Query trigger raised unhandled exception PROGRAM_ERORR
after pressing ok I got FRM-40735:WHEN-NEW-RECORD-INSTANCE trigger raised unhandled
exception PROGRAM_ERORR.
then I could not close the form!!! thanx
Date: Tue, 13 Jul 1999 08:15:12 -0500
From: "Hostetler, Don" Don.Hostetler@impacgroup.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Alert problem
To solve the issue you can rebuild the index and/or grant the index additional extents.
Check the alert log to see what index is in question.
EX: (from sqlplus)
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N7 STORAGE ( next 1M MAXEXTENTS 2000);
Regards,
Don Hostetler
Alert on NT using MS Exchange
Date: Mon, 19 Jul 1999 16:00:24 -0400
From: "West, Bob" BWest@MFPS.COM mailto:BWest@MFPS.COM
Subject: Oracle Alert on NT
Does anyone out there have any experience setting up Oracle Alert on NT using MS Exchange?
We don't seem to be able to get it to work even with Oracle's help( surprise, surprise).
Any help would greatly be appreciated.
Thanks,
Bob West
(717)262-1714
bwest@mfps.com mailto:bwest@mfps.com
Martins Famous Pastry Shoppe Inc.
Date: Mon, 19 Jul 1999 15:09:19 -0500
From: "Barry Hammon" barry.hammon@wwt.com mailto:barry.hammon@wwt.com
Subject: Re: Oracle Alert on NT
Hello Bob,
We haven't been unable to get Oracle Alerts to send e-mail on Windows = NT/Microsoft
Exchange. I've been working on it with Oracle Support since = April. Assistance from
anyone would be greatly appreciated.
Thanks, Barry L. Hammon - Senior Consultant
World Wide Technology, Inc.
62 Weldon Parkway
Maryland Heights, MO 63043
Phone: (314) 919-1531; Fax: (314) 919-1626
Toll Free: (800) 432-7008, Ext. 1531
E-mail: barry.hammon@wwt.com=20 mailto:barry.hammon@wwt.com=20
Date: Mon, 19 Jul 1999 13:31:14 -0700
From: "Catherine Gauchat" catherine_gauchat@tcibr.com
Subject: Re: Oracle Alert on NT
Hi Bob,
Add me to the list of people who need help with this! We have gotten to the point that the
message show up in the Exchange outbox but never gets sent.
Catherine
Apostrophes in Oracle
Date: Thu, 29 Jul 1999 16:28:51 -0400
From: Margaret_Mason@keybank.com
Subject: Alerts: Handling Apostrophes in Oracle
Hello everybody,
We use Oracle Alerts in conjunction with Oracle Interoffice. We are seeing that the
e-mails which are sent out using Oracle Alerts consisting of apostrophes are bombing out.
Is there anybody who is having a similar problem like this.
Any info would be highly appreciated.
Thanks,
Margaret
Alert on import of Journal Entries
Date: Mon, 9 Aug 1999 09:06:57 -0500
From: "Sharma, Rajiv" rsharma@ameritrade.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Alert for journal entries posted
Hi everyone
On a similar note is there a way to have a single alert after a Journal import instead of
the alert firing for every single line imported.
Thanks
Rajiv
For the earlier post referenced in this mail 
Automatic Mail Message to Pager
From: "Jai palan" jai_palan@hotmail.com
Reply-To: oraapps-l@cpa.qc.ca
Date: Fri, 20 Aug 1999 17:45:31 -0400 (EDT)
Hi all,
I want to page to some person automatically if one of my MRP process is not running....
Has anybody has any knowledge about tgis .pls share with me..
Tks Jai..
From: Venkatraman Gopalakrishnan [mailto:gvenkat@oracleassist.com]
Sent: Friday, August 20, 1999 3:32 PM
To: Multiple recipients of list
Subject: Re: Automatic mail message to pager...
Use alerts
venkat
Date: Mon, 23 Aug 1999 09:33:16 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Automatic mail message to pager...
Hi,
If the pager is alphanumeric, you can page them with their email address.
For ex: I get paged to 4082762664@alphapage.airtouch.com. ( no. is wrong here ) You can
find out the pager's email address and use your mailx command ( or whichever command you
wish to use ) to page to that pager.
I also get pagers whenever there is FND lock on FND objects and whenever the PROD database
goes down and whenever the conc. mgr.s go down.
If the pager is numeric, please check BARBARA MATHEWS presentation on Conc. Mgr. on Search
Engine how she gets paged to her numeric pagers.
Thanks, -chakrapani
Alert in Summary Format
Date: Tue, 24 Aug 1999 14:22:18 EDT
From: "Apps User" apps_user@hotmail.com
Subject: ALERTS
Hello,
I am trying to write an alert. The Alert is in Summary format. In the select statement we
have "INTO" clause, everytime an alert fires-in the email all the elements are
jumbled. Am I missing anything why is that this is happening.
Thanks in advance
Date: Tue, 24 Aug 1999 13:42:50 -0500
From: "Anil Kumar (ns)" akumar@cap.org
Subject: RE: ALERTS
Give some more details, so that we can understand your problem clearly. Version?
Formatting alert message is little bit painful especially if you have too many fields in
your select statement and you want to lot of information in your alert message. Be
specific, what exactly is happening. It depends on where you are placing your &fields
and length of the values retrieved by each field. Use format masks for number fields. Try
to place any description fields at the end. These are the fields which have variable
length. This will eliminate some formatting pain.
Date: Tue, 24 Aug 1999 14:52:14 -0400
From: Madhuri Mokarala mmokaral@Netrai.coresys.com
Subject: RE: ALERTS
Hi ,
When alert select statement is formatted the parameters(after into) holding the values
should be in the same order as the ones you have selected. If this doesnt solve your
problem explain in detail what exactly jumbling of elements is?
Best regards Madhuri
Date: Tue, 24 Aug 1999 14:59:13 EDT
From: "Senthil Anand" sa272@hotmail.com
Subject: Re: ALERTS
Hi,
Formatting in alert is the toughet part provided u have more parameters to be printed.
Check the coulmn overfow field specification to match ur message parameters properly
Senthil
Date: Tue, 24 Aug 1999 15:05:47 -0400
From: "Reddy, Rajasekhar" Rajasekhar.Reddy@fmr.com
Subject: RE: ALERTS
Clear out the SQL statement and variables and put the SQL statement back and it will
automatically put the variables in the same order.
-Raj
Date: Tue, 24 Aug 1999 15:43:22 EDT
From: "Apps User" apps_user@hotmail.com
Subject: ALERTS
OK here is the exact statement I am writing. This is an alert which fired when there is a
Requisition which is entered for more than $10,000.
============================================
SELECT
h1.segment1 segment1,
h1.description description,
l1.quantity quantity,
l1.item_description item_desc,
ppfa.full_name requestor,
ppfb.full_name buyer,
PO_REQUISITION_HEADERS_PKG.GET_REQ_TOTAL(h1.REQUISITION_HEADER_ID)
Total,
(l1.quantity*l1.unit_price) Qty
INTO
&segment1,
&description,
&quantity,
&item_desc,
&requestor,
&buyer,
&total,
&Qty
FROM
po_requisition_headers_all h1,
po_requisition_lines_all l1,
per_people_f ppfa,
per_people_f ppfb
WHERE
h1.requisition_header_id = l1.requisition_header_id
and h1.preparer_id = ppfa.person_id
and l1.suggested_buyer_id = ppfb.person_id
and h1.authorization_status = 'IN PROCESS'
and h1.segment1 in
(
SELECT
h.segment1 segment1
FROM
po_requisition_headers_all h,
po_requisition_lines_all l
WHERE
h.requisition_header_id = l.requisition_header_id
and h.authorization_status = 'IN PROCESS'
and l.cancel_flag is null
GROUP BY
h.segment1
HAVING
sum (l.quantity*l.unit_price) > 10000
)
and h1.last_update_date
to_date(:DATE_LAST_CHECKED,'DD-MON-YYYY HH24:MI:SS')
GROUP BY
h1.segment1, h1.description, l1.quantity, l1.item_description,
ppfa.full_name, ppfb.full_name,
PO_REQUISITION_HEADERS_PKG.GET_REQ_TOTAL(h1.REQUISITION_HEADER_ID),
(l1.quantity*l1.unit_price)
===================================
Action Details:
Requisition Number &segment1 has been entered for $&Total
Requisition Description: &description
Requisition Details
=**= Enter summary template below this line =**= **
Quantity: &quantity
Item Description: &item_desc
Total: &Qty
Requestor: &requestor
Buyer: &buyer
=**= Enter summary template above this line =**=
=====================================================
The output I receive 2 messages instead of one:
1st Message:
Requisition Number 31950 has been entered for $8450
Requisition Description: Test
Requisition Details
Quantity: Luxmoore, Mr. Max
Item Description:
Total: DLT TYPE IV TAPE, 35-70GB
Requestor: Green, Ms. Jamilah C
Buyer: 1619
Second Message:
Requisition Number 31950 has been entered for $23500
Requisition Description: Test
Requisition Details
Quantity: Luxmoore, Mr. Max
Item Description:
Total: DELL M770 17-INCH COLOR MONITOR
Requestor: Green, Ms. Jamilah C
Buyer: 1619
===================================================================
Hope this is much more explicit.
Thanks
Date: Tue, 24 Aug 1999 15:50:14 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: ALERTS
Are you running this in a multi org environment. Usually when you select against
"all" tables you need to specify an org_id
Date: Tue, 24 Aug 1999 14:57:24 -0500
From: "Anil Kumar (ns)" akumar@cap.org
Subject: RE: ALERTS
Try taking substring for segment1,description,item_description and full_name. There is a
chance that the length of these fields is so long that it is wrapping to the next line and
there by messing up your layout.
Date: Tue, 24 Aug 1999 16:10:34 EDT
From: "Senthil Anand" sa272@hotmail.com
Subject: Re: ALERTS
hi,
is your problem in alignment or duplicate printing
senthil
Date: Tue, 24 Aug 1999 23:24:56 EDT
From: Nikora@aol.com
Subject: Re: ALERTS
Check how many apps schemas you have
Periodic Alert being fired repeatedly
Date: Thu, 9 Sep 1999 13:44:35 -0400
From: Erik Ritters eritters@prg.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Periodic Alerts in R11
Has anyone experienced the following problem with Periodic Alerts in R11:
We activated the Periodic Alert Scheduler and alerts were firing every
minute for the same exceptions!!!
Oracle Support told us that the workaround was to specify not only a start
time for each individual alert but
an end time and check interval as well. Is this something new in R11? We
did not have to specify these in R10.7SC.
Thanks
Erik Ritters
Information Technology & Strategy
Production Resource Group, L.L.C.
539 Temple Hill Rd.
New Windsor, NY 12553
Phone - (914)567-5784
Fax - (914)567-5805
Email - eritters@prg.com
Alerts with Outlook/MS Exchange
Date: Tue, 14 Sep 1999 10:48:00 -0400
From: "Mooney, Cathy" cmooney@uswa.org
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Oracle Alert and Outlook/MS Exchange
Any suggestions are greatly appreciated - Thanks in advance.
I'm trying to setup Alert to work on our system. Our mail server
is running MS Exchange 5.5. I have installed Outlook97 Client
software on the DB Server. I have a test alert that should just
get sysdate and send an email but it keeps erroring - unable
to send mail to the address. I've set the Alert Manager -
System - Option, Name=Windows NT Mail to the location of
outlook.exe on the DB Server and then on the Alert Details,
I have tested sending to:
cmooney
"cmooney"
cmooney@uswa.org
"cmooney@uswa.org"
Nothing works, here's the message in the Request Log:
Performing alert "Simple_Test"
Connecting to "APPS"
Performing action set "Mail_Test_Set"
Performing action "Mail_Test"
APP-04124 Oracle Alert was unable to deliver your message
To: cmooney@uswa.org
Subject: (No Subject)
APPLMAIL is set to NONE
Do I have to install Oracle Office/Interoffice? I saw that referenced
as a gateway to MS Exchange on the MetaLink Forum.
Cathy Mooney
DataProfit Corporation
Oracle DBA
United SteelWorkers of America
(412)562-2456
cmooney@uswa.org
From: Bill Dunham [SMTP:bill.dunham@bosscorporation.com]
Sent: Tuesday, September 14, 1999 11:10 AM
To: cmooney@uswa.org
Subject: RE: Oracle Alert and Outlook/MS Exchange
Cathy -
What platform does the Apps reside on? You want to use the native
platform
to send email to your account. There is a profile option that needs to be
set as well, it indicates what mail service you are using. I'm sorry I
don't have the name of the profile option, as I don't have access to the
Apps at this moment. Also, is your mail service running on this platform?
This is a very easy effort and don't get confused about having to user
Interoffice - you don't need it. Let me know if you have any questions...
or feel free to call me at the below number and I can walk you through the
process... thanks, good luck!
Regards,
Bill Dunham
BOSS Corporation
bill.dunham@bosscorporation.com
919.303.4855 (office)
919.303.4847 (fax)
770.622.5500 (Atlanta Office)
http://www.bosscorporation.com
Date: Tue, 14 Sep 1999 11:25:52 -0400
From: "Mooney, Cathy" cmooney@uswa.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Oracle Alert and Outlook/MS Exchange
Thanks so much for the quick!
RDBMS 7.3.4.3
Apps 10.7.16.1.SC
Apps and Mail Servers are NT 4.0 SP4.
Outlook is open on the Apps Server, I've tested sending and receiving
email
through the Exchange Server from this machine - AOK.
I have the Alert System Option for Mail Systems set to Windows NT Mail
and then the path to outlook.exe on the Apps Server.
Cathy
Date: Tue, 14 Sep 1999 08:46:18 -0700
From: CFowler@littonapd.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Oracle Alert and Outlook/MS Exchange
Hi,
We send email from Alert all the time. We are using Outlook 98. Our
environment is IBM AIX 7.3.4 10.7 16.1SC.
The setup we have under Alert Manager GUI:System:Options(Mail Systems
alternate region) is:
Name Command In Use
Unix sendmail /usr/lib/sendmail x
We use the internet email address of our users (separated by commas, but not
in quotes) to send the output from the alerts.
To identify which Oracle instance (Production, Test, etc.) the alert is
coming from we have a different value for "Send Mail Account Description"
(i.e. "ORAPROD Oracle Alert" or "ORATEST Oracle Alert") for each instance.
HTH
Candace
Date: Tue, 14 Sep 1999 19:54:11 +0400
From: "Mehul Zaveri" mehulapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Cc: cmooney@uswa.org
Subject: Re: Oracle Alert and Outlook/MS Exchange
Please goto this site, Here this tool allows you to send mail w/o. using
alert. (callable from sql/plsql). Though I've yet to use it. (courtesy-some
oracle list)
http://www.ipass.net/~davesisk/oont.htm
This will also quickly help you to diagnose, whether the problem is on alert
side or basic configuration is the issue?
HTH
Mehul Zaveri,
Oracle DBA
EPPCO-DUBAI
Sending duplicate mails for same alert
From: Grant, Milo M. [SMTP:GranMM@jea.com]
Sent: Friday, October 22, 1999 9:00 AM
To: Multiple recipients of list
Subject: Oracle Alert Guru's
Oracle Alert Guru's
I am trying to setup an Oracle Alert for PO Approval.
The alert is setup for expense requisitions that are
autocreated to Purchase Orders and then approved.
The alert then sends an e-mail to the user detailing
the requisition number and the PO number.
Currently the alert is submitting two e-mails for each single PO that is
approved.
I have looked at the suppress duplicates feature on the action set level
as
well
as on the output level and the duplicate e-mails still keep coming. I
believe there
are two updates being made to the PO_HEADERS_ALL table causing the
duplicate e-mails Are there any suggestions for suppressing the
duplicates
? Thanks !
Milo Grant
Application Analyst
granmm@jea.com
Date: Fri, 22 Oct 1999 11:09:21 -0500
From: "Anil Kumar (ns)" akumar@cap.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Oracle Alert Guru's
Check fields you are using outside the repeating frame in the alert text.
If the SQL used is returning two different values for any of the fields used
outside the repeating frame, then two different mails will be sent.
Anil
Date: Sat, 23 Oct 1999 12:27:18 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Oracle Alert Guru's
Hi,
We had a similar problem and actually we had to move it to a Periodic Alert
because we could not find out what was actually causing the problem.
We had a bigger problem because we had various number of Alerts firing for
each of the PO's approved. We still have a TAR open with Oracle,but am not
working it very aggresively because of other issues.
However, let me ask you a question how many org's do you have setup??
I am beginning to think that it could be something to do with the Multi-Org
? Just a thought and now that somebody is also having the problem we could
actually find out where the source of the problem lies.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: Sat, 23 Oct 1999 20:18:05 PDT
From: "Basanta Kumar Dash" dashbk@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Oracle Alert Guru's
Hi Milo,
You are right. The system might be updating the table twice. I think you are
using event alert. Is your message levle "Detail"? For Summary level message
there is no way you can supress the duplicates. For "Detail" level message
check the following set ups.
1. Have you set up at least one approval level. ( I cannot recollect the
exact name). You can get it from the special menu. It's used for sending
your email to the next level in the hierachy.
2. If no.1 set up is done and you are still getting duplicate emails then
the only way to suppress the duplicate is to change the alert from event to
periodic. This will definitely suppress you duplicates. You can run your
even periodically once in 10 minutes to send the emails.
Hope this helps.
Basanta.
Date: Tue, 26 Oct 1999 12:50:14 -0400
From: "Musku, Jagan" jagan@cm-corp.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Oracle Alert Guru's
Hi,
we had a similar problem earlier,the same select statement in SQL PLUS was
returning only one record
but Alert was sending two messages.Our problem is solved when we did two
things
1.Supress duplicates check box checked
2.Create a separate Concurrent manager to process Alert requests
Hope this helps,
Jagan