Miscellaneous SQL Scripts (Oracle Workflow Help)

Oracle Workflow Guide
Release 2.6.2
Part Number A95265-03


				Contents	Index	Glossary	Master Index	Feedback

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.

Enable/disable a language--wfnlena.sql

Run a workflow process--wfrun.sql.

Start a background engine--wfbkg.sql.

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

Display a status report for an item

wfstatus.sql.

wfstat.sql.

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

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

Handle errored activities--wfretry.sql.

Check for version and process definition errors

wfverchk.sql.

wfverupd.sql.

wfstdchk.sql.

Check for invalid hanging foreign keys--wfrefchk.sql.

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

Clean up Workflow Queues in the system tables--wfqclean.sql.

Change the internal name of a workflow object

Note: Generally, you cannot update the internal name of a workflow object in Oracle Workflow Builder. However, if you load your process definition to a database, you can use one of these scripts to update a workflow object's internal name if no runtime data exists for the object. You should only use these scripts to correct errors in an object's internal name during design time. Do not use these scripts to rename objects that are involved in running instances of processes.

wfchact.sql.

wfchacta.sql.

wfchita.sql.

wfchitt.sql.

wfchluc.sql.

wfchlut.sql.

wfchmsg.sql.

wfchmsga.sql.

Remove data from Oracle Workflow tables

wfrmall.sql.

wfrmitms.sql.

wfrmitt.sql.

wfrmtype.sql.

wfrmita.sql.

Note: In Oracle Applications, a standard concurrent program called "Purge Obsolete Workflow Runtime Data" is also available. See: FNDWFPR.

If you are using the standalone version of Oracle Workflow available with Oracle9i Release 2, you can use the standalone Oracle Workflow Manager component available through Oracle Enterprise Manager to submit and manage Workflow purge database jobs. For more information, please refer to the Oracle Workflow Manager online help.

Purge and repopulate the outbound message queue for the Notification Mailer--wfmqupd.sql.

Warning: This script should only be used when Oracle Support determines it to be necessary. Do not run this script unless directed by Oracle Support.

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

Stop the Java Function Activity Agent--wfjvstop.sql.

Enqueue an event message on a queue using an override agent--wfevtenq.sql.

Run a listener to monitor an agent for inbound event messages--wfagtlst.sql.

Note: In Oracle Applications, a standard concurrent program called "Workflow Agent Listener" is also available. See: FNDWFLST.

If you are using the standalone version of Oracle Workflow available with Oracle9i Release 2, you can use the standalone Oracle Workflow Manager component available through Oracle Enterprise Manager to submit and manage Workflow agent listener database jobs. For more information, please refer to the Oracle Workflow Manager online help.


	Previous	Next		Contents	Index	Glossary