Skip Headers

Oracle Workflow Administrator's Guide
Release 2.6.3.5

Part Number B12160-02
Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

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.

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.

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


         Previous  Next          Contents  Index  Glossary



Oracle Logo
Copyright © 2003, 2004, Oracle. All rights reserved.