My Oracle Support Banner

R11i/R12:AP: Invoice Approval Workflow Concurrent Request Error: "ORA-20001 : SUPPLIER_INVOICE_DISTRIBUTION_DESCRIPTION: ORA-06502: PL/SQL : numerical error or error on a value: buffer for character string is too small" if Attribute Value > 100 Chars (Doc ID 564695.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Payables - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
APXINWKB.FMB(INVOICE WORKBENCH)

Symptoms

When attempting to run Invoice approval workflow concurrent request the following error occurs:

ORA-20001 : SUPPLIER_INVOICE_DISTRIBUTION_DESCRIPTION: ORA-06502: PL/SQL :  numerical error or error on a value: buffer for character string is too small

This problem occurs on any invoice with an attribute value (e.g. SUPPLIER_INVOICE_DISTRIBUTION_DESCRIPTION) > 100 chars

 

 

 

Cause

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
Symptoms
Cause
Solution
References


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