EGL:9.2 GL Journal Approval Mails Get Stuck Because Of Orphan Rows Created In PS_EOAW_NTF_PRNT

(Doc ID 1929627.1)

Last updated on JUNE 01, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
***Checked for Currency 01-JUN-2018***



When attempting to send email notification is setup for 15mins as offline using  GL Journal Approval workflow setup using.But randomly, there are orphan rows created in PS_EOAW_NTF_PRNT (with no corresponding rows in PS_JRNL_AF_XREF). Due to this the entire email delivery is put on hold.The following error occurs.ein Notification status page ( Main Menu > Enterprise Components > Approvals > Notifications and Escalations > Status )

Approval process -GLJournalApproval- has no instantiated process with Id 8321. (18081,1052) EOAW_CORE.Utils.OnExecute  Name:GetThreadRecDetails  PCPC:21516  Statement:529 Called from:EOAW_EMAIL.EmailSender.OnExecute  Name:notifyAction  Statement:98 Cal

The issue can be reproduced at will with the following steps:
1) Create  a journal
2)Edit the journal
3)submit for approval
4)This triggers a email
5)update the existing journal
6)Resubmit the journal for approval
7)Run Escalation and Notification the emails can be sent




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms