Installing Workflows in CMiC R12

Overview

This article provides detailed instructions for installing workflows in CMiC R12. For additional information on installing workflows, please refer to Workflow – R12.

Procedure

There are two options for installing workflows in CMiC 12.

Option 1: Oracle Workflow Builder by Programming

This option requires that a developer connect to the database directly from the Oracle Workflow Builder tool and install the workflow. This option works on either database 12.1 and older, or on 18c databases with authentication security disabled. If authentication security is enabled, the following message will be issued to the developer: “ORA-28040: No matching authentication protocol”.

Since authentication security is enabled on all 18c databases, this option will only work if Oracle Workflow Builder is installed on an 18c Oracle Client. This is outside of the scope of discussion here and the possibility of a project getting Oracle Workflow Builder is outside of DBA control.

For most clients, disabling authentication security is not an option.

Option 2: WFTParser.cmd Utility by CMIC DBAs

This option requires that the system is on patch V12-010-1 or higher.

WFTParser.cmd is located in:

D:\cm\ias\j2ee\ENV\workflow\bin.

To see how it is used:

Run D:\cm\ias\j2ee\ENV\workflow\bin\WFTParser.cmd 

To install a file:

cd /d D:\cm\ias\j2ee\ENV\workflow\bin

WFTParser.cmd <FULL_PATH_NAME_OF_THE_WFT_FILE>

For example, the following is an example using TEST:

cd /d D:\cm\ias\j2ee\j2ee\test\workflow\bin

WFTParser.cmd D:\cm\v12\test\jspsql\MWH_WKF_APREGINV_WFT.wft

Log files from the WFTParser are located in:

D:\cm\ias\j2ee\ENV\workflow\logs

Patches V12-009-2 and Earlier

Instructions and necessary files for installing WFTParser are located in: 

X:\Installation\ias\workflow

For clients on patches V12-009-2 and earlier, the DBAs will need to manually set up the file on the client environments unless the client has no plans to upgrade to patch V12-010-1 and the workflow needs to be loaded.