How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
To Define an Event → 1. Use a web browser to connect to the following URL: /wf_event_html.listevents Replace with the base URL of the web agent configured for Oracle Workflow in your Web server. See: Setting Global User Preferences, Oracle Workflow Administrator's Guide. Attention: This URL accesses a secured page, so if you have not yet logged on as valid user in the current web session, you will be prompted to do so
Noop Activity → The Noop activity acts as a place holder activity that performs no action. You can use this activity anywhere you want to place a node without performing an action. You can change the display name of this activity to something meaningful when you include it in a process, so that it reminds you of what you want this activity to do in the future. This activity calls the PL/SQL procedure named WF_STANDARD.NOOP.
Agents → An agent is a named point of communication within a system. Communication within and between systems is accomplished by sending a message from one agent to another. A single system can have several different agents representing different communication alternatives. For example, a system may have different agents to support inbound and outbound communication, communication by different protocols, different
Vote Yes/No Activity → The Vote Yes/No activity lets you send a notification to a group of users in a role and tally the Yes/No responses from those users. The results of the tally determine the activity that the process transitions to next. The Vote Yes/No activity, classified as a notification activity, first sends a notification message to a group of users and then performs a PL/SQL post-notification function to tally
What Is Supported → The following types of customizations are supported: 1. Any customization that is stated as Required in the seeded workflow's, event's, or subscription's product-specific User's Guide or documentation update notes. 2. Customization examples documented in the product-specific User's Guide or documentation update notes. Any issues that arise are fully supported to resolution, to the extent that the
Initiating a Process → A workflow process begins when an application calls the Workflow Engine CreateProcess( ) and StartProcess( ) APIs or when a Business Event System subscription sends an event to launch the process. A subprocess is started when the Workflow Engine transitions to a process activity that represents the subprocess. To launch a workflow process using the Business Event System, follow these steps: 1. Define
Accessing the Oracle Workflow Administrator Home Page → 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 administrator home page is currently available for the version of Oracle Workflow embedded in Oracle Applications.
Wfrmtype.sql → Use wfrmtype.sql to delete runtime data associated with a given item type. This script prompts you for an item type to purge from a list of valid item types, then asks you to choose between deleting all runtime data associated with the specified item type or deleting only runtime data for the completed activities and items of the specified item type. Use the script as follows: sqlplus @wfrmtype
Viewing Participant Responses → The Participant Responses page shows information about closed response-required notifications for a workflow. For example, you can use this page to view individual responses to a voting activity. The page displays the workflow type internal name and item key as well as the following details for the selected workflow: Workflow Type - The workflow item type. Status - The status of the workflow. Started
"To run the Workflow Definitions Loader for the standalone version of Oracle Workflow (Oracle Workflow Administrator's Guide)
To run the Workflow Definitions Loader for the standalone version of Oracle Workflow → 1. The Workflow Definitions Loader program is located on your server in the bin subdirectory of the Oracle Home directory structure. 2. Run the program from your operating system prompt as follows (replacing with the username, password and Oracle Net connect string or alias to your database): To apply a seed data upgrade to a database from an input file, type: wfload By using the default upgrade
Orig. Workflow Invalid Mail Message → Oracle Workflow provides the Orig. Workflow Invalid Mail message as an alternative template that you can optionally use when a user responds incorrectly to a notification. This template does not include the header attributes that are displayed in the Workflow Invalid Mail message.
3 Invoking Java in the Database → 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 3 Invoking Java in the Database This chapter gives you an overview and examples of how to invoke Java within the database. Overview Invoking Java Methods Utilizing SQLJ and JDBC for Querying the Database Debugging Server Applications
8 Java Stored Procedures Application Example → Database Tables Next, you create the database tables required by the schema plan. You begin by defining … order system by stocking parts, as follows: BEGIN po_mgr.add_stock_item(2010, 'camshaft', 245.00 … customers: BEGIN po_mgr.add_customer(101, 'A-1 Automotive', '4490 Stevens Blvd', 'San Jose', 'CA', '95129 … various customers:
Send Us Your Comments → Oracle Workflow Administrator's Guide, Release 2.6.3 Part No. B10283-02 Oracle welcomes your comments and suggestions on the quality and usefulness of this document. Your input is an important part of the information used for revision. Did you find any errors? Is the information clearly presented? Do you need more information? If so, where? Are the examples correct? Do you need more examples? What
To Schedule Background Engines → If you are using the version of Oracle Workflow embedded in Oracle Applications, you can submit the background engine procedure as a concurrent program to schedule different background engines to run at different times. Use the Submit Requests window in Oracle Applications to submit the Workflow Background Process.
WFNLADD.sql → If you enable a new language in your Oracle installation, use WFNLADD.sql to add the missing rows for that language to the Oracle Workflow translation tables. See: Setting Up Additional Languages and wfnlena.sql. Use the script as follows: sqlplus @WFNLADD Note: The wfnlena.sql and WFNLADD.sql scripts prepare the database for loading workflow definitions in another language. However, these scripts
25 OLAP_API_SESSION_INIT → Skip Headers Oracle® OLAP Reference 10 g Release 1 (10.1) Part Number B10334-02 Home Book List Contents Index Master Index Feedback Previous Next View PDF 25 OLAP_API_SESSION_INIT The OLAP_API_SESSION_INIT package provides procedures for maintaining a table of initialization parameters for the OLAP API. This chapter contains the following topics: Initialization Parameters for the OLAP API Viewing
User Defined Alert Action Process Activities → Start (Node 1) This is a Standard function activity that simply marks the start of the process. Function-- WF_STANDARD.NOOP Result Type--None Required--Yes Prerequisite Activities--None Activity Attributes Retrieved by Function--None Item Attributes Set by Function--None Item Attributes Retrieved by Function--None Notify Alert Recipient (Node 2) This is a notification activity that sends an error
Attributes → You can create an attribute for any of the following workflow process components: Item type. See: To Define an Item Type or Activity Attribute. Function activity. See: To Define an Item Type or Activity Attribute. Event activity. See: To Define an Item Type or Activity Attribute. Notification activity. See: To Define an Item Type or Activity Attribute. Message. See: To Define a Message Attribute.
"To Initiate the Event System Demonstration Workflow from the Buyer Workbench (Oracle Workflow Developer's Guide)
To Initiate the Event System Demonstration Workflow from the Buyer Workbench → 1. On the Buyer system, enter the following URL in a web browser to access the Workflow Demonstration web page: /wf_demo.home represents the base URL of the web agent configured for Oracle Workflow in your Web server. See: Setting Global User Preferences, Oracle Workflow Administrator's Guide. Choose the Events: Buyer Workbench link to display the Buyer Workbench web page. Alternatively, you can
Workflow Agent Ping/Acknowledge → You can test your Business Event System setup using the Workflow Agent Ping/Acknowledge workflow. This workflow sends a ping event message to each inbound agent on the local system or on external systems, and waits to receive an acknowledgement event message from each of the agents. If the workflow completes successfully, then the basic Business Event System setup for communication with these agents
To Respond to an HTML E-mail Notification → 1. Your HTML-formatted e-mail notification includes information that is helpful for you to respond to the notification. Depending on the notification, the information may appear as links to other sources or as attachments. Attention: If your notification preference is 'HTML Mail with attachments', an HTML-formatted e-mail notification always includes one standard attachment. The attachment is called
To Create or Update a Rule for Automatic Notification Processing → 1. Navigate to the Notification Routing Rules page and choose to create or update a rule.
To Validate a Process Definition → 1. Choose Verify from the File menu to validate all process definitions for the currently selected data store. 2. The following list is an example of some of the validation that the Verify command performs: Checks that a process has at least one Start and one End activity. Verifies that a process does not contain itself as a process activity. Restricts the same subprocess from being used twice in
Workflow Send Protocol → The Workflow Send Protocol process is a sample workflow process that demonstrates receiving, sending, and acknowledging event messages. Depending on your requirements, you can copy or customize this process to accommodate your organization's specific needs. The Workflow Send Protocol process receives an event message from a subscription, sends the event message to the inbound agent specified in the
Loop Counter Activity → Use the Loop Counter activity to limit the number of times the Workflow Engine transitions through a particular path in a process. The Loop Counter activity can have a result of Loop or Exit. This Loop Counter activity calls the PL/SQL procedure named WF_STANDARD.LOOPCOUNTER. Activity Attribute The Loop Counter activity has an activity attribute called Loop Limit. If the number of times that the Workflow
Summary of the Master Ping Process → To view the properties of the Master Ping process, select the process in the navigator tree, and then choose Properties from the Edit menu. This process activity is runnable, indicating that it can be initiated as a top level process to run. When you display the Process window for the Master Ping process, you see that the process consists of four unique activities. To examine the activities of the
Viewing Error Information for a Workflow → The Workflow Errors page shows error information for an errored workflow. The page displays the workflow type internal name and item key as well as the following details for the selected workflow: Failed Activity - The name of the activity that encountered an error. Activity Type - The activity type, either Function, Notification, Event, or Process. Error Name - The internal name of the error. Error
Workflow Open Mail (More Information Request) Message → The Notification System uses the Workflow Open Mail (More Information Request) message as a default template to send a request for more information about a notification from one user to another user. The notification template includes generic instructions on how to respond with the requested information. It also includes the following information about a message: the name of the sender of the message,
1 Introduction to Java in Oracle Database → 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 1 Introduction to Java in Oracle Database This book provides an overview on how to develop, load, and execute your Java applications in the Oracle Database. This chapter contains the following information: Chapter Contents What's
22 Package Xsl APIs for C++ → Skip Headers Oracle® XML API Reference 10 g Release 1 (10.1) Part Number B10789-01 Home Book List Contents Master Index Feedback Previous Next View PDF 22 Package Xsl APIs for C++ Xsl package contains XSLT related types and interfaces. This chapter contains these sections: Xsl Datatypes Compiler Interface CompTransformer Interface Transformer Interface XSLException Interface See Also: Oracle XML Developer's
1 Mapping Between Old and New C APIs → Skip Headers Oracle® XML API Reference 10 g Release 1 (10.1) Part Number B10789-01 Home Book List Contents Master Index Feedback Previous Next View PDF 1 Mapping Between Old and New C APIs This chapter maps the XML C APIs available in Oracle9 i release to the Unified XML C APIs available in this release of Oracle Database. The chapter contains these topics: C Package Changes Initializing and Parsing
To View the Details of a Notification → 1. Navigate to the Notification Details page. 2. In addition to general information, the notification header may also provide a history of comments forwarded from other workflow users who received notifications earlier in the workflow process. The History section displays any requests for more information and responses to those requests. The most recent History comment is marked with an asterisk icon.
Post-Notification Functions → Skip Headers Oracle Workflow API Reference Release 2.6.3 Part Number B10286-02 Previous Next Contents Index Glossary Previous Next Contents Index Glossary Post-Notification Functions You can associate a post-notification function with a notification activity. The Workflow Engine executes the post-notification function in response to an update of the notification's state
File Menu → item type. Q uick Start Wizard-- Creates a framework from which you can begin designing a workflow
Using a List of Values → 1. For a field that supports a list of values, select the field's search icon to display a Search and Select page. 2. In the Search region, select the filter to search by, depending on the type of value you are searching for. Then enter a search value in the text field and select the Go button. If you do not specify a search value, Oracle Workflow retrieves the complete list of values. 3. The Results
Summary of the Workflow Event Protocol Process → To view the properties of the Workflow Event Protocol process, select the process in the navigator tree, and then choose Properties from the Edit menu. This process activity is runnable, indicating that it can be initiated as a top level process to run. When you display the Process window for the Workflow Event Protocol process, you see that the process consists of eight unique activities, some of
Default Error Process → attribute as a relative offset from the begin date of the activity, in the unit of MINUTES to
Function Activity → A function activity is defined by the PL/SQL stored procedure or external program that it calls. Function activities are typically used to perform fully automated steps in the process. As a PL/SQL stored procedure, a function activity accepts standard arguments and can return a completion result. If you pass a parameter for the stored procedure, you can expose that parameter as an activity attribute.
To Run wfrund.sql → 1. Enter the following command to run the script wfrund.sql in SQL*PLUS: sqlplus /@ @wfrund.sql Replace /@ with the username, password, and alias for the database account where you installed the demonstration data model. Replace with the requisition number that uniquely identifies the requisition. Note: The requisition number is used as the item key for the process, so it must contain only
Notify Approver Subprocess Activities → Following is a description of each activity in the Notify Approver subprocess, listed by the activity's display name.
Event Definition Events → Event Created Oracle Workflow raises this event whenever a new individual event or event group definition is created. Internal Name oracle.apps.wf.event.event.create Generate Function wf_event_functions_pkg.generate Owner Name Oracle Workflow Owner Tag FND Customization Level Limit Event Updated
Buyer: Advanced Shipment Notice Subprocess Activities → Following is a description of each activity in the subprocess, listed by the activity's display name. Start (Node 1) This Standard function activity marks the start of the process. Function WF_STANDARD.NOOP Result Type None Prerequisite Activities None Buyer: Purchase Order ASN (Node 2) This event activity waits to receive the B2B Advanced Shipment Notice event message from the supplier. Event Action
Overview of Required Setup Steps for the Standalone Version of Oracle Workflow (Oracle Workflow Administrator's Guide)
Overview of Required Setup Steps for the Standalone Version of Oracle Workflow → 1. Set up the default Oracle Workflow user preferences for your entire enterprise using the Global Preferences web page. The Global Preferences web page also lets you define your workflow administrator role and your Workflow web agent. See: Setting Global User Preferences. 2. Ensure that a directory service is set up to provide information about the individuals and roles in your organization who may
G C API for XML (Oracle XML DB): Quick Reference → Skip Headers Oracle® XML DB Developer's Guide 10 g Release 1 (10.1) Part Number B10790-01 Home Book List Contents Index Master Index Feedback Previous Next View PDF G C API for XML (Oracle XML DB): Quick Reference This appendix provides a quick reference for the C API for XML, Oracle XML DB specific functions. This appendix contains this topic: XML Context XML Context An XML Context is a required
To View Notifications from the Advanced Worklist → 1. Use a web browser to navigate to the Advanced Worklist, using a responsibility and navigation path specified by your system administrator. See: Oracle Workflow User Navigation Paths. You can navigate to the Advanced Worklist from other Oracle Applications Framework-based Oracle Workflow web pages by choosing the Notifications tab or selecting the Notifications link at the bottom of the page, if
Event Function APIs → Skip Headers Oracle Workflow API Reference Release 2.6.3 Part Number B10286-02 Previous Next Contents Index Glossary Previous Next Contents Index Glossary Event Function APIs The Event Function APIs provide utility functions that can be called by an application program, the Event Manager, or a workflow process in the runtime phase to communicate with the Business Event System
Buyer: Send PO to Supplier Subprocess Activities → Following is a description of each activity in the subprocess, listed by the activity's display name. Start (Node 1) This Standard function activity marks the start of the process. Function WF_STANDARD.NOOP Result Type None Prerequisite Activities None XML Get Tag Value (Node 2) This Standard external Java function activity retrieves the value of a particular XML tag set in the event message. At this
To Define Event Details for an Event Node → The event action defined for the event activity determines which event details you must define for an event node. For each event detail, it is either required or optional to use an item type attribute to store or retrieve the detail information. Note that you must first create item type attributes of the appropriate types before you can reference those predefined item attributes here. The item type
Raising Events → In addition to raising events from your applications or through workflows, you can raise events that do not require additional parameters manually using the Raise Event web page for testing purposes. When you raise an event, the Event Manager searches for and executes any active subscriptions by the local system to that event with a source type of Local, and also any active subscriptions by the local
Initiating the Requisition Workflow → You can use any of the following methods to initiate the Requisition workflow: Run the script wfrund.sql. Access the Requisition Demonstration web page from the Workflow Demonstrations home page. Use the Launch Processes web page. See: Testing Workflow Definitions. You can also create your own custom end-user application interface to let users create requisitions that automatically initiate the Requisition
Notification Events → Event for Notification Send
To Create and Edit a Transition → 1. To create a transition between two activities, hold down your right mouse button and drag your mouse from a source activity to a destination activity.
Example: Notify Requisition Approval Required → The Notify Requisition Approval Required activity sends a message called Requisition Approval Required to an approving manager. The message requests that the manager approve or reject a requisition and provides details about the requisition within the body of the message.
Workflow Invalid Mail Message → The Workflow Invalid Mail message is sent to a user by default when a user responds incorrectly to a notification. For example, if a response message from a user contains a valid notification ID (NID) line matching it with a notification, but does not contain any response value or contains an invalid response value, the notification mailer sends a Workflow Invalid Mail message to the user. This message
2 Datatype and Java-to-Java Type Mappings → INTEGER) return BOOLEAN is begin if i is then return ; else return i<>0; end if; end int2bool … is the code for that function: function bool2int(b BOOLEAN) return INTEGER is begin if b is then … generated Java code: conn.prepareOracleCall = ("BEGIN:1:= WRAPPER1.PL2COMPANY_EMP_TBL … function: FUNCTION GET_EMP_TBL() BEGIN
2 ODM Java Programming → Skip Headers Oracle Data Mining Application Developer's Guide 10 g Release 1 (10.1) Part Number B10699-01 Home Book List Contents Index Master Index Feedback Previous Next View PDF 2 ODM Java Programming This chapter provides an overview of the steps required to perform basic Oracle Data Mining tasks and discusses the following topics related to writing data mining programs using the Java interface:
Using a List of Values → 1. For a field that supports a list of values, click on the field's up-arrow icon to display a list of values window. 2. In the Find field, enter search criteria and choose the Find button to retrieve a subset of values that match your criteria. You can also choose the Clear button to clear the Find field. If you do not specify any search criteria and simply choose Find, you retrieve the complete
Contents → Skip Headers Oracle Workflow API Reference Release 2.6.3 Part Number B10286-02 No Previous Next No Contents Index Glossary No Previous Next No Contents Index Glossary Contents Title and Copyright Information Send Us Your Comments Preface 1 Overview of Oracle Workflow Overview of Oracle Workflow Major Features and Definitions Workflow Processes Oracle Workflow Procedures