Skip to main content
Question

Cancelling Supplier Invoice, Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

  • October 10, 2024
  • 3 replies
  • 75 views

Forum|alt.badge.img+4

Hi All, Hoping someone might be able to help

We have a Posted Supplier Invoice that we need to CANCEL, however are receiving this error:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

There were no issues raising or posting the invoice originally, and I don’t recall encounting this issue before, thus not sure how to resolve

Any help would be greatly appreciated!

Cheers :)

3 replies

Forum|alt.badge.img+11
  • Hero (Employee)
  • 75 replies
  • October 10, 2024

Hi,

Check how lengthy is the Payment Reference, Also any header details or More Information Details which is extra-ordinarily long

Thank You


Forum|alt.badge.img+7
  • Do Gooder (Employee)
  • 35 replies
  • October 10, 2024

Hello.

A customer of mine had an attachment with naming that didn’t work. When they changed the name of the attachment they could send the invoice. They had over 50 characters in the name and it worked when they changed name.

 

Best regards

Denny


Forum|alt.badge.img+4
  • Author
  • Sidekick (Customer)
  • 6 replies
  • October 10, 2024

Thank you both! I’ll keep your comments in mind for future 
Unfortunately thou, I can’t see any overly lengthy information

-Payment Reference is only 30chars long

-The longest Posting Text is 32Chars long

-There is also no attachments to the invoice (nor any attachments that have been dettached)

-There are no additional information/references 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings