R12 Autoinvoice Error: This Tax Rate Is Not Active (Doc ID 745340.1)

Last updated on APRIL 28, 2017

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1 [Release 12.0 to 12.1]
Oracle Payables - Version 12.0.0 and later
Oracle E-Business Tax - Version 12.0 to 12.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:RAXTRX - Autoinvoice Import Program


Symptoms

Problem Statement:
Autoinvoice rejects records with error messages

1) This Tax Rate is not active
2) This Tax Rate is not valid on the transaction date.

Steps To Reproduce:
End date a tax rate and create a new tax rate for the tax rate code.  Run autoinvoice and open View Output for Autoinvoice Import Program.


Changes

Any one-off that includes the file zxapdefvalpkgb.pls 120.73.12000000.15 or lower could trigger the error.  Error requires more than one record to exist in the table zx_rates_b with the same name.  This can happen if a tax rate is end dated and a new rate defined.

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