This content has been marked as final. Show 3 replies
The following note has steps to fix this issue.
Running WFSTATUS and WFRETRY For Oracle Purchasing Workflows [ID 134960.1]
I have already tried these scripts but this did not help me.
Check the status of the PO and the wfstat.
A. Are you able to get hold of the item type / item key from PO Headers? You can also directly hit wf_items (the user_key = document number) to find the wf process.
B. What is the current authorization status of the PO?
If A cannot be located and if B is incomplete status you should have any issue.
If A is found and if B is incomplete status you should abort the wf process and try submitting the document for approval.
If A is found and if B is in In Process / Pre Approved status then you should be able to use the wfretry to retry the workflow.
If A is not found and if B is in In Process / Pre Approved, you should be able to reset the PO using reset script $PO_TOP/sql/poxrespo.sql and resubmit it for approval.
If none of the above works cleanly, you can always abort the workflow process (if found) and use the reset script to reset the PO and then submit the PO.