R12, Ebtax: Not All Records From TaxWare TMD2 File Are Loaded Into Oracle eBTax (Doc ID 1570311.1)

Last updated on NOVEMBER 23, 2015

Applies to:

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

Goal

When importing the data from Taxware (TMD2), not all the records were imported correctly.
This is resulting in null Tax Jurisdictions after tax calculation via TWE (Taware).

Example:

TMD2 file contains records for one  county.

These records populated in the zx_data_upload_interface tables.
After the load process finishes, they do not exist in the zx_jurisdictions.
However, there is a reference for a that tax jurisdiction code  in the zx.zx_rates_b table - But the record does not exist.

This cause a NULL jurisdiction value on the tax calculation.
 

Solution

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