Depot Repair Error: 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small' When Calling API CSD_REPAIR_ESTIMATE_PUB If A Custom Billing Type Is Used (Doc ID 1666357.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Depot Repair - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 05-JUN-2016**

Symptoms

On : 12.1.3

When attempting to create repair estimate lines via the API CSD_REPAIR_ESTIMATE_PVT an error occurs when using custom billing categories

ERROR
-----------------------
The following error is raised:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
in Package CSD_REPAIR_ESTIMATE_PVT Procedure CREATE_ESTIMATE_LINE


STEPS
-----------------------
The issue can be reproduced at will with the following stes:

Call API CSD_REPAIR_ESTIMATE_PUB.CREATE_ESTIMATE_LINE and passing data with a custom billing type.


Cause

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 hundreds of Community platforms