My Oracle Support Banner

Workflow Notification Error During Execution Of Function WF_XML.Generate (Doc ID 3005503.1)

Last updated on FEBRUARY 28, 2024

Applies to:

Oracle Workflow - Version 12.2.12 to 12.2.12 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.12 version, Workflow Mailer

Workflow notification error during execution of function WF_XML.Generate

ERROR
-----------------------
WF_ERROR] ERROR_MESSAGE=3835: Error '-1422 - ORA-01422: exact fetch returns more than requested number of rows' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK= WF_XML.Generate(oracle.apps.wf.notification.send, 8116738) WF_XML.Generate(oracle.apps.wf.notification.send, 8116738) Wf_Event.setMessage(oracle.apps.wf.notification.send, 8116738, WF_XML.Generate) Wf_Event.dispatch_internal()

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.function WF_XML.Generate
2.check for notificaiton Mailer


Changes

 No 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
References


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