-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Home |
Technical Articles |
Training Articles |
Receive Email for New Articles |
Contributors |
Apps Book |
Oracle Workflow Notifications Timeouts with Bank Holidays & Weekends | | Print | |
Written by Anil Passi | |
Thursday, 24 August 2006 | |
Very often our client demand that they want to set reminder or timeout for Oracle Workflow notifications after <xyz> Having implemented an approach for various Oracle based Workflows, I am now in a position to share a very simple A site level profile option is assigned to global variable g_number_of_wait_days to capture the offset days.
For example, let’s assume that we need to escalate/timeout a workflow notification after 3 Working Days.
![]() Sample Workflow with Bank Holiday timeout activity => Ensure that you have a table say xxx_holiday_list, in which you capture bank holidays. =>In the Oracle workflow, create a activity names “Set Wait Days for Timeout” that executes a procedure FUNCTION is_this_date_bank_holiday(p_date IN DATE) RETURN BOOLEAN IS
FUNCTION get_next_working_date(p_estimated_next_working_date IN DATE) FUNCTION get_next_working_date(
FUNCTION get_timeout_minutes RETURN NUMBER IS PROCEDURE set_wait_days_for_timeout Rather than spoon feeding you to explain the code, let me simply list the broader logic
End result of the above procedures and functions is to assign a value in minutes to an attribute workflow Above function then makes a call to get_next_working_date. On a closer look you will notice that the function Finally, the approval notification is assigned the Workflow Attributes that dictates the timeout in minutes. Comments
(10)
![]() ![]() written by Prabhat Jha , November 30, 2006 ![]() written by Prabhat Jha , November 30, 2006
Ya Let me have a go at this and will get back.
Thanks Prabhat Jha ![]() written by Rajesh Jha , June 26, 2007
Nice article THANKS
One doubt... Is timeout always in minutes.... or we must do some setup for that...??? ![]() written by Anil Passi , June 26, 2007
Yes indeed, you have no choice but to calculate in minutes. I am not aware of an option to change that
thanks anil
Hi Anil,
could you please tell me how to send a notification to user based on a condition. eg: I want to send notification to the user only when the custom attribute(Is previous approver timed out?) is set to 'true' .otherwise i should not send notification to user. how to do it? Thanks for your help Kumar
Hi Kumar
You need to do the steps below 1. create an activity in process, and attach it a pl/sql function 2. in the pl/sql function, check if the timeout attribute/flag is Y or N 3. Attach a Yes/No lookup to this activity 4. the pl/sql will either return COMPLETE:Y or COMPLETE:N This will cause the Wf to branch properly Thanks, Anil
Hi Anil,
After setting timeout period and everything we need to schedule Workflow Background Process concurrent program to complete the timedout activities, then only the this scenario will workout right?.. Please confirm this. ![]() written by Senthil K Rajaram , October 02, 2007
Hi Anil,
I have a requirement for AP Invoice workflow customization. The scenario is like this. Approval notification email goes to an approver. If there is no response from the approver after 2 days, a reminder email notification is sent. Parallely a cancellation notification email corresponding to the original approval notification goes to the approver. If there is no response from the approver after another 2 days then an escalation notification email goes to the next approver. Parallely a cancellation notification email corresponding to the first reminder notification goes to the original approver. Now the requirement here is to suppress only the first cancellation and not the second one. Is this possible? If so please share your thoughts. Thanks, Senthil
i need workflow customizations and examples in oracle Hrms and oracle projects modules.
You must be logged in to a comment. Please register if you do not have an account yet.
|
Thanks
Prabhat Jha