System Administration - Administering Oracle and CMiC Workflow

Loading Workflows into a Database

The tool for loading workflow definitions into and extracting workflow definitions from a database is Oracle Workflow Builder. When a workflow definition is extracted from a database, a .wft file is created.

If a workflow definition file needs to be loaded into the database, the Oracle wfload utility can also be used.

WFTParser.cmd is a program created by CMIC. It can be found in the D:\cm\ias\j2ee\<ENV>\workflow\bin directory.

To install a file:

cd /d D:\cm\ias\j2ee\ENV\workflow\bin
WFTParser.cmd <FULL_PATH_NAME_OF_THE_WFT_FILE>

Example for TEST:

cd /d D:\cm\ias\j2ee\test\workflow\bin
WFTParser.cmd D:\cm\v12\test\jspsql\MWH_WKF_APREGINV_WFT.wft

Logs:

The load of the logs is located in the following directory:
D:\cm\ias\j2ee\ENV\workflow\logs

Utility Scripts for Maintaining Oracle Workflow

The following scripts are all found in the JSPSQL folder on the application server(s). They should be run via sql*plus as user OWF_MGR, not DA.

The first two scripts are useful to clean out existing workflows, especially when new definitions of existing workflows are loaded.

The third script is useful to make sure that all users in the LDAP (Oracle OID) are also available for using Oracle Workflow (e.g. for sending/receiving notifications).

owkf_purge_items.sql

Run this script as user OWF_MGR to delete all completed instances of workflow items. It will not delete instances that finished on the current day. This script should be run before running owkf_purge_activities.sql.

owkf_purge_activities.sql

Run this script as user OWF_MGR to delete obsolete revisions of workflow activity definitions.  This is only useful if a lot of changes have been made to the workflow definitions. Every time a workflow is saved into the database another revision is created. All workflows launched will use the latest revision, but older workflows may still be using older revisions. Revisions still in use by a workflow item instance will not be deleted by this script, which is why owkf_purge_items.sql should be run first.

owkf_synch_all.sql

Run this script as user OWF_MGR to create workflow users for all LDAP users who are not already workflow users.