Step 9 Implementing Notification Mailers → A notification mailer is a Java program that performs e-mail send and response processing for the Oracle Workflow Notification System, using the JavaMail API. You need to implement one or more notification mailers only if you want to have your workflow users receive their notifications by e-mail, as well as from the Worklist web pages.
Wfchlut.sql → Use wfchlut.sql to change the internal name of a lookup type and update all references to the lookup type. See: Change the internal name of a workflow object. Use the script as follows: sqlplus @wfchlut Replace with the current internal name of the lookup type, replace with the new internal name of the lookup type. Previous Next Contents Index Glossary Copyright © 2003
To Reassign a Notification to Another User → 1. You can reassign a notification in one of two ways: In the Worklist page, you check Select for one or more notifications and choose Reassign.... In the Worklist page, click on the subject link of the notification you wish to reassign. In the Detail Notification page that appears, choose Reassign... in the Response frame of the notification. Attention: Your workflow may include a special #HIDE_REASSIGN
Overview of the Oracle Workflow Business Event System → Skip Headers Oracle Workflow API Reference Release 2.6.3 Part Number B10286-02 Previous Next Contents Index Glossary Previous Next Contents Index Glossary Overview of the Oracle Workflow Business Event System The Oracle Workflow Business Event System leverages the Oracle Advanced Queuing infrastructure to communicate business events between systems. When a significant business
Error Check Process → The Error Check Process scans the Oracle Workflow item activity statuses table for activities in error. The main purpose of this process is to illustrate how you can use Oracle Workflow to design a workflow process that has the same functionality as an Oracle Alert periodic alert. You can initiate the Error Check Process to scan for database exceptions at a specified frequency. The process definition
Standard Activities → Oracle Workflow provides some generic activities you can use to control your process. The activities are associated with the Standard item type but can be used within any process you define. The Standard item type is automatically installed on your Oracle Workflow server. You can also access the Standard item type from the file wfstd.wft located on your PC in the \
Summary of the Supplier: Advanced Shipment Notice Subprocess → To view the properties of the Supplier: Advanced Shipment Notice subprocess, select its process activity in the navigator tree, then choose Properties from the Edit menu. This process activity is not runnable, indicating that it cannot be initiated as a top level process to run but must be called from a higher level process. When you display the Process window for the Supplier: Advanced Shipment Notice
Creating Multiple Transitions to a Single Activity → You can create multiple transitions to a single activity in a process diagram. Sometimes these multiple transitions indicate that there are multiple ways that the process can transition to this one node and you may want the node to execute just once. In other cases, the multiple transitions may indicate that the activity may be transitioned to multiple times because it is the starting point of a loop.
Lookup Types → A lookup type is a static list of values. These lists can be referenced by activities and by item type, message or activity attributes. For example, an activity can reference a lookup type for its possible result values, while a message attribute can reference a lookup type as a means of providing a list of possible responses to the performer of a notification. When you define a lookup type, you associate
To Copy a Lookup Code → 1. Select the lookup code to copy in the navigator tree. 2. Hold down your mouse select button as you drag the lookup code to the lookup type you want to copy it to. 3. If you drag the lookup code to the same lookup type or to a lookup type where this code already exists, then when you release your mouse button, a properties page appears for you to enter a unique internal and display name the new
Testing Workflow Definitions Using the Developer Studio → Note: The Oracle Workflow web pages are being converted to the Oracle Applications Framework user interface format. Depending on your version of Oracle Workflow and which patches you have applied, you may see Oracle Workflow web pages in the new format as well as in the previous format. The Developer Studio is currently available for the version of Oracle Workflow embedded in Oracle Applications.
Wfchitt.sql → Use wfchitt.sql to change the internal name of an item type and update all references to the item type. See: Change the internal name of a workflow object. Use the script as follows: sqlplus @wfchitt Replace with the current internal name of the item attribute, and replace with the new internal name of the item attribute. Previous Next Contents Index Glossary Copyright
Orig. Workflow Open Mail for Outlook Express Message → Oracle Workflow provides the Orig. Workflow Open Mail for Outlook Express message as an alternative template that you can optionally use as a template for e-mail notifications that require a response if you use an e-mail application such as Microsoft Outlook Express as your e-mail client. This template does not include the header attributes that are displayed in the Workflow Open Mail (Direct) message.
5 Developing Java Stored Procedures → Skip Headers Oracle® Database Java Developer's Guide 10 g Release 1 (10.1) Part Number B12021-02 Home Book List Contents Index Master Index Feedback Previous Next View PDF 5 Developing Java Stored Procedures The OracleJVM has all the features you need to build a new generation of enterprise-wide applications at a low cost. Chief among those features are stored procedures, which open the Oracle RDBMS
Example: Verify Authority → The Verify Authority function activity calls a PL/SQL stored procedure named WF_REQDEMO.VerifyAuthority
Event Subscription Definition Events → Subscription Created Oracle Workflow raises this event whenever a new subscription definition is created. Internal Name oracle.apps.wf.event.subscription.create Generate Function wf_event_functions_pkg.generate Owner Name Oracle Workflow Owner Tag FND Customization Level Limit Subscription Updated
To View and Maintain Events → 1. Use a web browser to navigate to the Event Manager, using a responsibility and navigation path specified by your system administrator. Then choose Events in the horizontal navigation. See: Oracle Workflow Developer Navigation Paths.
Protection Level → Whenever you create a workflow object in Oracle Workflow Builder, you have the option of protecting the object at a certain level. An object's protection level helps control whether other users can modify the object based on their access levels, by allowing only users with an access level equal to or lower than the object's protection level to modify the object. Note: The range of access levels allowed
To Set Engine Thresholds → To set the thresholds of background engines, specify the minthreshold and maxthreshold arguments when starting the engine. The background engine then only processes activities with costs within your specifications. The Workflow Engine threshold is set to 50 as a default. Activities with a cost higher than 50 are deferred for background engines to process. In some cases, you may want to force the engine
To View Notifications from the Worklist → 1. The Notifications Worklist either displays the notifications that match your search criteria if you navigated from the Find Notifications page, or lists all your open notifications if you navigated directly to this page. The Worklist displays the following information for each notification: Priority--a high or low priority icon represents the urgency of the notification. Type--the item type with