Trigger on FND_CONCURRENT_REQUESTS
Date: Sun, 27 Jun 1999 16:26:54 PDT
From: Julie Chang julie_h_chang@hotmail.com
Subject: FND_CONCURRENT_REQUESTS
Hi all,
Has anyone successfully created a trigger on FND_CONCURRENT_REQUESTS table
to send out email messages on the status as certain concurrent programs are
run?
Creating an event alert on FND_CONCURRENT_REQUESTS table causes a recursive
situation since event alert triggers another concurrent request, Check Event
Alert, which attemps to insert another record into FND_CONCURRENT_REQUESTS.
Thanks,
Julie Chang
Oracle Applications Consultant
julie_h_chang@yahoo.com
Trigger with invoice
Date: Tue, 6 Jul 1999 18:43:39 +0300
From: mohammed alshaarawi m_sharawy@tccbce.com
Subject: trigger with invoice
hi
the following error is fired sometimes
frm-40735:ON-DELETE trigger raised unhandled exception VALUE ERROR
the solution for this error to restart the database!!
thanx
Date: Tue, 6 Jul 1999 12:51:10 -0400
From: "Salunke, Pradyot " Pradyot_Salunke@csx.com
Subject: RE: trigger with invoice
Hi there
Oracle gives VALUE ERROR when you try to assign a more data to a field
defined with less width
e.g.
if variable a varchar2(10) is defined in trigger
and if you will try to assign a with 'abcdefghijk' ,at that time it gives
value error because oracle won't truncate the data
Display message in status bar in Character mode
Date: Wed, 7 Jul 1999 10:45:25 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
Subject: RE: ORAAPPS-L digest 3381
Hello Apps Gurus
Does anyone out there know how a given message could be shown in the status
bar in character mode? I have created a trigger on a table to trap an
exception and would like to have the exact reason displayed on the status
bar. Any help would be appreciated.
Thanks in advance and with Best Regards
Create Security Rule automatically on creation of a Responsibility through Database Trigger
Date: Wed, 28 Jul 1999 15:09:39 PDT
From: "mike ruff" mikeruff@hotmail.com
Subject: Database Trigger Code.........Help.....???
Hi guys,
Purpose - whenever a new responsibility is created a security rule must be
created automatically and assigned to that responsibility using a Database
Trigger
I am new to the technical field, so please help me out with the
code.........I just have to populate the 2 tables FND_FLEX_VALUE_RULES and
FND_FLEX_VALUE_RULE_USAGES
SAMPLE CODE...
Triggers on Datetracked Tables
Date: Fri, 30 Jul 1999 10:24:35 -0400
From: Phil Riker pmr2073@ritvax.isc.rit.edu
Subject: Help with Triggers on Datetracked Tables
Does anyone out there have any experiences with writing/implementing a
trigger(s) to capture WAS/IS information (INSERTS/UPDATES) on
"datetracked" tables in the HRMS application?
Thank you for your consideration
From: "Lewis Cunningham" lcunning@mediaone.net
To: "Phil Riker" pmr2073@ritvax.isc.rit.edu, orahrms-l@mail-list.com
Subject: Re: [orahrms-l] Help with Triggers on Datetracked Tables
Date: Fri, 30 Jul 1999 10:43:14 -0700
I've done transaction type triggers on datetracked tables, what exactly are
you trying to do?
Lewis
Database trigger on WIP
Date: Mon, 30 Aug 1999 15:42:54 -0700
From: Ram Purushothaman ram.purushothaman@sanmina.com
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: Need help on database trigger on WIP
Hi,
I need some help on database trigger. I have not created database
trigger. My requirement is as follows:
If we go to the "Material requirements" forms (for a particular job
name) and select the quantities, I have some decimal value. i.e. like
12.244896 for required quantity, and, the start quantity is 12 for that
particular job name in "Discrete Jobs" form.
What I need to do is, If it has a decimal value for the required
quantity, I need to round that one to the next integer(for this case -
13). After rounding this value, then I need to get the value for the
Quantity_per_assembly (required_quantity/start_quantity). I need to
check this for different components for that particular job.
Any help is appreciated.
Thanks.
Ram.