After a long hiatus from writing in the blog, I am back;
Problem is that, it is difficult to decide whether the post will add value or is it something known to everyone, except me!
This was an interesting issue. What appeared to be a relatively straightforward work, stretched beyond 2 days with no end in sight.
There is a metalink note how to handle this 456378.1
However, this did not mention how to enable the Event - I did not see any way to enable. A little digging showed me that "Create Events" button has to be enabled. Enabled it myself using "FND: Diagnostics" option.
Once the oracle.apps.wf.notification.send.failure event was enabled, ensured that I created a malformed email address. Then created a test email by going to OAM->Workflow Manager -> Service Components -> "NotificationMailer"->View Details -> Test Email. selected my role and that is it. Now Oracle will generate an invalid email address or so I thought.
However, I found that the Notification was still in MAIL Status.
This led to question is the Background Engine on? I need to turn on the Background engine with all the three parameters as Y. No problem. But I need to know the Item type before I can start. Only problem is what is the Workflow Item Type? All I had was the Notification.
The Table WF_ITEM_TYPES_VL carries the Item_Type and is linked to WF_NOTIFICATIONS (WF_ITEM_TYPES_VL.NAME = WF_NOTIFICATIONS.MESSAGE_TYPE) .
I was able to see in the Mailer Log , that Workflow mailer has attempted to send a notification several times. all of them ended up with an error message: "451 Timeout waiting for client input"
Showing posts with label Notifications. Show all posts
Showing posts with label Notifications. Show all posts
Thursday, January 08, 2009
Sunday, March 02, 2008
Designing adhoc roles
I recently came across a code which creates adhoc roles for sending Missing Timecard notifications to Supervisors.
Requirement: Every timecard has to approved by the Project Manager of the Project. If a timecard is not submitted then a notification has to be sent to the Employee and to the PM of that Project.
Issue: The code I saw created one role for every timecard submitted.
Problem is an Employee will work in various projects, may be even during the same time. There is only one approver for each project. So how can you get this resolved?
The Code I saw, creates an adhoc role for every Timecard submitted. Obviously, this will create millions of rows in wf_local_user_roles, since each role created will have at least 2 persons to notify.
My preferred solution: What I would do is either create one role for every project the Employee works for and append the Project Managers to this; or, create a PLSQL table of persons to whom the notifications has to be sent and in the approval workflow, loop till this list is exhausted.
Requirement: Every timecard has to approved by the Project Manager of the Project. If a timecard is not submitted then a notification has to be sent to the Employee and to the PM of that Project.
Issue: The code I saw created one role for every timecard submitted.
Problem is an Employee will work in various projects, may be even during the same time. There is only one approver for each project. So how can you get this resolved?
The Code I saw, creates an adhoc role for every Timecard submitted. Obviously, this will create millions of rows in wf_local_user_roles, since each role created will have at least 2 persons to notify.
My preferred solution: What I would do is either create one role for every project the Employee works for and append the Project Managers to this; or, create a PLSQL table of persons to whom the notifications has to be sent and in the approval workflow, loop till this list is exhausted.
Subscribe to:
Posts (Atom)