My Oracle Support Banner

Running WFSTAT and WFRETRY For Oracle Purchasing Workflows (Doc ID 134960.1)

Last updated on JUNE 07, 2021

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!


In this Document
Purpose
Troubleshooting Steps
 Running WFSTAT and WFRETRY
 Instructions to run wfstat
 Requisition:
 
Purchase Order:
 
Purchase Order Release:
 Instructions to run wfretry
 Requisition:
 Purchase Order:
 Purchase Order Release:
 Alternate retry method:
 Instructions to run wfstat for Createpo workflow
 Instructions to run wfstat for Account Generator Workflow
 Still Have Questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.