ORA-06502: PL/SQL: Numeric Or Value Error When Querying Specific Customers in iReceivables
(Doc ID 2956796.1)
Last updated on JUNE 21, 2023
Oracle iReceivables - Version 12.1.3 to 12.2.12 [Release 12.1 to 12.2]
Information in this document applies to any platform.
When querying specific customers in iReceivables, the following error occurs:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The error doesn't occur on all customers.
Steps to Reproduce:
Responsibility: iReceivables 2.0 Internal
Navigation: Customer Search
- Query a specific customer by name or customer number and get the error.
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.