Introduction to workflow

  • Tool from Oracle
  • Works with Oracle Database
  • PL/SQL Based
  • Widely Used with Oracle Applications
  • Can be Used Stand-Alone or with Oracle Apps

Need of workflow

Workflow can be described as the flow of information and control in a business process.

  • Routing the information
  • Defining and modifying business rules
  • Delivering electronic notifications
  • Integrating systems

Workflow Advantages

  • Human Element in Decision Making
  • Flexible Processes
  • Electronic Notifications
  • System Integration
  • PL/SQL Based Architecture

Workflow Components

  • Workflow Engine
  • Workflow Builder
  • Workflow Definition Loader
  • Notification System
  • Business Event System
  • Directory Services

Workflow architecture

Workflow Engine

  • Embedded in database
  • Uses the process definition created with Oracle workflow Builder to coordinate the routing of activities of a Process
  • Monitors each activity in a workflow Process
  • Signals any change in the workflow state using calls to PL/SQL or JAVA APIs
  • Guarantees consistency between application and workflow state because of Oracle database transnational Integrity
Recent Posts

Start typing and press Enter to search