While Creating Supplier Site Address Got ORA-06502: Pl/Sql: Numeric Or Value Error (Doc ID 846200.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Payables - Version: 12.0.6 to 12.1.2 - Release: 12.0 to 12.0
Information in this document applies to any platform.
Supplier Address
ORA-06502
Pl/Sql Numeric Or Value Error

Symptoms

Problem Statement:
When attempting to create the address (supplier site) for a supplier in Release 12, page returns the following error message:

The following SQL error occurred: ORA-06502: PL/SQL: numeric or value error.
Record could not be saved.

This happening only for a given country i.e., Canada.

Steps To Reproduce:
1. Query for any supplier
2. Go to address menu
3. Create address,
4. Select country as Canada,
5. Enter required files and save the page.

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