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

Reports & Discoverer :: Error In Event Driven Report Procedure?

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

PL/SQL :: How To Know Trigger Event Name

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

SQL & PL/SQL :: How To Generate Email On Database Event

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

SQL*Net More Data From Client Wait Event?

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

SQL & PL/SQL :: Database Startup And Shutdown Event?

May 7, 2013

Any example of database startup event and database shutdown event?

View 2 Replies View Related

PL/SQL Timer Wait Event Analysis

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

Long Waiting Session (Null Event)

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

SQL & PL/SQL :: List Persons Having Event In Consecutive Months?

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

SQL & PL/SQL :: Record Event If No Rows Are Returned Between Two Timestamp?

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

Application Express :: Onchange Event On A Column - Value Undefined?

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

Sending Automated Emails From Oracle DB To Users After A Certain Event

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

Database Time Spent Waiting % For Event Class Concurrency

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

Forms :: Wait Event During Execution Simple Select Statement

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

Application Express :: Skillbuilders Modal Page - End Open Event?

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

Performance Tuning :: High CPU Utilization In RAC And Log File Sequential Read Event

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

Application Express :: Capture On Change Event For Select List Using JavaScript

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

Server Administration :: Event Alert Created Successfully On Custom Table But Not Firing?

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

PL/SQL :: Wait Event Starts With SQL*Net Message From Client - Time Wait 178577 Units

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

Workflow :: ORA-02289 / Sequence Does Not Exist

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

Workflow :: Error While Deploying A Workflow In OWB

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

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 :: PO Approval Workflow Change

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

Workflow :: HRSSA Workflow Errors With 3120 - Activity HRSSA/343959 Has No Performer

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

Table Or View Does Not Exist Error?

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

Insert Into Table If Not Exist Otherwise Return Error

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

Forms :: Frm-40815 Error Variable Does Not Exist

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

Client Tools :: How To Query Tablename That Don't Exist And Not Get Any Error

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

ORA-01041 / Internal Error Hostdef Extension Doesn't Exist

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

Client Tools :: ORA-01041 / Internal Error / Hostdef Extension Doesn't Exist

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







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