You can use the following administrative scripts to help set up and maintain various features in Oracle Workflow. The scripts are located in the $FND_TOP/sql directory. Oracle Workflow also provides some administrative concurrent programs that you can run using Standard Request Submission. See: Running Reports and Programs.

• Update translation tables - WFNLADD.sql.

• Enable/disable a language - wfnlena.sql

• Run a workflow process - wfrun.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.

• Display debugging information for a notification - wfmlrdbg.sql.

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

• Handle errored activities - wfretry.sql and Retry Errored Workflow Activities (FNDWFRET).

• 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.

• 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.

• Purge obsolete data - Purge Obsolete Workflow Runtime Data (FNDWFPR).

• Display the version of the Oracle Workflow server - wfver.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.

• Display debugging information for an event - wfbesdbg.sql.