Oracle workflow interview questions.

Editorial / Best Answer

Arun.Gopalan  

  • Member Since Feb-2008 | 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?

Showing Answers 1 - 4 of 4 Answers

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.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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 -

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions