My Oracle Support Banner

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.

 

Steps to reproduce:

  1. Log into Oracle Applications using the Payables Responsibility
  2. The user reviews its Worklist.
  3. 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:

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
 CONCLUSION FOR DEBUG ERROR PLS-00302
 CONCLUSION FOR DATA CORRUPTION
Solution
 CODE-FIX FOR ERROR PLS-00302
 DATA-FIX APPROACH FOR DUPLICATES
References


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