Autoinvoice Issue: Importing Transactions Completes in Error - Unable To Locate A Valid Sales Tax Rate For Transaction

(Doc ID 1637258.1)

Last updated on OCTOBER 09, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Autoinvoice Import Program completes with the following error:

Unable to locate a valid Sales Tax Rate for transaction

Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Interfaces > AutoInvoice
Submit AutoInvoice Import

In the logfile, you will see something like this:

APP-AR-11526: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error occurred in line number=1 in transaction=10060735
Unable to locate a valid Sales Tax Rate for transaction
Error occurred in line number=1 in transaction=10060736
Unable to locate a valid Sales Tax Rate for transaction
Error occurred in line number=2 in transaction=10060736
Unable to locate a valid Sales Tax Rate for transaction

The problem was that even though this was a setup issue for the customer on one transaction, all the subsequent transactions in autoinvoice rejected with error message: Unable to locate a valid Sales Tax Rate for transaction

Changes

 A new customer was added.

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