My Oracle Support Banner

Purchase Orders Appproval via Email fails With Workflow Error at SET_FORWARD_TO_FROM_APPROVE Activity (Doc ID 2899091.1)

Last updated on AUGUST 31, 2023

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.2.11 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Approvals - Req, PO

POs cannot be approved from email notifications. Approving the same via worklist within the application works successfully.

When approver tries to approve the document from email client, the PO approval workflow fails at activity SET_FORWARD_TO_FROM_APPROVE with error below:

SET_FORWARD_TO_FROM_APPROVE (Set Forward-To/From For Approve Action)        
#EXCEPTION        
-20001        
ORA-20001: Error de Oracle -20001: Se detecto ORA-20001: Error de Oracle -2396: Se detecto ORA-02396: exceeded maximum idle time, please connect again
ORA-02063: line precediendo a SIMAPORT
 en fnd_global.set_nls.set_parameter('NLS_LANGUAGE','LATIN AMERICAN SPANISH').
 en fnd_global.set_nls."        
PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR(POAPPRV, 7106807-367453, SET_CTX)
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR, POAPPRV, 7106807-367453, SET_CTX)
Wf_Engine_Util.Execute_Selector_Function(POAPPRV, 7106807-367453, SET_CTX)
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_FINDAPPRV1.SET_FWD_TO_FROM_APP_TIMEOUT, POAPPRV, 7106807-367453, 289004, RUN)

WFStat Activity Statuses shows:

BEGIN_DATE     END_DATE     Process / Activity     Process Name     Activity Name     STATUS     RESULT     ASSIGNED_USER     NID     Status     ACTION     PERFORMED_BY    
31-AUG-22 18:30:21     NOTIFY_APPROVER_SUBPROCESS / PO_PO_APPROVE_PDF     Notify Approver Subprocess     Approve PO Notification with PDF     COMPLETE     APPROVE     ELO******     626268     CLOSED         
31-AUG-22 18:35:52     NOTIFY_APPROVER_SUBPROCESS / END-4     Notify Approver Subprocess     End     COMPLETE     #NULL                     
31-AUG-22 18:35:52     NOTIFY_APPROVER_PROCESS / SET_FORWARD_TO_FROM_APPRO-1     Notify Approver     Set Forward-To/From For Approve Action     ERROR     #EXCEPTION

Output of script $FND_TOP/sql/wfmlrdbg.sql for the approval notification PO_PO_APPROVE_PDF (Standard Purchase Order 79983, for MXN 88.75 requires your approval) shows the following Notification Attribute Values:

MAIL_ERROR_MESSAGE     ORA-20002: 3202: La notificacion '626268' esta cerrada actualmente.
MAIL_ERROR_NAME     <blank>
MAIL_ERROR_STACK     WF_XML.handleReceiveEvent(oracle.apps.wf.notification.receive.message, C0F79E8FE39B266EE0301490C8C41 A0C)


Steps to reproduce:
 1. PO is submitted for approval from PO form within Purchasing Responsibility
 2. Approver logs into Email client and responds to approval notification email with action 'Approve'
 3. Workflow fails at SET_FORWARD_TO_FROM_APPROVE activity with the error above

Changes

 

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
Changes
Cause
Solution


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