Installing the Product Survey Data Model (Oracle Workflow Help)

Oracle Workflow Guide
Release 2.6.2
Part Number A95265-03


				Contents	Index	Glossary	Master Index	Feedback

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.

The data model for the Product Survey process also relies on the demonstration directory service used by the sample Requisition process. See: Installing the Requisition Data Model.

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.


	Previous	Next		Contents	Index	Glossary