Installing the Requisition Data Model
The Requisition data model is installed only with the standalone version of Oracle Workflow. The data model is automatically installed for you by the Workflow Configuration Assistant. The files used in the installation are copied to the demo and demo/<language> subdirectories of your Oracle Workflow server directory structure.
Attention: For the Requisition process demonstration to work properly, you should perform the steps required to set up Oracle Workflow after the installation See: Overview of Setting Up.
The installation does the following:
- Calls the script wfdemou.sql to create a database account for each of the users listed in the seed data table shown below. The script creates public grants and synonyms so that these accounts have full access to Oracle Workflow's web-based user interface.
- 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: BLEWIS, KWALKER, CDOUGLAS, and SPIERSON.
- WF_REQDEMO_EMP_AUTHORITY--maintains the spending limit for each employee. The limit for each employee follows the employee's userid: BLEWIS:500, KWALKER:1000, CDOUGLAS:2000, and SPIERSON:3000.
- 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
|
|
|
|
| BLEWIS
|
|
| x
|
|
| KWALKER
|
|
| x
|
|
| CDOUGLAS
|
|
| x
| x
|
| SPIERSON
|
| x
|
| x
|
Attention: Each user has an e-mail address of 'WFINVALID' and each role has an e-mail address identical to its role name. You can change the users' and roles' e-mail addresses to other values by calling the Directory Service APIs SetAdHocUserAttr or SetAdHocRoleAttr. Alternatively, if you want e-mail notifications for all the users and roles to go to a single e-mail inbox, you can specify a test e-mail address in the configuration file of the Notification Mailer. See: To create a configuration file for the Notification Mailer.
Attention: Also all users except BLEWIS have a Notification Preference of 'MAILHTML', which allows them, in addition to viewing notifications from the Notifications Web page, to get individual notifications via e-mail. BLEWIS has a Notification Preference of 'SUMMARY', which allows him, in addition to viewing notifications from the Notifications Web page, to receive a periodic e-mail summarizing all his currently open notifications. Note that a Notification Mailer must be set up to deliver e-mail notifications.
Attention: Your Oracle Workflow directory service views must map to the WF_LOCAL_USERS, WF_LOCAL_ROLES and WF_LOCAL_USER_ROLES tables to include the users and roles of the Requisition data model. 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 packages called WF_REQDEMO and WF_DEMO. These packages contain:
- The PL/SQL stored procedures associated with the demonstration home page.
- The PL/SQL stored procedures called by the function activities used in the Requisition 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 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 process demonstration.
- Loads the Requisition Process workflow definition from wfdemo.wft into the database. You can view this process in Oracle Workflow Builder.
