MetaSolv Throws "SP_ADDRESS_UPDATE_IMPACT Failed" error for "ORA-12899: value too large for column" when Opening and Closing an End User Location Record (Doc ID 2169275.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

MetaSolv Solution version 6.2.1

Application throws "SP_ADDRESS_UPDATE_IMPACT Failed" error for "ORA-12899: value too large for column" when opening and closing an End User Location record associated to a city name greater than 25 characters that invokes the Address Change Impact window.


ERROR
-----------------------
Procedure SP_ADDRESS_UPDATE_IMPACT Failed.

PKG_ADDRESS_UPDATE_IMPACT.SP_PROCESS_DLR_UPDATE
ORA-12899: value too large for column
"ASAP"."DESIGN_LAYOUT_REPORT"."PRILOC_CITY" (actual: 27, maxim


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

1. Application Setup

2. Location and Geography Setup

3. End User Locations

4. Search for End User Loc Name = 10HAWKINDIME|53131717

5. Open the End User Location

6. Click OK and the Address Change Impact window opens

7. Click Change this Address and the "Procedure SP_ADDRESS_UPDATE_IMPACT Failed" error displays



Changes

 

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