Trade Management Claim Settlement By RMA Error: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.WF_NOTIFICATION" (Doc ID 1586385.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 15-May-2016***

Symptoms

During Claim entry using claim settlement method "RMA", intermittently receive error.

Error

ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.WF_NOTIFICATION", line 5774 ORA-06512: at line 6.


It is due to by messages from Order Management (OM) when the RMA is created

Workflow Details Error

The flexfield on this field contains a value set that uses special or pair user-exit validation. This prohibits operation in the mode that optimizes performance over a wide-area network. To continue using this form, have the system administrator either remove the all special or pair validated value sets from this flexfield definition, or turn off wide area operation by setting the profile option - Flexfields: Validate on Server to N.



It cannot be reproduced.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms