Running WFSTAT and WFRETRY For Oracle Purchasing Workflows
(Doc ID 134960.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle Purchasing - Version 11.5.10 to 12.2 [Release 11.5 to 12.2] Information in this document applies to any platform.
Purpose
The purpose of this article is to explain the use of the script wfstat and wfretry in order to monitor and retry workflow processes.
File wfstat.sql is a script that can be run to determine why a document is stuck. It usually provides the user with information that can be used to resolve the stuck document. Once the problem has been resolved, wfretry can be executed on the stuck document to get it moving through the system again.
In addition to instructions on running wfstat.sql and wfretry.sql, this document provides details about how to get the values necessary to run wfstat.sql for purchase orders, release, requisitions and account generator.
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
