My Oracle Support Banner

R12: AP: AP Invoice Approval Child Process Workfow Notification Stuck in Error for Validate Invoices (Doc ID 2950345.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Oracle Payables - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

Workfow notification Error generated for approved invoices

We see around 350 invoices Stuck in ‘Invoice Approval’ workflow activity.  Even though these Invoices are validated and approved, Workflows are still in Error state.
These workflows are completing successfully when we retry from workflow admin.

The following SQL return the problem transactions:

 

All problem records have ACTIVITY_STATUS = ERROR and ACTIVITY_RESULT_CODE differ between #STUCK and #EXCEPTION.  Among these, three(3) distinct pattern/groups were identified:

  1. Records with ACTIVITY_RESULT_CODE = #EXCEPTION have ERROR_STACK referring to a custom APIs like server-side API package XXCEAP_WF_AME_PKG, or custom workflow entities (activity, attribute, etc) and/or PROCESS_NAME referring to custom workflow processes, like APPROVAL_INVOICE_CMG, and CEI_EINVOICE_APPROVAL_MAIN_NEW.
      
  2. Records with ACTIVITY_RESULT_CODE = #STUCK and Invoice Workflow Approval status NOT "Approved" (AP_INVOICES_ALL.wfapproval_status <> 'WFAPPROVED') meaning: INITIATED, or MANUALLY APPROVED, or REJECTED, etc)
    and the Invoice Validation status is "Needs reapproval".
        
  3. Records with ACTIVITY_RESULT_CODE = #STUCK and Invoice Workflow Approval status "Approved" (AP_INVOICES_ALL.wfapproval_status = 'WFAPPROVED'). 
       

 

Cause

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
Symptoms
Cause
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.