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 MARCH 10, 2023

Applies to:

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

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