Hi,
We have run into an error while running the transfer inventory transactions job. They have worked just fine recently so I am not sure what could be causing this. The transactions are showing as completed but will not transfer. Any direction would be greatly appreciated.
“ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512:…..”
Thanks!
That is an indication that there is data in a field that is too long for the voucher row field that it is being transferred to. Look for fields that have data in them significantly longer than you would normally expect. Order number or similar data string, not one that is a fixed code. Hopefully the error points to the transaction with the issue, else you’ll have to sift through all of the untransferred transactions to locate the one with a problem.
Thanks. That is what I had deducted as well, just hoping I didn’t have to sift through the thousands of transactions. Appreciate your feedback.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
