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



in oracle workflow if i want to send a mail to the user after sending if the user didn't approv..

Answer / upendra

By Using Workflow rationalization we can do easily.

Is This Answer Correct ?    0 Yes 0 No

in oracle workflow if i want to send a mail to the user after sending if the user didn't approv..

Answer / vasu

We can Caliculate time and based on time we can able to send a notification

FUNCTION get_timeout_minutes RETURN NUMBER IS
BEGIN
RETURN(get_next_working_date(SYSDATE
,g_number_of_wait_days) -
SYSDATE) * 24 * 60;
END get_timeout_minutes;

PROCEDURE set_wait_days_for_timeout
(
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,RESULT IN OUT VARCHAR2
) IS
n_timeout_in_minutes NUMBER := get_timeout_minutes;
BEGIN
IF (funcmode != 'RUN')
THEN
RETURN;
END IF;
wf_engine.setitemattrnumber(itemtype => itemtype
,itemkey => itemkey
,aname => 'WAIT_DAYS_INCLUSIVE_WEEEKEND_H'
,avalue => n_timeout_in_minutes);

RESULT := 'COMPLETE:Y';
END set_wait_days_for_timeout;

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,


While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,


HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers  


What r the validation done in ap inbound ?

2 Answers   Questam,


while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,






What do you understand by soa and what are the benefits of using this architecture?

0 Answers  


What are profile options?

4 Answers   Accenture,


we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  


What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,


differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,


Which module is not in multiorg

6 Answers   HCL, Wipro,


what are the different types of parameters avialable in reports?

2 Answers   Oracle,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)