Oracle EBTax Important Tables

EBTAX SETUP TABLES

Following are the main E-Business tax tables that will contain the setup information that will help support in troubleshooting E-Business tax information.

a. Tax Regimes: ZX_REGIMES_B

b. Taxes: ZX_TAXES_B

c. Tax Status: ZX_STATUS_B

d. Tax Rates: ZX_RATES_B

e. Tax Jurisdictions: ZX_JURISDICTIONS_B

f. Tax Rules: ZX_RULES_B

To get a dump of the eTax setups, you can use the following set of queries.

Please provide the tax regime code when prompted. If the issue is limited to a tax then provide the tax name when prompted else please leave it blank.

SELECT *

FROM zx_regimes_b

WHERE tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_taxes_b

WHERE DECODE('&tax_name',null,'xxx',tax) = nvl('&tax_name','xxx')

AND tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_status_b

WHERE tax = '&tax_name'

AND tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_rates_b

WHERE tax = '&tax_name'

AND tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_jurisdictions_b

WHERE DECODE('&tax_name',null,'xxx',tax) = nvl('&tax_name','xxx')

AND tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_rules_b

WHERE tax = '&tax_name'

AND tax_regime_code = '&tax_regime_code';

Source: More Important Tax tables