workflow
It can be done from Oracle Application Manager available in System administrator responsibility.
Using the standard functions available in WFSTD Item type we define start and end functions. They are standard to which we dont need to link any PL/SQL function and return any value to it.
WF_NOTIFICATIONS, WF_MESSAGES, WF_COMMENTS, WF_ROLES, WF_ATTRIBUTES e.t.c
Function is used perform some PL/SQL operation and finally received input from PL/SQL procedure or function. It can not send emails to users. where are Notification can be used to send email notification to users and also perform PL/SQL operations.
use AND fucntion from WFSTD item type.
Item Type is the boss in heirarchy or workflow components. Item type holds all sub components like functions, notifications, lookups, messages, attributes, events e.t.c Item Key is unique key which need to be provided for itemtype while running an instance or workflow. Combination of itemtype,itemkey should be always unique.
Roles are simillar to email distribution lists. Roles holds group of users to send email.
We can do in two ways 1. from command prompt using wfload 2. open workflow in standalone builder and then do save as and select database.
User OR Function from WFSTD(Standard) itemtype.
admin
ans for question 2: The access levels are maintained in the workflow to avoid un necessary customisations.the default access level is 100. say for eg : the access level of workflow A is 20, only those people /group with access levels 20 or above can do any change to that wf.
How do you use attribute values in workflow messages?
You can embed message attributes in the text or HTML body. Oracle Workflow token replaces the message attributes with runtime values when it delivers the notification. To embed a message attribute, enter an ampersand (“&”) followed by the message attribute’s internal name.
Q) How do you use lookups in workflow?
Ans ) A lookup type is a static list of values. For example, an activity can reference a lookup type for its possible result values.
Q) To send an email to the user workflow notification is the only way or is there any other ways to send it?
Ans) Workflow notification is not the only way,We can also send mails to users through Plsql procedures
Q) How many processes can each workflow contain?
Ans ) There is no restriction .a process can contain a process activity in its diagram, that process activity is known as a subprocess. There is no restriction on the depth of this hierarchy. To display the subprocess diagram in a process window, double-click on the subprocess activity node in the parent process window.
Q) What is Runnable option in workflow? At what level it exists?
Ans) A workflow may have many process associated to it, The runnable option determines which process is the parent process to be initiated. It exists in the process level
Q) What are different types of attributes in workflow?
Ans) There are 10 different types of attributes in Oracle WF, afew are text,Number,date,form,document etc
Q) How do you reassign a notification?
Ans) In the Notification Details page for a single notification, There would be a Reassign button, Using this we can reassign the notification.
Q) How can you send direct oracle form link through workflow notifications?
Ans ) We can accomplish this by using the Form attribute type whose value would be the internal function name of the form
Q) Can you send html code in workflow notification?
Ans ) Yes