Interview Questions.

Q1. Which Work Engine Api Should You Use To Begin Execution Of An Activity In Oracle Workflow?

StartProcessThe StartProcess API starts offevolved the execution of an hobby. The Create Process API creates a new runtime method for an item. The Resume Process API resumes a suspended object. The Begin Activity determines if the desired interest may also currently be achieved on the object.

Q2. When Starting (kicking Off) An Oracle Workflow Process, How Do You Ensure That It Happens In A Background Mode?

A) if initiating the procedure using start_process, do the beneath

wf_engine.Threshold := -1;

wf_engine.Createprocess(l_itemtype,l_itemkey,'’);

wf_engine.Startprocess(l_itemtype, l_itemkey)

b) When initiating the workflow procedure through an event subscription, set the Execution Condition Phase to be identical to or above one hundred for it to be executed by using historical past technique.

Q3. Can You Send Blob Attachments Via Workflow Notifications?

Yes, you can send BLOB Attachments.

Q4. Time-out Parameters Apply To Which Activity In Oracle Workflow?

Notification a time-out parameter only applies to a notification activity for the reason that time-out parameters are used to measure whilst a notification expires. It does now not observe to a characteristic interest or a system pastime.

Q5. What Will Solicit Responses From A Notification Activity?

Having a Respond message characteristic Having a Respond message characteristic will solicit responses from a notification interest. The display call will become the activate and the outline might be the guidance. Nothing else, which include a time-out parameter, a performer, or a Send message attribute, may have an affect in soliciting responses.

Q6. Which Work Engine Api Should You Use To Begin Execution Of An Activity?

StartProcess, The StartProcess API begins the execution of an hobby. The CreateProcess API creates a new runtime method for an item. The ResumeProcess API resumes a suspended item. The BeginActivity determines if the desired pastime may additionally presently be completed at the item.

Q7. What Is The Primary Purpose Of A Oracle Workflow?

Routes information, Sends notifications, Defines process guidelines. The primary purposes of a workflow are to course statistics, send notification, and outline system rule. Although a few records is maintained routinely through Oracle Workflow, it will not be taken into consideration as developing audit trails.

Q8. How Will You Define The Possible Results Of An Activity In Order To Drive Different Tritions?

As research codes for a lookup type you define the possible effects of an interest to pressure distinct tritions the usage of research codes for a lookup type. You cannot use item attributes. Separating the pastime into two does no longer make sense since you want to power  tractions with the equal activity, but with  result codes. A technique hobby will now not assist on this state of affairs.

Q9. What Is The Primary Purpose Of A Workflow?

Routes information, Sends notifications, Defines procedure guidelines. The primary purposes of a workflow are to path information, send notification, and define manner rule. Although some records is maintained automatically by Oracle Workflow, it will not be taken into consideration as creating audit trails.

Q10. What Is The Proper Format For An Internal Name In The Workflow Builder Component?

An internal call for a Workflow Builder factor need to be in uppercase, don't have any spaces, and be  unique inside item type.

Q11. When Will An Activity Be Deferred In Oracle Workflow?

Activity cost > Workflow Engine threshold pastime is deferred while the hobby price is more than the Workflow Engine threshold. If the interest value = zero or if the activity price is much less than the Workflow Engine threshold, the activity turns into Active.

Q12. Which Of The Following Statements Is True?

A consumer need to be a position. A position cannot be created within the Workflow Builder. Having one lively duty isn't a requirement for a consumer to be a position. A function may have multiple user.

Q13. Give Me One Example Where Apps Uses Partitioning In Oracle Workflow?

WF_LOCAL_ROLES

Q14. What Are The Steps Involved In Oracle Workflow?

Design & create a Workflow the usage of Oracle Workflow Builder start the Oracle Workflow manner from pl/sq.  Integrate Oracle Workflow with pl/square for validation and DML and so on.  Construct Oracle Workflow Notifications attach roles/people to notifications in Oracle Workflow.

Q15. What Is Workflow And What Are The Benefits Of Using Oracle Workflow?

Oracle workflow is a graphical tool that allows you to create, track and alter business method, embedded within the oracle database server,  it may reveal the workflow hobby statuses.

Benefits:

Create a clear enterprise system definition

Automate the enterprise routings

Monitor the process

Allow customers to define their own commercial enterprise process to suit their business enterprise needs.

Readily alternate the enterprise technique definitions in case of a exchange commercial enterprise system

Q16. When Do You Need A Selector For An Item Type?

When you've got more than one process related to an item kind, you need a selector to pick out a method. You use the Role Resolution widespread hobby to perform position resolution. Voting is any other standard hobby. Multiple result codes drive one-of-a-kind tritions, but this isn't associated with the selector.

Q17. Which Component In Oracle Workflow Is The Graphical Interface For Workflow Processes?

The Workflow Builder in Oracle Workflow is the graphical interface for workflow approaches. The Workflow Engine drives gadgets through workflow strategies. The Workflow Monitor allows you to view and monitor workflow technique times and the Workflow Definitions Loader load workflow definitions from a text file or database.

Q18. How Do You Send A Particular Oracle Apps Workflow Activity/feature Within A Workflow Process Into Background Mode?

If fee of the workflow pastime is more than 50, then the workflow pastime could be processed in heritage mode most effective, and it received’t be processed in on-line mode.

Q19. What Job Does The Setitemuserkey Api Perform?

Set the person-friendly identifier for an object.  The SetItemUserKey API is used for setting a user-friendly identifier for an object.

Q20. When Will An Activity Be Deferred?

Activity cost > Workflow Engine threshold

An activity is deferred while the activity price is extra than the Workflow Engine threshold. If the interest fee = 0 or if the hobby fee is less than the Workflow Engine threshold, the pastime will become Active.

Q21. What Does The Workflow Engine Do When A Function Activity Has Finished?

The Workflow Engine problems a savepoint whilst a function pastime is completed. The Workflow Engine in no way problems a dedicate; the calling utility troubles a devote. The Workflow Engine does not generate a log file or notify customers.

Q22. Which Implementation Process Group Comes Before The Product Family Processes?

Common software processes Common software methods come earlier than the product own family strategies, which come before product-specific methods.  Common financial is one of the product family processes. It does no longer come before product family techniques.

Q23. What Are The Various Ways To Kick-off A Workflow?

You can eiter use wf_engine.Start_process  or  you may connect a runnable method such that it subscribes to a workflow event.