My Oracle Support Banner

How to Run Workflow Data Collection Scripts for an Oracle Engineering Approval Process Workflow for Debugging Purposes (Doc ID 344092.1)

Last updated on JULY 03, 2023

Applies to:

Oracle Engineering - Version 11.5.3 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
FORM:ENGFDECN.FMB - Define engineering change order


Goal

*** This document includes all versions of Oracle EBS 11i and R12 ***

The goal of this document is to describe how to obtain and run data collection scripts for troubleshooting issues related to the Engineering Change Order (ECO) approval process workflows. Oracle Support may ask for these script outputs when the ECO workflow process fails or exhibits other problems. The scripts are:

  • wfstatus.sql - Display Workflow Status Information
  • bde_wf_item.sql - Runtime Data of a Single Workflow Item
  • bde_wf_notif.sql - Output Workflow Related Data For a Single Notification
  • bde_wf_data.sql - Query Workflow Runtime Data That Is Eligible For Purging

 

Solution

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
Goal
Solution
References

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