Arun.Gopalan

 Profile Answers by Arun.Gopalan 

• Feb 7th, 2008

 

In General you can anticipate questions such as below
1.  What are threshold in Workflows?
2. What are the Access Levels to be set for various requirements such as Read Only, Customizable etc..?
3. How are Deferred Activities started again?
4. How to Launch a Workflow?
5. What are the APIs are generally used in Workflows?
6. Is it possible to launch, Start different Processes in Workflow from Java?

Trupti

• Nov 13th, 2011

 

Ans to : 1. What are threshold in Workflows?

Each function activity and event activity has a cost or thresh hold associated with it. The cost is a value representing the number of seconds it takes for the Workflow Engine to execute the activity- minimum and maximum.

Minimum Threshold- Specify the minimum cost that an activity must have for this background engine to execute it, in hundredths of a second.

Maximum Threshold - Specify the maximum cost that an activity can have for this background engine to execute it, in hundredths of a second.

By using Minimum Threshold and Maximum Threshold you can create multiple background engines to handle very specific types of activities. The default values for these arguments are 0 and 100 so that the background engine runs activities regardless of cost.

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.

Trupti

• Nov 13th, 2011

 

2. What are the Access Levels to be set for various requirements such as Read Only, Customizable etc..?

Each user of Oracle Workflow Builder operates the system at a certain access level.

The access levels are defined as follows:
0-9: Reserved for Oracle Workflow
10-19: Reserved for Oracle Application Object Library
20-99: Reserved for Oracle E-Business Suite
100-999: Reserved for customer organizations
1000: Public

To ensure that your customizations are preserved during an upgrade of Oracle Workflow:

Check your access level before you make your modifications to the predefined workflow process.
Oracle E-Business Suite: 100

Standalone Oracle Workflow: 100 or higher

Trupti

• Nov 13th, 2011

 

3.How are Deferred Activities started again? - The process can be restarted by the Notification System, such as when a user responds to a notification; by the background engine, such as when a deferred activity is executed; or by the Business Event System, such as when an event message is dequeued from an inbound queue and sent to the workflow process. With an asynchronous process, the user does not have to wait for the process to complete to continue using the application. However, the results of the process are not available until the process is completed at a later time.

4. How to Launch a Workflow? -The Launch Process activity lets you launch another workflow process from the current process. This activity calls the PL/SQL procedure named WF_STANDARD.LAUNCHPROCESS.

5. What are the APIs are generally used in Workflows? - The Workflow Engine APIs can be called by an application program or a workflow

function in the runtime phase to communicate with the engine and to change the status of each of the activities. These APIs are defined in a PL/SQL package called
WF_ENGINE.

Workflow Engine APIs 2-19
• getItemAttributes -
setitemattributs
• Event -
• HandleError -
• SetItemParent -
• ItemStatus -
• getProcessStatus -