Updating Customer Site Getting Error Message ORA-06502 And ORA-01403: No Data Found (Doc ID 1910751.1)

Last updated on JULY 30, 2014

Applies to:

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

Symptoms

On : 12.1.3 version, Customers Module

After upgrading from 11i to Rel 12, you are attempting to reactivate an inactive location, under the Business Purposes, by selecting the restore button and receive the following error:

ERROR
-----------------------
The following SQL error occurred: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-01403: no data found.


Steps to Reproduce:
Responsibility:  Receivables
Navigation: Customers > Customers > Query Customer >
Go To:  Address Details
Business Purposes tab > Status Inactive : Bill_to and Ship_to > Press ‘Restore’ on Bill_to

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