Updating Customer Site Getting Error Message ORA-06502 And ORA-01403: No Data Found
Last updated on FEBRUARY 12, 2018
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
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:
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:
Navigation: Customers > Customers > Query Customer >
Go To: Address Details
Business Purposes tab > Status Inactive : Bill_to and Ship_to > Press ‘Restore’ on Bill_to
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