ERP tables - WF (Work Flow)
ERP tables - WF (Work Flow)
brief ( and important 
) details of WorkFlow tables.
lets first learn some definations.
A process activity is a modelled workflow process, which can be included as an activity in
other processes to represent a sub–process.
A notification activity sends a message to a performer.
A functions activity performs an automated function that is written as a PL/SQL stored procedure.
A folder activity is not part of a process,it provides a means of grouping activities.
below is the most important tables for Work Flow module.
WF_ACTIVITIES stores the definition of an activity.
Activities can be processes, notifications, functions or folders.
WF_ITEMS is the runtime table for workflow processes
Each row defines one work item within the system.
WF_ITEM_ATTRIBUTES table stores definitions of attributes associated with a process.
Each row includes the sequence in which the attribute is used as well as the format of the attribute data.
WF_NOTIFICATIONS holds the runtime information about a specific instance of a sent message.
A new row is created in the table each time a message is sent.
find more such Quick info about ERP tables at http://www.appsbi.com/
Filed under: 11i, ERP, Glossary, Interview Questions(& answers), Oracle Apps
Leave a Reply
You must be logged in to post a comment.