When Use Extensible Attribute To Store Records In Customer Support HTML Page ORA-O6502 Error Occurs
(Doc ID 1570486.1)
Last updated on DECEMBER 09, 2020
Applies to:Oracle Customer Support - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, APIs & Interfaces
When attempting to use extensible attributes in the Customer Support HTML application causes the below error.
Executing - "EGO_USER_ATTRS_DATA_PVT"."Get_Extension_Id_And_Mode" "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Create value sets for contact roles.
2. Add value sets with appropriate queries with person, contact and Telephone.
3. Add appropriate attributes and Groups.
4. Associate appropriate Service Request Types.
5. Associate appropriate pages.
Now, Open Customer Support HTML and create a service request.
Open the Service request and try to add the same values in two rows for the attributes.
The above mentioned error occurs.
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