When Use Extensible Attribute To Store Records In Customer Support HTML Page ORA-O6502 Error Occurs (Doc ID 1570486.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Symptoms

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.