GeekInterview.com
Series: Subject: Topic:
Question: 40 of 75

Oracle workflow interview questions.

Asked by: Interview Candidate | Asked on: Oct 23rd, 2006

Editorial / Best Answer

Answered by: Arun.Gopalan

View all answers by Arun.Gopalan

Member Since Feb-2008 | Answered On : 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
Arun.Gopalan

Answered On : Feb 7th, 2008

View all answers by Arun.Gopalan

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?

Yes  5 Users have rated as useful.
  
Login to rate this answer.
Trupti

Answered On : 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.

  
Login to rate this answer.
Trupti

Answered On : 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

  
Login to rate this answer.
Trupti

Answered On : 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 -

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

AOL Interview Questions

Oracle Apps Technical Interview Questions

AR Interview Questions

Oracle Apps Basics Interview Questions

D2K Interview Questions

Flexfields Interview Questions

Oracle Forms Interview Questions

GL Interview Questions

HRMS Interview Questions

ONT Interview Questions

Scope and Application Interview Questions

Oracle Apps Security Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.