Installing the Product Survey Data Model
The Product Survey 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 Product Survey 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 a script called wfsrvc.sql to create a table called WF_SURVEY_DEMO and a sequence called WF_SURVEYDEMO_S. The Product Survey process updates the table WF_SURVEY_DEMO with information from each survey participant's response.
- Calls the scripts wfsrvs.sql and wfsrvb.sql to create the PL/SQL spec and body for a package called WF_SURVEYDEMO. This package contains:
- The PL/SQL stored procedures called by the function activities used in the Product Survey workflow.
- The PL/SQL procedure WF_SURVEYDEMO.Create_Survey called by the Oracle Workflow web agent to generate the web-based interface page for the Product Survey demonstration.
- Loads the Product Survey workflow definition from wfsrv.wft into the database. You can view this process in Oracle Workflow Builder.
Attention: For security reasons, the installation process automatically locks the database accounts for the users in the demonstration directory service after they are created. Before you can begin using the accounts, you must unlock them using a script called wfdemoul.sql. See: Installing the Requisition Data Model.