Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Oracle Seeded Workflow Scripts

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Oracle Seeded Workflow Scripts

    This document gives detail description about Oracle seeded Workflow Administration Scripts.

    1. wfver.sql
    wfver.sql is used to display the version of the Oracle Workflow server, the status and version of the Oracle Workflow PL/SQL packages, and the version of the Oracle Workflow views installed.
    Usage:sqlplus <user/pwd> @wfver

    2. wfbkgchk.sql
    wfbkgchk.sql is used to get a list of all activities waiting to be processed by the background engine the next time it runs.
    Usage : sqlplus <user/pwd> @wfbkgchk

    3. wfdirchk.sql
    wfdirchk.sql is used to check for the following conditions in our directory service data model:
    o Invalid internal names that contain the characters ’#’, ’:’,or ’/’ in WF_USERS.
    o Invalid compound names in WF_USERS or WF_ROLES.
    o Duplicate names in WF_USERS or WF_ROLES.
    o Multiple names in WF_USERS or WF_ROLES linked to the same row in the original repository.
    o Missing display names in WF_USERS or WF_ROLES.
    o Invalid Notification Preference or null email address if the Notification Preference is MAILTEXT, MAILHTML, or SUMMARY in WF_USERS or WF_ROLES.
    o Invalid Status in WF_USERS.
    o Rows in WF_USERS that do not have a corresponding row in WF_ROLES.
    o Invalid internal names in WF_ROLES that contain the characters ’#’ or ’/’ or have a length greater than 30 characters.
    o Invalid user/role foreign key in WF_USER_ROLES.
    o Missing user/role in WF_USER_ROLES (every user must participate in its own role).
    o Duplicate rows in WF_USER_ROLES.
    Please Note : wfdirchk.sql should return no rows to ensure that our directory service data model is correct.
    Usage:sqlplus <user/pwd> @wfdirchk

    4. wfntfsh.sql
    wfntfsh.sql is used to display status information about a particular notification, given its notification ID.
    Usage:sqlplus <user/pwd> @wfntfsh <notification_id>

    5. wfrefchk.sql
    wfrefchk.sql is used to check for invalid workflow data that is missing primary key data for a foreign key.
    Usage:sqlplus <user/pwd> @wferfchk

    6. wfretry.sql
    wfretry.sql is used to display a list of activities that have encountered an error for a given process instance and then specify whether to skip,retry, or reset any one of errored activities.
    Usage:sqlplus <user/pwd> @wfretry <item_type> <item_key>
    Provide an item type and item key to uniquely identify an item or process instance. The script first returns the list of errored activities by label name. The script then prompts for the label name of an activity that we wish to skip, retry, or reset. If we choose skip, then we need to specify the result that we want the skipped activity to have.

    7. wfstat.sql
    wfstat.sql is used to display a developer status report for an indicated item. The output is 132 characters per line.
    Usage:sqlplus <user/pwd> @wfstat <item_type> <item_key>

    8. wfstatus.sql
    wfstatus.sql is used to display an end user status report for an indicated item. The output is 132 characters per line.
    Usage:sqlplus <user/pwd> @wfstatus <item_type> <item_key>

    9. wfstdchk.sql
    wfstdchk.sql is used to check and report any problems found in the Oracle Workflow data model. For example, this script will report any function activities that reference invalid functions and scan the tables of each workflow process definition object to verify that each row has a valid internal name and display name.
    Usage:sqlplus <user/pwd> @wfstdchk

    10. wfverchk.sql
    We will use wfverchk.sql script if we suspect that problems arising in your workflow process are due to multiple versions of an activity being active simultaneously. This script identifies errors in versions of activities that cause multiple versions to appear to be active at once.
    Usage:sqlplus <user/pwd> @wfverchk

    11. wfverupd.sql
    wfverupd.sql is used to correct problems arising in your workflow process that are due to multiple versions of an activity being active simultaneously. This script identifies and corrects errors in versions of activities that cause multiple versions to appear to be active at once.
    Usage:sqlplus <user/pwd> @wfverupd

+ Reply to Thread

Similar Threads

  1. Scripts to list Scheduled and Running Jobs from DBMS_JOB
    By Hemant in forum Database Scripts
    Replies: 0
    Last Post: 01-01-2012, 01:40 PM
  2. Check if the workflow background Engine is working for given workflow in last 2 days
    By Hemant in forum SCRIPTS : Concurrent Manager and Workflow
    Replies: 0
    Last Post: 11-01-2011, 09:51 AM
  3. Retrieve the log file of active workflow mailer and workflow agent listener Container
    By Hemant in forum SCRIPTS : Concurrent Manager and Workflow
    Replies: 0
    Last Post: 11-01-2011, 09:47 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics