Explore topic-wise InterviewSolutions in .

StartProcess, The StartProcess API begins the EXECUTION of an activity. The CreateProcess API creates a NEW runtime process for an ITEM. The ResumeProcess API resumes a suspended item. The BeginActivity determines if the specified activity may currently be PERFORMED on the item.

StartProcess, The StartProcess API begins the execution of an activity. The CreateProcess API creates a new runtime process for an item. The ResumeProcess API resumes a suspended item. The BeginActivity determines if the specified activity may currently be performed on the item.

Routes information, Sends notifications, Defines PROCESS rules. The PRIMARY purposes of a workflow are to ROUTE information, send notification, and define process rule. Although some history is maintained AUTOMATICALLY by ORACLE Workflow, it will not be considered as creating audit trails.

Routes information, Sends notifications, Defines process rules. The primary purposes of a workflow are to route information, send notification, and define process rule. Although some history is maintained automatically by Oracle Workflow, it will not be considered as creating audit trails.

ACTIVITY COST > Workflow Engine THRESHOLD

An activity is DEFERRED when the activity cost is greater than the Workflow Engine threshold. If the activity cost = 0 or if the activity cost is less than the Workflow Engine threshold, the activity will become Active.

Activity cost > Workflow Engine threshold

An activity is deferred when the activity cost is greater than the Workflow Engine threshold. If the activity cost = 0 or if the activity cost is less than the Workflow Engine threshold, the activity will become Active.

SET the user-friendly IDENTIFIER for an ITEM. The SetItemUserKey API is used for SETTING a user-friendly identifier for an item.

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

The Workflow Engine issues a savepoint when a function ACTIVITY is completed. The Workflow Engine never issues a commit; the CALLING application issues a commit. The Workflow Engine does not generate a LOG file or notify users.

The Workflow Engine issues a savepoint when a function activity is completed. The Workflow Engine never issues a commit; the calling application issues a commit. The Workflow Engine does not generate a log file or notify users.

When you have more than one process ASSOCIATED with an item TYPE, you need a selector to select a process. You use the Role Resolution standard activity to perform role resolution. Voting is another standard activity. Multiple result codes drive different TRANSITIONS, but this is not RELATED to the selector.

When you have more than one process associated with an item type, you need a selector to select a process. You use the Role Resolution standard activity to perform role resolution. Voting is another standard activity. Multiple result codes drive different transitions, but this is not related to the selector.

The Workflow Builder in Oracle Workflow is the graphical interface for workflow processes. The Workflow ENGINE DRIVES items through workflow processes. The Workflow MONITOR allows you to view and monitor workflow process instances and the Workflow Definitions Loader LOAD workflow definitions from a text FILE or database.

The Workflow Builder in Oracle Workflow is the graphical interface for workflow processes. The Workflow Engine drives items through workflow processes. The Workflow Monitor allows you to view and monitor workflow process instances and the Workflow Definitions Loader load workflow definitions from a text file or database.

A USER MUST be a role. A role cannot be created in the WORKFLOW BUILDER. Having one active responsibility is not a requirement for a user to be a role. A role can have more than one user.

A user must be a role. A role cannot be created in the Workflow Builder. Having one active responsibility is not a requirement for a user to be a role. A role can have more than one user.

An internal name for a WORKFLOW BUILDER component MUST be in uppercase, have no SPACES, and be UNIQUE within item type.

An internal name for a Workflow Builder component must be in uppercase, have no spaces, and be unique within item type.

Common application PROCESSES Common application processes come before the PRODUCT FAMILY processes, which come before product-specific processes. Common FINANCIAL is one of the product family processes. It does not come before product family processes.

Common application processes Common application processes come before the product family processes, which come before product-specific processes. Common financial is one of the product family processes. It does not come before product family processes.

StartProcessThe StartProcess API begins the EXECUTION of an activity. The Create Process API creates a new RUNTIME process for an item. The Resume Process API RESUMES a suspended item. The BEGIN Activity determines if the SPECIFIED activity may currently be performed on the item.

StartProcessThe StartProcess API begins the execution of an activity. The Create Process API creates a new runtime process for an item. The Resume Process API resumes a suspended item. The Begin Activity determines if the specified activity may currently be performed on the item.

Having a Respond message attribute Having a Respond message attribute will solicit responses from a notification activity. The display name will BECOME the prompt and the DESCRIPTION will be the INSTRUCTION. NOTHING else, such as a time-out parameter, a performer, or a Send message attribute, will have an affect in SOLICITING responses.

Having a Respond message attribute Having a Respond message attribute will solicit responses from a notification activity. The display name will become the prompt and the description will be the instruction. Nothing else, such as a time-out parameter, a performer, or a Send message attribute, will have an affect in soliciting responses.

NOTIFICATION a time-out PARAMETER only applies to a notification activity since the time-out parameters are USED to measure when a notification expires. It does not apply to a FUNCTION activity or a process activity.

Notification a time-out parameter only applies to a notification activity since the time-out parameters are used to measure when a notification expires. It does not apply to a function activity or a process activity.

As lookup CODES for a lookup type 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.

As lookup codes for a lookup type 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.

Routes INFORMATION, Sends notifications, Defines process rules. The primary purposes of a workflow are to ROUTE information, send notification, and define process rule. Although some history is maintained automatically by Oracle Workflow, it will not be CONSIDERED as creating audit trails.

Routes information, Sends notifications, Defines process rules. The primary purposes of a workflow are to route information, send notification, and define process rule. Although some history is maintained automatically by Oracle Workflow, it will not be considered as creating audit trails.

Activity cost > Workflow ENGINE THRESHOLD activity is deferred when the activity cost is greater than the Workflow Engine threshold. If the activity cost = 0 or if the activity cost is LESS than the Workflow Engine threshold, the activity will BECOME Active.

Activity cost > Workflow Engine threshold activity is deferred when the activity cost is greater than the Workflow Engine threshold. If the activity cost = 0 or if the activity cost is less than the Workflow Engine threshold, the activity will become Active.

WF_LOCAL_ROLES

WF_LOCAL_ROLES

a) if initiating the process using start_process, do the below

wf_engine.threshold := -1;

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

wf_engine.startprocess(l_itemtype, l_itemkey)

b) When initiating the WORKFLOW process through an EVENT SUBSCRIPTION, set the Execution CONDITION Phase to be equal to or above 100 for it to be EXECUTED by background process.

a) if initiating the process using start_process, do the below

wf_engine.threshold := -1;

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

wf_engine.startprocess(l_itemtype, l_itemkey)

b) When initiating the workflow process through an event subscription, set the Execution Condition Phase to be equal to or above 100 for it to be executed by background process.

Design & create a Workflow using Oracle Workflow Builder start the Oracle Workflow process from pl/sql integrate Oracle Workflow with pl/sql for VALIDATION and DML ETC. BUILD Oracle Workflow NOTIFICATIONS attach roles/people to notifications in Oracle Workflow.

Design & create a Workflow using Oracle Workflow Builder start the Oracle Workflow process from pl/sql integrate Oracle Workflow with pl/sql for validation and DML etc. build Oracle Workflow Notifications attach roles/people to notifications in Oracle Workflow.

Oracle workflow is a graphical tool that allows you to CREATE, TRACK and modify business process, EMBEDDED in the oracle database server, it can monitor the workflow activity statuses.

Benefits:

1. Create a CLEAR business process definition
2. Automate the business routings
3. Monitor the process
4. Allow users to define their own business process to suit their organization needs.
5. Readily CHANGE the business process definitions in case of a change business process

Oracle workflow is a graphical tool that allows you to create, track and modify business process, embedded in the oracle database server, it can monitor the workflow activity statuses.

Benefits: