My Oracle Support Banner

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 FEBRUARY 07, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.