My Oracle Support Banner

R12: AP: Invoice Validation Ends In Error ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small (Doc ID 2118117.1)

Last updated on JANUARY 26, 2024

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms



Invoice Validation errors with:

 

APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error:
Character string buffer too small occurred in
Gen_dists_from_registration<-
Ap_approval_pkg.execute_dist_generation_check<-ap_generate_distributions_pkg.generate_dists_for_line <-line_sume_control_button2.distributions with parameters (invoice_id 2833077, invoice line number = 1, registration Api = , registration view = AP_EXP_REPORT_DISTS)
While performing the following operation: &DEBUG_INFO

 Steps to reproduce

  1. Navigate in Payables to Other > Requests > Run
  2. Run Invoice Validation
  3. Review log file and see error

 

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.