R12: AP: Duplicate AP Invoice Approval Notificaitons, After Correcting Error "AME PLS-00302: Component 'SENDNOTIFICATION' Must Be Declared" (Doc ID 2854110.1)

Last updated on APRIL 09, 2024

Applies to:

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

Symptoms

All AP Invoice Approval workflow Notifications raise the following error when user clicks on the notification link from the Worklist

Error Name = WFE_DISPATCH_RULE_ERR
Error Message = 3825: Error '-6550 - ORA-06550: line 1, column 21:
PLS-00302: component 'SENDNOTIFICATION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored' encountered during execution of Rule function 'wf_xml.SendNotification' for event 'oracle.apps.wf.notification.send' with key '6032784'.
Error Stack =
Wf_Event.dispatch_internal()
Wf_Notification.SendSingle(FND_RESP|SQLAP|CCH_AP_DEPT_APPROVER|STANDARD, APINVAPR, DOCUMENT_APPROVAL_MSG, 16-DEC-21, WF_ENGINE.CB)
Wf_Notification.Send(FND_RESP|SQLAP|CCH_AP_DEPT_APPROVER|STANDARD, APINVAPR, DOCUMENT_APPROVAL_MSG, 16-DEC-21, WF_ENGINE.CB)
Wf_Engine_Util.Notification_Send(APINVAPR, 7096642-1, 364475, APINVAPR:DOCUMENT_APPROVAL_MSG)
Wf_Engine_Util.Notification(APINVAPR, 7096642-1, 364475, RUN)
Activity Id = 364475
Activity Label = APPROVAL_INVOICE:DOCUMENT_APPROVAL_REQUEST
Result Code = #EXCEPTION
Notification Id =
Assigned User =

Issue was resolved by disabling the wf_xml.sendnotification function from the business event oracle.apps.wf.notification.send.group.

Post reprocessing, user noticed duplicates of these errored AP Invoice Approval Workflow notifications now showing up in the Worklist.

No issue with Workflow Mailer and in above scenario users do not use Email notifications. Instead, they respond to the notifications from their Worklist.

Issue is not occurring for Fresh workflows, issue only occurs for earlier reprocessed workflows.

Approximately 1500+ workflows with duplicate entries in their workflows.

Approval Management (AME) is used for all AP, GL workflows. The issue is with multiple products workflow approval notifications. But, primary focus is with AP Invoice Approval Workflow duplicate notifications.

Due to this duplicate lines, users are confused which is the correct one.

If user clicks on the bad one(they do not know which is the bad one), it throws errors.
If they click on good one, it gets processed and cleared from the worklist.

Steps to reproduce:

Log into Oracle Applications using the Payables Responsibility
The user reviews its Worklist.
User finds two(2) AP Invoice Approval Workflow notifications for the same Invoice.

Changes

The API WF_XML.SendNotification() has been obsoleted and not longer used. Hence, disabled the wf_xml.sendnotification function from the business event oracle.apps.wf.notification.send.group, using the following MOS document: