My Oracle Support Banner

R12 - Creating Supplier for Country Canada Errors With 'ORA-06502: PL/SQL: numeric or value error' (Doc ID 1308745.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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


The following error is received when creating a supplier in Suppliers form:

ORA-20001: APP-SQLAP-10000 ORA-6502: PL/SQL: numeric or value error

The error only occurs for Canadian suppliers.

Users can successfully update the address for other country like: US, GreatBritian, etc. etc.

Responsibility: Payables Manager
Navigation:  Suppliers > Entry > Query for any supplier
Go to address menu
Create address
Select country as Canada
Enter required fields and Save




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.