My Oracle Support Banner

Clicking Skills Button On Task Tab Results In Error: ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR (Doc ID 2309662.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Service Request Form

Clicking Skills button on Task Tab results in Error
the following error occurs.

ERROR
-----------------------
APP-CSF-223257: Error in ASSIGNMENTS.GET_SKILL_NAME_AND_DESC: ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR: character buffer string too small ORA-06512: at "SYS.DBMS_SQL",line 1854

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open SR FOrm and enter details
2. Go to Tasks tab fill in details
3. Click on Skills button

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.