My Oracle Support Banner

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 JULY 14, 2020

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

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
Symptoms
Cause
Solution
References


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