Workflow error during booking, for Sales order with more than 24 lines
Hi all;
when creating a sales order with more than 24 lines (plys TAX lines and Discount Lines), the html mail is not generated and send to the approuver
the notification is in error with the following message
[WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused by:
2020: Error when getting notification content. Caused by: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Wf_Notification.runFuncOnBody(945828, text/html)
Wf_Notification.GetBody(945828, text/html)
WF_NOTIFICATION.GetFullBody(nid =>945828, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 945828, r_ntf_pref => MAILHTML)' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=