Workflow Scripts: Source Oracle Documentations<\/p>\n
The below are the collection of Workflow Administration Scripts and\/or Concurrent Program.<\/p>\n
1. FNDWFPR<\/strong><\/p>\n For Oracle Workflow embedded in Oracle Applications, use the standard concurrent program FNDWFPR \u201dPurge Obsolete Workflow Runtime Data<\/strong>\u201d to purge old data from the Oracle Workflow runtime tables regularly. Navigate to the Submit Requests form in Oracle Applications to submit the Purge Obsolete Workflow Runtime Data concurrent program. When you install and set up Oracle Applications and Oracle Workflow, your system administrator needs to add this concurrent program to a request security group for the responsibility that you want to run this program from.<\/p>\n You can supply the following parameters for the \u201dPurge Obsolete Workflow Runtime Data\u201d concurrent program:<\/p>\n Item Type \u2014 The item type to purge. Leaving this field blank defaults to purging the runtime data for all item types.<\/p>\n Item Key \u2014 The item key to purge. Leaving this field blank defaults to purging the runtime data for all item keys.<\/p>\n Age \u2014 Minimum age of data to purge, in days.’<\/p>\n 2. wfbkgchk.sql<\/strong><\/p>\n Use wfbkgchk.sql to get a list of all activities waiting to be processed by the background engine the next time it runs.<\/p>\n Usage : sqlplus <user\/pwd> @wfbkgchk<\/p>\n 3. wfdirchk.sql<\/strong><\/p>\n Use wfdirchk.sql to check for the following conditions in your directory service data model:<\/p>\n a. Invalid internal names that contain the characters \u2019#\u2019, \u2019:\u2019, b. Invalid compound names in WF_USERS or WF_ROLES.<\/p>\n c. Duplicate names in WF_USERS or WF_ROLES.<\/p>\n d. Multiple names in WF_USERS or WF_ROLES linked to the same row in the original repository.<\/p>\n e. Missing display names in WF_USERS or WF_ROLES.<\/p>\n f. Invalid Notification Preference or null email address if the Notification Preference is MAILTEXT, MAILHTML, or SUMMARY in g. Invalid Status in WF_USERS.<\/p>\n h. Rows in WF_USERS that do not have a corresponding row in WF_ROLES.<\/p>\n i. Invalid internal names in WF_ROLES that contain the characters \u2019#\u2019 or \u2019\/\u2019 or have a length greater than 30 characters.<\/p>\n j. Invalid user\/role foreign key in WF_USER_ROLES.<\/p>\n k. Missing user\/role in WF_USER_ROLES (every user must participate in its own role).<\/p>\n l. Duplicate rows in WF_USER_ROLES.<\/p>\n wfdirchk.sql should return no rows to ensure that your directory service data model is correct.<\/p>\n Usage:sqlplus <user\/pwd> @wfdirchk<\/p>\n 4. wfntfsh.sql<\/strong><\/p>\n Use wfntfsh.sql to display status information about a particular notification, given its notification ID.<\/p>\n Usage:sqlplus <user\/pwd> @wfntfsh <notification_id><\/p>\n 5. wfrefchk.sql<\/strong><\/p>\n Use wfrefchk.sql to check for invalid workflow data that is missing primary key data for a foreign key.<\/p>\n Usage:sqlplus <user\/pwd> @wferfchk<\/p>\n 6. wfretry.sql<\/strong><\/p>\n Use wfretry.sql to display a list of activities that have encountered an error for a given process instance and then specify whether to skip, Usage:sqlplus <user\/pwd> @wfretry <item_type> <item_key><\/p>\n Provide an item type and item key to uniquely identify an item or process instance. The script first returns the list of errored 7. wfstat.sql<\/strong><\/p>\n Use wfstat.sql to display a developer status report for an indicated item. The output is 132 characters per line.<\/p>\n Usage:sqlplus <user\/pwd> @wfstat <item_type> <item_key><\/p>\n 8. wfstatus.sql<\/strong><\/p>\n Use wfstatus.sql to display an end user status report for an indicated item. The output is 132 characters per line.<\/p>\n Usage:sqlplus <user\/pwd> @wfstatus <item_type> <item_key><\/p>\n 9. wfstdchk.sql<\/strong><\/p>\n Use wfstdchk.sql to check and report any problems found in the Oracle Workflow data model. For example, this script will report any function Usage:sqlplus <user\/pwd> @wfstdchk<\/p>\n 10. wfver.sql<\/strong><\/p>\n Use wfver.sql to display the version of the Oracle Workflow server, the status and version of the Oracle Workflow PL\/SQL packages, and the Usage:sqlplus <user\/pwd> @wfver<\/p>\n 11. wfverchk.sql<\/strong><\/p>\n Use wfverchk.sql if you suspect that problems arising in your workflow process are due to multiple versions of an activity being active Usage:sqlplus <user\/pwd> @wfverchk<\/p>\n 12. wfverupd.sql<\/strong><\/p>\n Use wfverupd.sql 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.<\/p>\n Usage:sqlplus <user\/pwd> @wfverupd<\/p>\n","protected":false},"excerpt":{"rendered":" Workflow Scripts: Source Oracle Documentations The below are the collection of Workflow Administration Scripts and\/or Concurrent Program. 1. FNDWFPR For […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[172,126],"tags":[174,474,471,173],"class_list":["post-292","post","type-post","status-publish","format-standard","hentry","category-scripts","category-workflow","tag-oracle-apps-workflow","tag-scripts","tag-workflow","tag-workflow-scripts"],"yoast_head":"\n
\nor \u2019\/\u2019 in WF_USERS.<\/p>\n
\nWF_USERS or WF_ROLES.<\/p>\n
\nretry, or reset any one of those errored activities.<\/p>\n
\nactivities by label name. The script then prompts you for the label name of an activity that you wish to skip, retry, or reset. If you
\nchoose skip, then you must also specify the result that you want the skipped activity to have.<\/p>\n
\nactivities that reference invalid functions and scan the tables of each workflow process definition object to verify that each row has a valid
\ninternal name and display name.<\/p>\n
\nversion of the Oracle Workflow views installed.<\/p>\n
\nsimultaneously. This script identifies errors in versions of activities that cause multiple versions to appear to be active at once.<\/p>\n