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
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