Installing the Demonstration Data Model
The demonstration data model for the sample Requisition Approval process is available for installation only for the standalone version of Oracle Workflow. The demonstration data model is installed using Oracle Installer. Oracle Installer asks if you wish to install the demonstration data model when you install the Oracle Workflow server. The files used in the installation are copied to the demo or demo/<language> subdirectories of your Oracle Workflow server directory structure.
Attention: For the Requisition Approval process demonstration to work properly, you should perform the steps required to set up Oracle Workflow after you install the demonstration data model. See: Implementing Oracle Workflow.
The installation does the following:
- Calls a script called wfdemoc.sql to create two tables with seed data. These tables make up the demonstration database application that is workflow-enabled:
- WF_REQDEMO_EMP_HIERARCHY--maintains the employee approval hierarchy. The approval chain consists of these employee userids listed in ascending order with the employee having the most authority listed last: JANDERSON, DMCKEE, MBEECH, JRUSH, and JSMITH.
- WF_REQDEMO_EMP_AUTHORITY--maintains the spending limit for each employee. The limit for each employee follows the employee's userid: JANDERSON:500, DMCKEE:1000, MBEECH:2000, JRUSH:3000, JSMITH:4000.
- The script wfdemoc.sql also inserts the following seed data into the WF_LOCAL_USERS, WF_LOCAL_ROLES, WF_LOCAL_USER_ROLES tables:
|
| SYSADMIN
| x
|
|
|
|
| WFADMIN
| x
|
|
|
|
| JANDERSON
|
|
| x
|
|
| DMCKEE
|
|
| x
|
|
| MBEECH
|
|
| x
| x
|
| JRUSH
|
| x
|
| x
|
| JSMITH
|
| x
|
|
|
Each of these users have their E-mail address assigned to 'WFTEST'. This allows you to use one mail account to check/test their notifications. You can also change each user's E-mail address to anything you like by editing the wfdemoc.sql script and rerunning it.
Also every user except JANDERSON has a Notification Preference of 'MAILHTML', which allows them to get individual notifications via E-mail if a Notification Mailer is set up. JANDERSON has a Notification Preference of 'SUMMARY', which allows him to receive a periodic E-mail summarizing all the notifications he has received if an appropriate Notification Mailer is set up. In all cases, users can also always query for their notifications using a Web browser by connecting to the Oracle Workflow Notification Web page.
Attention: Your Oracle Workflow directory service must include the WF_LOCAL_USERS, WF_LOCAL_ROLES and WF_LOCAL_USER_ROLES tables for the wfdemoc.sql script to run properly. See: Setting Up an Oracle Workflow Directory Service.
- Calls the scripts wfdemos.sql and wfdemob.sql to create the PL/SQL spec and body for a package called WF_REQDEMO. This package contains:
- The PL/SQL stored procedures called by the function activities used in the Requisition Approval Process workflow.
- The PL/SQL procedure WF_REQDEMO.Create_Req called by the Oracle Workflow web agent to generate the web-based interface page for the Requisition Approval process demonstration.
- Runs the Workflow Resource Generator to load messages from wfdemo.msg into the database. The messages are used by the web-based interface page for the Requisition Approval process demonstration.
- Loads the Requisition Approval Process workflow definition from wfdemo.wft into the database. You can view this process in Oracle Workflow Builder.
