While Creating Supplier Site Address Got ORA-06502: Pl/Sql: Numeric Or Value Error
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.
Pl/Sql Numeric Or Value Error
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.
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