Claim Notification Error ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small
(Doc ID 2829480.1)
Last updated on MAY 30, 2023
Applies to:
Oracle Trade Management - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.9 version, CLAIMS
Some users are receiving email notifications for Claims approval process as workflow has errored.
ERROR
-----------------------
Error Name = WF_ERROR
Error 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-20002: 3240: Error '-6502 - ORA-06502: PL/SQL: numeric or value error: character string buffer too small
' in 'PLSQL' API 'AMS_GEN_APPROVAL_PVT.ntf_forward_fyi'
OZF_CLAIM_APPROVAL_PVT.NOTIFY_REQUESTOR_FYI(AMSGAPP, CLAIMCLAMxxxxxxxxx)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Trade Management User > Claims
2. Select the Claim and submit claim for approval
3. Check the Workflow notification for error
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 |