- What is a workflow and what are the benefits of using Oracle workflow? …
- What are the steps involved in oracle workflow? …
- How do you send a particular Oracle Apps Workflow Activity/Function within a workflow process into background mode?
TOP 20 Oracle Workflow Interview Questions and Answers 2019 | Oracle Workflow | Wisdom Jobs
Check Expand Roles to send an individual copy of the notification message to each user in the role. The notification remains in a user’s notification queue until the user responds or closes the notification. If you do not expand the role for a notification activity, Oracle Workflow sends one copy of the notification message to the assigned performer role and that notification is visible in the notification queue of all the users in that role. If one user in that role responds or closes that notification, the notification is removed from the notification queue of all other users in that role.
Based on the user that has logged into OA Framework, MDS defines the context of the logged in user. Based upon this logged in context, all applicable personalization is applied by MDS. Given that substitutions are loaded as site level personalizations, MDS applies the substituted BC4J objects along with the personalizations. The above-listed steps occur as soon as Root Application module has been loaded.
You define the possible results of an activity to drive different transitions using lookup codes for a lookup type. You cannot use item attributes. Separating the activity into two does not make sense since you want to drive two transactions with the same activity, but with two result codes. A process activity will not help in this scenario.
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .
If you have Expand Roles set to ‘N’ and you are sending a Notification to a Role Name, then a message is sent to every user in that role, and each individual user will see that Notification in their Notification queue until a single user in the role replies to that Notification. After which time, the Notification is wiped from each user’s Notification queue.
Purges wf process definition versions that are not used and that are obsolete. Deletes from tables: WF_ACTIVITY_ATTR_VALUES, WF_ACTIVITY_TRANSITIONS, WF_PROCESS_ACTIVITIES, WF_ACTIVITY_ATTRIBUTES_TL, WF_ACTIVITY_ATTRIBUTES, WF_ACTIVITIES_TL and WF_ACTIVITIES that are associated with the specified item type, have an END_DATE less than or equal to the specified end date and are not referenced by an existing item as either a process or activity.
In short, Once Every 12 Hours for ALL item types daily. For maintaining a healthy workflow environment, the Purge Obsolete Workflow Runtime Data request should be scheduled regularly. Below is from the Workflow Administrator’s Guide which reflects as a guideline, but the volumes differ for each instance:The Oracle Applications Manager console helps you easily maintain the Oracle Workflow and Oracle XML Gateway database tables. Oracle Workflow and Oracle XML Gateway access several tables that can grow quite large with obsolete workflow information that is stored for all completed workflow processes, as well as obsolete information for XML transactions. The size of these tables and indexes can adversely affect performance. These tables should be purged on a regular basis, using the Purge Obsolete Workflow Runtime Data concurrent program.
Master workflow runtime table is WF_ITEMS. All other runtime table records are associated to record in WF_ITEMS. If records are purged in WF_ITEMS, records ar purged in all other workflow runtime tables. Checking the workflow runtime table master table for progress purging is the same as check any other workflow runtime table.This query will help you to determine volume of wf process classified by Status, item Type, and permanency.
As lookup codes for a lookup type will define the possible results of an activity to drive different transitions using lookup codes for a lookup type. You cannot use item attributes. Separating the activity into two does not make sense since you want to drive two transactions with the same activity, but with two result codes. A process activity will not help in this scenario.
Top 20 Oracle workflow interview questions
| File | Specify the full path and name of the file that you want to download a process definition to, or upgrade or upload a process definition from. |
| Item Type | If you set Mode to “Download”, use the List button to choose the item type for the process definition you want to download. |
Get Hands-on Oracle Workflow Certification Course from Top-Rated Instructors
Q36. What are the rules supported by Workflow?
Ans:
Looping, Branching and Parallel Flow.
Q37. What are the components of workflow?
Ans:
Q38. What is the function of workflow definitions loader?
Ans:
The Workflow Definitions Loader is a utility program that moves workflow definitions between database and corresponding flat file representations.
Q39. What is workflow monitor?
Ans:
The Workflow Monitor displays an annotated view of the process diagram for particular instance of a workflow process, so that users can get graphical depiction of their work item status. The Workflow Monitor also displays a separate status summary for the work item, the process, each activity in the process.
Q40. What is Workflow Engine?
Ans:
The Workflow Engine embedded in the Oracle8 server monitors workflow states and coordinates the routing of activities for a process. Changes in workflow state, such as the completion of workflow activities, are signaled to the engine via a PL/SQL API or a Java API. Based on flexibly–defined workflow rules, the engine determines which activities are eligible to run, and then runs them. The Workflow Engine supports sophisticated workflow rules, including looping, branching, parallel flows, and subflows.
Q41. Why do we require notification systems in workflow?
Ans:
Notifications are used to handle activities that cannot be automated such as approvals for requisitions or sales orders.
Q42. What is deferred process?
Ans:
The workflow process run as background process is known as deferred process.
Q43. Define an Item?
Ans:
A specific process, document, or transaction that is managed by a workflow process. For example, the item managed by the Requisition Approval Process workflow is a specific requisition created by Oracle Internet Commerce’s Web Requisitions page.
Q44. What are the item type attributes available in workflow?
Ans:
Q45. What is the purpose of directory services?
Ans:
A mapping of Oracle Workflow users and roles to a site’s directory repository.
Q46. What is access level in workflow?
Ans:
A numeric value ranging from 0 to 1000. Every workflow user operates at specific access level. The access level defines whether the user can modify certain workflow data. You can only modify data that is protected at a level equal to or higher than your access level.
Q47. What is a process?
Ans:
A set of activities that need to be performed to accomplish a business goal.
Q48. What are the two windows available in workflow builder?
Ans:
Q49. What is a function activity?
Ans:
An automated unit of work that is defined by a PL/SQL stored procedure.
Q50.What is Top Down design?
Ans:
If you prefer to approach your design from a high level, you can first sketching out the process diagram with activities, then go back later to create the supporting objects for each activity.
FAQ
What is workflow in Oracle Apps r12?
What workflow will do on completion of activity in Oracle Apps?
- Overview of Oracle Workflow Builder.
- The Navigator Tree Structure.
- Viewing the Navigator Tree.
- Creating Process Definitions in Oracle Workflow Builder.
- Opening and Saving Item Types.
- Quick Start Wizard Overview.
- Using Oracle Workflow Builder with Different Server Versions.
How do you rewind the workflow in Oracle Apps?
Engine processing is triggered whenever a process activity completes and calls the Workflow Engine API. The engine then attempts to execute (or mark for deferred execution) all activities that are dependent on the completed activity.
