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
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 |
HOW CAN U KNOW THE STAUS OF PO?
while doing the process of conversion if got any data error out what is the next step to reprocess
Which oracle apps version you are very confident in?
where we find the status of order information.
Define MultiOrg Structure
Tell me some interface tables on ordermangement.
When you run he report you have to get only that particular organization po numbers or item number how can do it?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
how will u do documentation
why do we go for oracle apps technical other than sap and other packages?
what are the balancing segments in AR?
hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me
2 Answers Pathway Technologies,