My Oracle Support Banner

R12: AP: Payables Invoice Approval Timeing Out / Escalated For CEO Leads To Error "ORA-20212: No Surrogate Approver Exists For..." (Doc ID 2527586.1)

Last updated on AUGUST 12, 2024

Applies to:

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

Symptoms

AP Invoice Approval times out / escalated for CEO leads to error "ORA-20212: No surrogate approver exists for ..."

Customer AP Invoice approval process is set up to go directly to the CEO for AP Invoices with amount greater than 50.000 Euro.  If the CEO does not approve after 5 days, he gets a notification reminder (this is OK).  If he still does not approve then after 5 more days, the Workflow does an escalation ("Escalate Document Approval").  The "Escalate Document Approval" activity fails with the error ORA-20212

 

A dump of the AME Exceptions table AME_EXCEPTIONS_LOG shows the following:


An output of script $FND_TOP/patch/115/sql/WFStat.sql executed and invoice, shows the following "**** Errored Activities"

**** Errored Activities
Activity               RESULT       Error Name Error Message
---------------------- ------------ ---------- ---------------------------------------------------------------------
ESCALATE_DOC_APPROVAL  #EXCEPTION   -20212     ORA-20212: No surrogate approver exists for Mül**************rkus.

  Error Stack
  -----------------------------------------------------------------------------------------------------------------------------------
  AME_APPROVER_TYPE_PKG.getSurrogate(365430)
  AME_ENGINE.processUnresponsiveApprovers(365431)
  AME_ENGINE.updateTransactionState(365432)
  AME_ENGINE.getNextApprovers(365433)
  AME_API2.getNextApprovers1(365434)
  APINVAPR.get_header_approver(APINVAPR, 17225322-3, 333764, RUN)
  Wf_Engine_Util.Function_Call(AP_WORKFLOW_PKG.escalate_doc_approval, APINVAPR, 17225322-3, 333764, RUN

 

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.