Error "ORA-20001: APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small occurred in AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval<-APXAPRVL" When Trying to Validate Payables Invoice. (Doc ID 2921467.1)

Last updated on FEBRUARY 02, 2023

Applies to:

Symptoms

PROBLEM STATEMENT

-----------------------

Not able to validate standard payables invoice.
When trying to validate invoice, system is throwing below error message.

ERROR
-----------------------
ORA-20001: APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small occurred in
AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval<-APXAPRVL

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Payables Responsibility
2. Invoices-> Entry-> invoices, enter a new payables invoice.
3. Click on Tools-> TDS Tax Details, apply TDS and try to validate invoice.

Changes

Cause

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