Autoinvoice is Failing with Tax Errors for Some Customers (Doc ID 1302122.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


Autoinvoice with Vertex Integration failing with the following error in the log file:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA -06512: at "APPS.ZX_VERTEX_TAX_SERVICE_PKG", line 3141 ORA-20199: An error occur ed while processing line item 1. ORA-06512: at "VERTEX.QSU", line 268 ORA-20000: An Oracle exception was raised in QSULICalc.QSULICalcDoCalcProc ORA-06512: at " VERTEX.QSUUTIL", line 1672 ORA-06512: at "VERTEX.QSULICALC", line 3730 ORA-01403 : no data found

Steps to Reproduce:

  1. Responsibility: Receivables Manager
    Navigation
    : Transactions >Transactions
  2. Query for an existing Credit Memo
  3. Invoke form menu Actions >Applications
  4. Navigate to the Apply To field and click on the list of values icon
    The list takes a long time to be returned

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms