Workflow :: Notification Timeout When Requested For Information?

Feb 21, 2013

We have implemented a approval notification for our customer which on a high level is as follows

requester -> Approver 1-> Approver 2

Once a request is submitted, the 'approval' notification goes to Approver 1 followed by Approver 2. The request is approved when both approves approve the request. If no action is taken by the approvers, the original notifications are cancelled and escalation notification is sent to supervisor of approver 2.

We have a timeout of 48 hours set for the initial approval notifications sent to the approvers (1 & 2). In case Approver 2 requests for more information using the 'Request information' button, the TIMEOUT clock does not seem to reset and the notification is cancelled after 48 hrs even if the notification is in the queue of the requester.

This is causing the escalation notification to be supervisor of approver 2.

The question here is why does the timeout clock not reset when the notification goes back to the requester for additional information. Is this how the standard oracle workflow notification behaves ? Is there a way to customize and achieve this ?

View 2 Replies


ADVERTISEMENT

Notification In Workflow

Jun 6, 2011

My PO notification is showing only 5 lines even PO contains more than 5 lines. new to workflows.

View 1 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 :: How To Find Actual Responder Name Displayed In Notification

Feb 13, 2013

Where are the details of the Actual Responder Details stored in the case of the below scenario

If a notification for one user was closed by another user through access to the first user's worklist, the name of the second user, who actually took the action, is displayed as the responder.

I am only able to find the Original Recipeint username in the wf_notifications table.But where will the details of the Actual Responder name displayed in the notification be stored.

When I use the "wf_notification.Responder" function, I get the Original Recipeint username of the user but not the one who acted on the notification. Is there ANY way by which I can get the Actual responder user name who acted on the notification

select responder from wf_notifications where notification_id = <nid> also gives me the Original Recipeint username of the user but not the one who acted on the notification

View 5 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

Workflow :: External Sales Order Lines Remain In Internal Req Requested Status

Feb 13, 2013

Customer sales order lines are fulfilled by IR-ISO. When line progresses, it is set to have Internal Req Requested status. A scheduled program runs amd IR are created. However, sales order line status does not change to Internal Req Open. It remains in Internal Req Requested status.

As a work around, workflow is rewound to 'Check ATR Qty' which is customized activity and then status changes to Internal Req Open. What could be the reason that workflow is not setting the status to Internal Req Open?

View 1 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 :: 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 :: 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

SQL & PL/SQL :: How To Use Timeout

Jul 10, 2013

I have one procedure which calls a function. My requirement is if that function didnt return value in 1 minute then stop the exection of that function and call next statement.

Begin
(1).........
(2).......
(3) get_func_val:= function(1,2);
(4)......
(5)....
end;

My requirement is, if (3) doesn't return value in 1 minute, stop the execution of (3) and start executing (4).

View 15 Replies View Related

Way To Reduce Dblink Timeout

Dec 28, 2011

is there any way to reduce the dblink timeout, i need to test if the remote server is up by testing the dblink throw 'select 1 from dual@link_name' but it take too long time 5-6 min., i need to make it 5 sec after that the exception tns timeout appear. I try with some sqlnet.ora parameters like INBOUND_ TIMEOUT but not work for me, also i try using tnsping but it also take long time when the remote server is down.

View 2 Replies View Related

SQL & PL/SQL :: Getting Connection Reset And Timeout

May 30, 2010

[#|2010-03-17T19:00:26.689+0530|SEVERE|glassfishv3.0|tcplistener.ModuleHandler|_ThreadID=30;_ThreadName=Thread-1;|The log message is null.
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at java.net.SocketInputStream.read(SocketInputStream.java:182)
at java.io.FilterInputStream.read(FilterInputStream.java:66)
at tcplistener.ByteWrapper.unwrapFromStream(ByteWrapper.java:136)
at tcplistener.ModuleHandler.run(ModuleHandler.java:106)
at java.lang.Thread.run(Thread.java:619)
|#]

[code].....

View 1 Replies View Related

SQL & PL/SQL :: Dbms_scehduler Email Notification

Sep 13, 2012

I have set up my dbms_scheduler schedule and all run fine. I have set up the smtp server for outgoing email and it all looks good just like multiple of our other boxes here.The problem is that the event (SUCCESS) for a job is raised yet the email notification is not sent. My question is this: Is there somewhere where the actual log of email notifications sent (and/or failure there-of) is actually kept?

View 6 Replies View Related

PL/SQL :: How To Get Database Notification To C++ Application

Dec 3, 2012

We are developing a C++ server which will process based on time based events. For example if a particular user has configured a particular task that has to be processed at a particular time, then an event or notification needs to be sent to the C++ server from the database, to initiate the task. The timming configuration is stored in the database, and the C++ server shouldnt poll the database at an interval, but event should be notified from the database at the configured timming.

We are using odatabase and odynaset libraries to connect and access the oracle database 11g.

View 8 Replies View Related

Control Timeout Before Connecting Via DBLink?

Feb 28, 2012

Is there any way to control the timeout before connecting via dblink. the idea is to test the dblink before calling functions over it, the problem it when i try 'select 1 from dual@dblink' in case if the remote server is down it takes too long time 5-7 min. which causing hang up the session,

So is there any parameter to reduce the waiting time say after 3 sec stop and return the timeout exception.I try the SQLNET.INBOUND_CONNECT_TIMEOUT parameter but not working, also try the tnsping but it alse take long time when the server down.

the database version is 10gr2.

View 5 Replies View Related

How To Increase TOAD Timeout Interval

Jun 8, 2006

When I connect to a Oracle database(remote) using TOAD client, because of the settings of timeout done at the server end(in Oracle), the TOAD session gets time out in 5 minutes.

I want to know how I can increase the timeout interval or if I can keep on pinging the database server so that the TOAD connection does not gets timeout?

PS: When we connect to a unix server using putty, we can keep on pining the server at regular timeout interval by going to Change Settings->Connection->Set KeepAlive

Is there a similar way for TOAD?

View 6 Replies View Related

Any Query Timeout Parameter In Oracle?

Oct 2, 2013

Is there any timeout for sql queries in oracle,  if so what is the timeout parameter.

View 3 Replies View Related

Listener Doesn't Currently Know Of Service Requested

Jul 15, 2010

I am using Oracle 10g and when i start my server then my database is running and my application use this database.But after 15 min automatically application show this error

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

View 1 Replies View Related

How To Implement Change Notification Database

Sep 3, 2013

how to implement change notification database in oracle forms?

I want to display some data to user،when change a table in database . now Can i do this work with change notification database in oracle form10g?

View 1 Replies View Related

Create Notification For Blocking Session

Aug 1, 2013

I want to create notification/ or triggered mail to my client and my dba group which will occur while session and user has been blocked. I want to create this procedure in 12c OEM.

View 3 Replies View Related

Enterprise Manager :: OEM 10g Backup Notification

Oct 16, 2007

I have been starting to use OEM 10g and am configuring backups through the maintenance portion. Is there a way to get backup success / failure notification sent to an email address?

View 8 Replies View Related

Loader Throughput (rows Per Second) Gives Out A Notification?

Feb 22, 2013

the Metric "Loader Throughput (rows per second)" gives out a notification on my Oracle 11gR2 instance:

Loader Throughput (rows per second) for <hostname>:1158_Management_Service,XMLLoader0 exceeded the critical threshold (3000). Current value: 3695.652173913043478260869565217391304348My problem is, that I can't interprete this value and don't know, if that is really terrible so I have to do something.

which and what this value belongs and what does that mean?

View 3 Replies View Related

ORA-12514 / TNS / Listener Does Not Currently Know Of Service Requested In Con

Nov 19, 2012

I am facing problem "ORA-12514" error. my database is register in listener but when i connected throw "sqlplus" then i got "ORA-12514" error.

As show below

[oracle@sun3 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-NOV-2012 14:40:15
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     listener1
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

[code]....

View 14 Replies View Related

Forms :: Java Timeout Connection Error?

Mar 30, 2012

This error keeps on comming in my welogic forms server window many often....can any one tell me why it is so ?

<Error> <oracle.forms.servlet> <FRM-91230> <fatal
error in runtime process: timeout on connection to Java client>

View 2 Replies View Related

Client Tools :: How To Edit Timeout For Each User

Sep 25, 2012

how can i edit the timeout for each user

i.e i need the user who didn't user forms or reports to be disconnected automatically from the oracle how can i do that

View 1 Replies View Related

Listener Does Not Currently Know Of Services Requested In Connect Descriptor

Oct 3, 2012

I am new to oracle DBA. I have just installed the oracle on centos. when i create the oracle database for the first time then listener created and worked sucessfully. but when i stop the listener and start again. I get message "Listener does not currently know of services requested in connect descriptor.

View 1 Replies View Related

SQL & PL/SQL :: Email Notification Using Oracle Advance Queue

Nov 28, 2012

I want to send an email notification using oracle aq for events like when a message goes to error queue. Similarly,Can I send an email notification when I create a queue or drop a queue?

How can I do this?

View 3 Replies View Related

Enterprise Manager :: Configure Gmail ID For Notification?

Aug 25, 2010

how to configure gmail id in enterprise manager.

it has smtp address but still i'm getting a error message

smtp.gmail.com: Test failed with message: "Sending failed; nested exception is: javax.mail.MessagingException: 530 5.7.0 Must issue a STARTTLS command first. t18sm1156251qco.20 "

View 1 Replies View Related

RAC & Failsafe :: Fast Application Notification With OCI Based App

Feb 14, 2006

We have an application that is written in C/OCI, and we want to use FAN on the database. Can we write C APIs that will work with FAN (monitoring)?

View 2 Replies View Related







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