START PRO-ACTIVE WORKFLOW#
Processing Information#
The idea behind the UMPWF is that the pro active workflow user calculations can be scheduled to run on a regular basis.
If no where clause is defined, then the process will fire a pro-active workflow for every record in the database for the table in focus.
If no User Calc is defined, then the process will fire all of the pro-active workflow User Calcs defined for the product in focus.
Any User Calc messages will appear in the report. This may help in the case of User Calcs not firing as expected. This new process, Pro Active Workflow, enables Workflow to be scheduled. Pro Active Workflow uses where clauses to filter the data to help reduce the number of records that will qualify for the workflow to fire against.
UMPWF is run for a workflow User Calc code and for a where clause.
It should be noted that the User Calc being called should not attempt to update field values. Pro-active workflows can only be used to iniate workflow actions defined on the IMWA.On IMST there is a preference called PROACTIV_WF_LIMIT. This is used to identify the maximum number of records that a pro-active workflow can process. If not defined, it defaults to 100.
If the number of records being processed exceeds this number, then UMPWF will not complete. This is why most of the records to be examined should be determined at the Where Clause level rather than the User Calc level.
Report Parameters #
| Report Parameters | |
|---|---|
| Product | The user must select a product from the list. The report will filter the where clauses to those with the selected product. |
| User Calc Code | This is an optional field. This indicates what user calc is to be called to trigger the workflow action. Only user calcs defined with a usage of Pro Active will be displayed. |
| Where Clause | This is an optional field. This indicates what where clause is to be used to filter the data. |
| Exception Level | The user must select an exception level to run the report. This will determine the amount of trace that will be displayed to the employee. The WORKFLOW_TRACE(System_Preference) preference should be set to at least 0 or 01 to see any data in the report. If users are having trouble and are not getting the desired results, increase the workflow trace in IMST to a higher value ( ie 9 and retest the report). Be sure to decrease the trace level when you are finished so there is no performance impact on the rest of the system. |
