Skip to main content
Question

Error when trying to print Customer Invoice

  • February 28, 2023
  • 1 reply
  • 164 views

Forum|alt.badge.img+5

Apps 10

Customer Invoice stuck in Printed status

Customer Invoice Posting Analysis details:

ORA-20105: Invoice.ACCERROR1: Error (numeric or value error: character string buffer too small
ORA-06512: at "PRIN1APP.GET_BLOCKED_ORDERS", line 6
ORA-06512: at "PRIN1APP.LEDGER_ITEM_I_EVI", line 1
ORA-04088: error during execution of trigger 'PRIN1APP.LEDGER_ITEM_I_EVI') occurred while booking Invoice CD 219736.

1 reply

Forum|alt.badge.img+28
  • Superhero (Customer)
  • February 28, 2023

It means that one of the values in one of the fields that is being transferred to the invoice (from the order) is over-running the size of the field.  It can be tricky to locate which one.  Eliminate the custom fields first if there are any, then look at the text fields - especially customer name or any fields that might have been copied or imported when making the customer order rather than typed in manually.

 

It is a field level data error, just not a straightforward one.