My Oracle Support Banner

Error ORA-06502 creating a case pointing to a problem with EGO_USER_ATTRS_DATA_PVT Insert_Row (Doc ID 2161510.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Customer Support - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Create Service Request

When attempting to create a new Case in Case Worker or Customer Support Specialist, and switching SR Types between two SR Types that have different attribute groups, when trying to save the following error occurs.

ERROR
-----------------------
Executing - "EGO_USER_ATTRS_DATA_PVT"."Insert_Row" "ORA-06502: PL/SQL: numeric or value error: character to number conversion error"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Case Worker or Customer Support Specialist
2. Search for a Party
3. Start the new Case/SR creation with an SR Type that has a certain attribute group associated to it
4. During the Case/SR creation, select a different SR Type that has a different attribute group associated to it
5. Enter all the remaining mandatory information
6. When try to save the case, the reported error occurs

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.