Oracle Application Workflows FAQ

1. I do not wish to have “Notification Detail.html” attachment in my email notifications. How can I avoid?

Set the Email preference to HTML mail. It will send notifications as HTML-formatted e-mail only, without any standard attachments. However users must read their e-mail using an HTML e-mail client. If there are custom attachments defined for individual notifications in a process, those attachments will be included.

 2. What is the impact of reducing “Processor Min Loop Sleep” for agent listeners or components for type “Workflow Agent Listener”?

This parameter carries minimum amount of time in seconds the processing thread(s) will sleep when nothing has been read. Thread only sleeps when it does not process anything in last iteration. If there is steady stream of messages, sleep should not matter. If there are bursts of messages with no activity in between, this parameter will only affect how soon agent listener reacts to and process new messages. So, if reaction time needs to be improved, sleep can be reduced but note, it will also cause more polling and in absence of activity it may not be worth it.

 3. How to remove Action History region from notifications in Applications 11.5.10?

Define the special message attribute #HISTORY with a null value to suppress the action history for a notification. Please see Oracle Workflow Developer’s Guide for more information.

 4. Why does the Email notification shows red cross mark in the place of GIF image?

Oracle Workflow Java mailer will attempt to resolve image references in notifications only if the notification contains a framework region. The source URL for the image needs to be accessible from the recipient’s client. When the image is behind a firewall, than the email client may not have access to it. Image can also be attached to an email if the ATTACH_IMAGES mailer configuration parameter is enabled.

 5. When a contact is created for the customer, a role is getting created for the contact with notification preference as ‘QUERY’. Hence the mailer is not sending email notification to this contact. How the notification preference can be defaulted to ‘MAILHTML’ or ‘MAILTEXT’ for these roles?

If the role is being created using the wf_directory.createAdhocUser API, It is possible to set the notification preference in the API call, otherwise the default notification preference would be used. The default notification preference is controlled in the “Workflow Administrator Web Applications” responsibility. There is an “Administration” link. On that page you will find the default notification preference setting.

 6. Why the summary email notifications are not closed automatically even after enabling the Autoclose FYI mailer parameter?

This is expected behavior. Enabling Autoclose FYI is applicable only to notifications that are being emailed individually to the users with Notification Preference MAILHTML, MAILTEXT, MAILATTH or MAILHTM2 but not with SUMMARY or SUMHTML. However, since the summary notifications contain only the subject headers for the individual notifications, they have to be reviewed/actioned before closing the notification.

 7. For some records, WF_NOTIFICATION_OUT table shows the message state 3, which means such messages are expired. Should I rebuild the queue to bring these messages back to normal state?

Some messages could expire and move to exception queue after certain retries.

Following select statement can be executed to check the retry count and message status.

Select corr_id, msg_state, retry_count, count(msg_id) from$wf_notification_out group by corr_id, msg_state, retry_count;

Instead of rebuilding the queue, use the concurrent program “Move messages from Exception to Normal Queue of Workflow Agent” to move messages from exception queue to normal queue for agent WF_NOTIFICATION_OUT.

 8. How to stop sending out the “Cancel” emails when notification time out occurs in standalone workflow 2.6.4?

It is not possible at standalone workflow 2.6.4 code level.

Note: For Embedded workflow, the WF: Mailer Cancellation Email profile option has been obsoleted in 11i.ATG_PF.H Rollup 3 patchset level as this feature has been replaced by the Send E-mails For Canceled Notifications (SEND_CANCELED_EMAIL) mailer parameter.

 9. A message attribute of type ‘Text’ and source ‘Respond’ has been created for a response required approval notification to allow approvers to enter any comments. So, what is the maximum length of text can approver enter as comments?

Maximum length of a Text attribute is 4000 bytes. It is stored within a VARCHAR2 column and thus it can be upto 4000 bytes and not characters. Please note that multibyte character can take more than 1 byte.

6 thoughts on “Oracle Application Workflows FAQ

  1. Can you please provide me the list or details of all the workflows that are available in Oracle Financials modules.

    Thanks and regards,

    Viswa (Visvanathan)


  2. 1.How to Cacel or Retrived the Notifications from Managers Inbox Summary.
    I will exaplin
    First one employee will rasie the Leave Request and submit to the manager
    same time the notification mailer goes to Manager if manager approves or rejects no problem.
    the manager can’t response any thing within 2 days at that time employee wants to cancel the Leave request. Suppose Cancel Leave request happaend Here Notifcation will be send to manager and the previous notications will be cancelled.
    How we can canecl the notification here Please let me know if any body knows.



  3. Sir i have nt received any reply for this question which i have passed it 3 days back…

    Q)Develop a tooltip functionality using custom.pll in the standard po form to show the dependent po’s.(The moment cursor hovers on the PO number field,it should display the dependent po’s)…


  4. Q)New W/f creation to ensure the orders need to be approved based on the approver tied up with the transaction type..
    (Few Orders need not be approved.If no approver is assigned to a particular order type then need to default to standard functionality)..

    Q)OM:Cost of goods sold workflow customization to take it from concerned office in the place of inventory organization.


Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s