Workflow :: No Event Subscriptions Exist For Event Error
Mar 6, 2013
we are running Oracle R12.1.3 on DB version 11.2.0.3. I just migrated a created a custom subscription for the oracle.apps.ap.supplier.event Oracle Event. I execute a custom package when this event fires. My package is working fine and I'm getting the expected results. My problem is I keep getting a Workflow notification saying:
Sent: Monday, March 04, 2013 9:14 PM
To: SYSADMIN
Subject: Action Required: Local Event UNEXPECTED : oracle.apps.ap.supplier.event / 36422
To SYSADMIN
Sent 04-MAR-2013 21:13:40
ID 1659929
An Error occurred in the following Event Subscription: Event Subscription
Event Error Name:
Event Error Message: No Event Subscriptions exist for this Event
Event Error Stack:
Event Data: Event Data URL
Event Details
Event Field Value
[code]...
I saw an earlier post about this and have tried changing the Source Type to "External" but that didn't change anything. why Workflow is telling me a subscription doesn't exist when my subscription is executing with no problems.
View 5 Replies
ADVERTISEMENT
Mar 30, 2011
.I created the following procedure to implement Event Driven Reporting:
CREATE OR REPLACE procedure ABC.eve_drv_rep as
myPlist system.SRW_PARAMLIST;
myIdent system.SRW.Job_Ident;
BEGIN
myPlist := system.SRW_PARAMLIST(system.SRW_PARAMETER('',''));
system.srw.add_parameter(myPlist,'GATEWAY','apsIP/reports/rwservlet');
[code]...
Procedure is created successfully but when I execute this procedure, I get the following error:
ORA-20001'Error sending email.Error: ORA-20999
ORA-06512: at "Nml.Eve_Drv_Rep", line 17
ORA-06512: at line 1
2ndly I want to know that whether I should give IP address or Application Server Machine Name in GATEWAY parameter?
And in SERVER parameter either I should give the Application Server Machine Name or Report Server name installed on Application Server Machine?Lastly from where I can get the complete list of Parameters to be added in SRW.Add_Parameter like SERVER, GATEWAY etc.
note that we r using Database 10g Rel.2 and Forms and Reports services on Application Server and the report being called was developed in Reports 10g.
View 6 Replies
View Related
Dec 3, 2012
how to know the trigger event name in trigger calling...like-
CREATE OR REPLACE TRIGGER ******
BEFORE DELETE OR INSERT OR UPDATE
OF TOTAL_QUANTITY,CANCELLED
ON *********
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
-----------I want to know given trigger event at this level-----------
IF INSERTING THEN
null;
ELSIF UPDATING THEN
null;
ELSIF DELETING THEN
null;
END IF;
END;
View 7 Replies
View Related
May 15, 2011
I've heard about diferent ways of generating email in response to a database event e.g
1 - Using UTL_MAIL package.
OR
2 - Event Driven Reporting feature of 10g Database and using SRW.Run_Report package to generate and mail a report.
Now I'm confused that how should I accomplish the following tasks:
(i) - How to generate an email after Insert/Update/Delete on a table and acknowledge the concerned users about that event?
(ii)- How to attach a text file with that email?
View 8 Replies
View Related
Oct 8, 2013
DB 11.2.0.2AIX 6
I am getting following two top wait events from AWR report
1)SQL*Net more data from client
2)log file sync
Does it hints towards network latency and hardware configuration?what should i do for first wait event?
View 11 Replies
View Related
May 7, 2013
Any example of database startup event and database shutdown event?
View 2 Replies
View Related
Jun 22, 2013
One of our Job running long than usual time. I checked the wtait event for which its waiting. its PL/SQL Timer wait. But i noticed the total waits is 179 and timed out is also 179 for PL/SQL Timer. I checked that job that particular procedure calls dbms_lock.sleep in it. I want to know why this wait event is getting timed out ?
View 1 Replies
View Related
Jan 5, 2012
I have a problem with a statement that normally execute in few second but after 50h the session is still active and is still waiting for null event.
V$session_wait
EVENT WAIT_TIME SECONDS_IN_WAIT STATE
---------------------------------------------------------------- ---------- --------------- -------------------
null event -1 178737 WAITED KNOWN TIME
V$session
SID STATUS PROGRAM LAST_CALL_ET
---------- -------- ------------------------------------------------ ------------
364 ACTIVE f90runm@CENTRAL1 (TNS V1-V3) 178737
My Oracle version : Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
System version : HP-UX V1
I tried tracing the session but no trace file is generated it same there is no activity.
View 5 Replies
View Related
Apr 7, 2011
how to query a list to see if a person had events in consectutive months within the past year. We call a person a LongTermResident if they had a review in any two consectutive months within a reporting period. I wrote a function isResidentLongTerm, passing in FacilityID, ResidentID, ReportPeriodStart, and ReportPeriodStop and returning a 'Y' or 'N'. It works, but the performance is slow.
So if I have a list of reviewers, facilities, reviewees I want to select only those SNF/NF residents who have had routine reviews in any two consectutive months at the same facility.
This is my query:
select ConsultantID, ResidentID
from (
select distinct ConsultantID, FacilityID, ResidentID
from Reviews
where BedType = 17820 -- SNF/NF bed
and ReviewType = 17474 -- routine review
)
where isResidentLongTerm( FacilityID, ResidentID, :startDate, :stopDate ) = 'Y'
View 1 Replies
View Related
Feb 21, 2013
I have employees under a supervisor defines as below:
select LOGIN_USER_ID from APPWMS.VIEW_EMP_LATEST_INFO where SPVSR_LOGIN_USER_ID='erbrand' and EMP_STAT_CODE='ACTIVE'
Now I need to determine if all above employees are clocked in , clocked out or not clocked between yesterday and today using following:
select to_char(CLOCK_IN_DATE,'dd-mon-yyyy hh24:mi:ss' ) ClockIn,to_char(CLOCK_OUT_DATE,'dd-mon-yyyy hh24:mi:ss' ) ClockOut ,LOGIN_USER_ID,--CLOCK_IN_DATE,CLOCK_OUT_DATE, CLOCK_OUT_DATE-CLOCK_IN_DATE,trunc(sysdate) , trunc(sysdate-1),
case when CLOCK_OUT_DATE is null then
'Not clocked out'
else
[code]....
The first SQL gives me 66 rows while second gives me 40 rows. For 26 people , no rows are returned which means these people donot have a clock in record between two timestamps.
How can we modify query to show those 26 people as 'Not clocked In'
View 7 Replies
View Related
Jul 4, 2012
I have a onchange event on a column which calls the following code:
function SetVal(pThis) {
//get the curren row index on change
var currIndex = $('select[name="'+pThis.name+'"]').index(pThis);
var currValue = pThis.Value;
alert(currValue);
$s('P21_mat_id_hold',currValue);
}currValue is "undefined"
Where am I missing something?
View 3 Replies
View Related
Jul 17, 2012
OS: RHEL 5.7 64 bit
DB: 11.2.0.2 Standard Edition 64 bit
Everyday EOD is run and after the eod, users are requesting to receive a mail confirming the same from the database. For this we need to configure automated email which will be sent to a list of users email ID immediately after the EOD is done.
View 3 Replies
View Related
Dec 4, 2012
Most of my day to day work involves the support of DB2 on AIX and z/OS. I support the database infrastructure for one business system that runs on the Oracle RDBMS. The application is Oracle Transportation Management. The non-production environments don't get much traffic. If I sign into the TEST or DEV Enterprise Manager DB Control screen, the following warning is almost always listed on the main page:
Metrics "Database Time Spent Waiting (%)" is at 44.00384 for event class "Concurrency"
Enterprise Manager reports that this metric is continuously fluctuating above and below the warning threshold of 30% of db time when the environment is idle.To investigate(and I am no oracle expert, far from it), I ran the following:
SELECT * FROM v$session_event
WHERE WAIT_CLASS='Concurrency'
ORDER BY TOTAL_WAITS DESC;
By far, the top two entries in the result are the following:
SIDEVENTTOTAL_WAITSTIME_WAITEDAVERAGE_WAITMAX_WAIT
124os thread startup12041423733.5218
359os thread startup150653433.5521
[code]...
Does this indicate a possible problem with the operating system?
View 2 Replies
View Related
Jul 19, 2013
Yesterday i got wait event when executed simple select from table.This select was like:
SELECT emp_number from employer where subs_id = 111
I got one row, select is very fast.In our Core Bank System we have package with function which returns such information. I tested this select on test DB, and nothing wrong. But when I executed such select and package on Production DB, DB Admin saw that 88 sessions waits when my session release the resource. But what can happen, it was simple select? I used PL/SQL developer to get information from table:
1) SELECT emp_number from employer where subs_id = 111 then
2) Package with this function
Another users used Oracle Forms screen to execute package. How simple select statement could stop all DB?
BANNER
1Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
2PL/SQL Release 10.2.0.5.0 - Production
3CORE 10.2.0.5.0 Production
4TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
5NLSRTL Version 10.2.0.5.0 - Production
[code]...
Forgot to say that after succeful execution on Prod DB I disconnected, and in EM my session was INACTIVE.
View 3 Replies
View Related
Apr 24, 2013
I'm using Skillbuilders Modal Page 2.0.0. plugin on Apex 4.2, and I can't seem to get the event End Open to work. stumbled upon this thread Skillbuilder Modal Page - Dynamic Title; nothing happens even if I set an alert to pop up on End Open
View 7 Replies
View Related
Apr 13, 2011
In a 3-node RAC setup; one node is showing high CPU utilization around 40~50%. The CPU utilization was less than 20% 10 days back but from 9th oldest day it jumped and consistently shows the double figure. I ran AWR reports on all three nodes and found one node with high CPU utilization and shows below tops events-
EVENT WAITS TIME(S) AVG WAIT(MS) %TOTAL CALL TIME WAIT CLASS
CPU
time 5,802 34.9
RFS
ping 15 5,118 33,671 30.8 Other
Log file sequential
read 234,831 5,036 21 30.3 System I/O
Sql*Net
more data from
client 24,1711,08745 6.5 Network
Db file sequential
read130,939 4533 2.7 User I/O
Findings:-
On AWR report(file attached) for node= sipd207; we can see that "RFS PING" wait event takes 30% of the waits and "log file sequential read" wait event takes 30% of the waits that occurs in database.
1)Are these symptoms of undersized log buffer?
2)I feel Network wait can be reduced by tweaking SDU & TDU values based on MDU.
View 2 Replies
View Related
Nov 15, 2012
Is there any way I can capture on change event for the Select List (already created on the page) using java script and then refresh chart region?
View 2 Replies
View Related
Mar 8, 2013
I have created custom table in inventory and after register table & columns, i create event alert on it. event alert is not firing.
View 1 Replies
View Related
Dec 11, 2012
I am trying to look at wait events for a long running query in TOAD.I start the query on one instance of TOAD and open the Session Browser on another instance.But I am surprised to find that in "TOtal Waits" on the RHS-> SQL*Net message from client is the longest time taking and is already -> 178577 units whereas I have just started the query.
Whereas in the Current Waits it shows DB File Scattered Read currectly as some seconds.
View 5 Replies
View Related
Apr 27, 2013
I created simple custom workflow (Start -> Notification -> End).
I got the following error when I run the workflow.
[WF_ERROR] ERROR_MESSAGE=ORA-02289: sequence does not exist ERROR_STACK= FND_SEARCH_EVENTS.On_Object_Change(oracle.apps.wf.notification.send, 5C84790B967158FFE04400144F23BF3C)
The notification activity returned this error but the notification has been sent to performer.
[URL]
View 1 Replies
View Related
Apr 3, 2013
I am getting the below error while deploying a workflow in Control Center.
ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException:
The file /u01/app/oracle/product/11.2.0.2/dbhome_1/owb/bin/admin/rtrepos.properties cannot be accessed or has not been properly created on the server XXXXXX. If the file does not exist or if the database owner (normally user 'oracle') does not have the required file permissions or if the file has not been properly created then the file can be recreated by running the SQL*Plus script /u01/app/ oracle/ product/11.2.0.2/dbhome_1/owb/ rtp/sql/ reset_ repository. sql (in a RAC environment the file must be manually copied to each server which is used for OWB). Otherwise if using a 10.2 database instance, then please run the SQL*Plus script /u01/app/oracle/product/11.2.0.2/dbhome_1/owb/UnifiedRepos/reset_owbcc_home.sql.
View 0 Replies
View Related
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
Sep 17, 2012
i`m new to EBS. steps for following changes in the PO Approval workflow
1.Any new PO that gets processed / approved in the system needs to auto run the PO Print program (to generate the PDF copy of the PO) with the email function switched on.
2.PO Print program needs to be modified to auto email docuclass (test@tes.com) always ( even if email option is switched off) and email both buyer and PM ( if email option is on). Email subject should contain PO# and revision#.
View 0 Replies
View Related
Oct 3, 2013
After HRMS RUP6 patch, we overlooked a customization that set the Performer Type and Performer Role on an activity. Consequently, we have many workflows that are currently in progress and in an error status with:
HRSSA workflow errors with 3120: Activity 'HRSSA/343959' has no performer.
We see in the wf_process_activities table that the
PERFORM_ROLE and PERFORM_ROLE_TYPE for activity 343959 have the wrong values.
Their values are currently, PERFORM_ROLE_TYPE = 'CONSTANT' , PERFORM_ROLE is null.
They should be: PERFORM_ROLE_TYPE = 'ITEM_ATTR' and PERFORM_ROLE = 'FORWARD_TO_USER_NAME'.
This has been fixed for current workflows but the activities in error do not complete successfully on retry. Is there an API that allows us to set PERFORM_ ROLE and PERFORM_ROLE_TYPE on a specific activity?
View 0 Replies
View Related
Apr 25, 2007
I created a table by doing so:
create table Playlist (Artist string, Album string, Track int, Song string, Genre string);
But I get the following error message when trying to perform a query:
SQL> select artist
2 from playlist;
from playlist
*
ERROR at line 2:
ORA-00942: table or view does not exist
I entered data in for the artist, so why doesn't it work?
View 4 Replies
View Related
May 7, 2011
I am using oracle 10g to create a user register application. what i want is to insert the user information (like Email ,username, password, etc.) into a table. i am able to insert the data into the table but what i want is to check before inserting that same email,and username doesnt exist. if it does it should return some error like the email or username already exist.
View 2 Replies
View Related
Apr 6, 2011
I am using Global Variables to store the data from the form variables and once again restore it in the form when User ID is entered.
For this I write the code in Pre-commit trigger
:global.gzaoffe_nofday := :gzaoffe.gzaoffe_nofday;
:global.gzaoffe_time_period := :gzaoffe.gzaoffe_time_period;
:global.gzaoffe_time_from := :gzaoffe.gzaoffe_time_from;
:global.gzaoffe_time_to := :gzaoffe.gzaoffe_time_to;
:global.gzaoffe_date_from := :gzaoffe.gzaoffe_date_from;
:global.gzaoffe_date_to := :gzaoffe.gzaoffe_date_to;
:global.gzaoffe_official_reason := :gzaoffe.gzaoffe_official_reason;
Then I write the code in KEY-NEXT-ITEM trigger of gzaoffe.user_id
:gzaoffe.gzaoffe_nofday := :global.gzaoffe_nofday;
:gzaoffe.gzaoffe_time_period := :global.gzaoffe_time_period;
:gzaoffe.gzaoffe_time_from := :global.gzaoffe_time_from;
:gzaoffe.gzaoffe_time_to := :global.gzaoffe_time_to;
:gzaoffe.gzaoffe_date_from := :global.gzaoffe_date_from;
:gzaoffe.gzaoffe_date_to := :global.gzaoffe_date_to;
:gzaoffe.gzaoffe_official_reason := :global.gzaoffe_official_reason;
Form is compiling successfully. But when I enter the User ID It is showing the error FRM-40815 Variable GLOBAL.GZAOFFE_NOFDAY does not exist. Like this it is showing for all global variables.
View 2 Replies
View Related
Oct 24, 2012
Here is the query I want to be able to run...
select * from NonExistingTableName
I want the query above to be ignored and return no results (rather than generating an error) when the tablename does not exist.
View 14 Replies
View Related
Dec 12, 2012
When i am compiling the form11g this error came "ORA-01041: internal error hostdef extension doesn't exist "
View 6 Replies
View Related
Apr 19, 2012
i want to mount the database through sql> startup mount exclusive; for flashback the database, then sqlplus shows 2 errors---
"ORA-24324: service handle not initialized" and
"ORA-01041: internal error. hostdef extension doesn't exist"
how to sort out these errors.i am using 11.2.0.1.0 on widows server2008.
View 6 Replies
View Related