Error When Querying A Contact "ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small ORA-06512" (Doc ID 3051612.1)

Last updated on OCTOBER 09, 2024

Applies to:

Symptoms

When attempting to query or open any contracts the following error occurs.

This was working before. The error started occurring for all users and all contracts after additional business units were added.

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "FUSION.FND_SESSION_NS", line 941 ORA-01403: no data found ORA-06512: at "FUSION.FND_SESSION_NS", line 914 ORA-06512: at "FUSION.FND_GLOBAL", line 279 ORA-06512: at "FUSION.FND_GLOBAL", line 231 ORA-06512: at "FUSION.HZ_SESSION_UTIL", line 66 ORA-06512: at "FUSION.HZ_SESSION_UTIL", line 379 ORA-06512: at "FUSION.HZ_SESSION_UTIL", line 555 ORA-06512: at "FUSION.HZ_SESSION_UTIL", line 816


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Contracts > Search
2. Enter a search term and search
3. 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.