in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
Answers were Sorted based on User's Feedback
Answer / upendra
By Using Workflow rationalization we can do easily.
|Is This Answer Correct ?||0 Yes||0 No|
Answer / vasu
We can Caliculate time and based on time we can able to send a notification
FUNCTION get_timeout_minutes RETURN NUMBER IS
SYSDATE) * 24 * 60;
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,RESULT IN OUT VARCHAR2
n_timeout_in_minutes NUMBER := get_timeout_minutes;
IF (funcmode != 'RUN')
wf_engine.setitemattrnumber(itemtype => itemtype
,itemkey => itemkey
,aname => 'WAIT_DAYS_INCLUSIVE_WEEEKEND_H'
,avalue => n_timeout_in_minutes);
RESULT := 'COMPLETE:Y';
|Is This Answer Correct ?||0 Yes||1 No|
Name the different Cursor Attributes.
what are the types of interfacing?
What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1
we have 10 records. It's occured error in 6th record how can u find and how to rectify that?
How You Will display the key flexifields in your report
There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.
What is the Lookup's and what is the use of lookup's?
why r u transer the data base tables to flat file and what is use
Give a brief overview on OrderManagement.
Give a overview on Aol
What is MO operating units. Why it need to to set this and where .