Miscellaneous SQL Scripts (Oracle Workflow Help)


	Previous	Next		Contents	Index	Glossary	Library

Miscellaneous SQL Scripts

You can use any of the following administrative scripts to help set up and maintain various features in Oracle Workflow. For the standalone version of Oracle Workflow, the scripts are located on your server in the Oracle Workflow admin/sql subdirectory. For the version of Oracle Workflow embedded in Oracle Applications, the scripts are located in the sql subdirectory under $FND_TOP.

Update translation tables--WFNLADD.sql.

Start a background engine--wfbkg.sql.

Show activities deferred for the next background engine execution--wfbkgchk.sql.

Show a notification's status--wfntfsh.sql.

Reset the protection level for objects--wfprot.sql.

Handle errored activities--wfretry.sql.

Remove data from Oracle Workflow tables

wfrmall.sql.

wfrmitms.sql.

wfrmitt.sql.

wfrmtype.sql.

wfrmita.sql.

Run a workflow process--wfrun.sql.

Display a status report for an item

wfstatus.sql.

wfstat.sql.

Display the version of the Oracle Workflow server--wfver.sql.

Check the directory service data model--wfdirchk.sql.