My Oracle Support Banner

TAXWARE: HQ_ESTB_REG_NUMBER IS NULL WHEN TAX REG IS DEFINED FOR A JURISDICTION (Doc ID 2359773.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Tax Calculation

ACTUAL BEHAVIOR
---------------
HQ_ESTB_REG_NUMBER is not getting populated for EMEA VAT Reporting

While running the Spain localization reports, it was noticed the HQ_ESTB_REG_NUMBER is populated in transactions only for the first line where tax regime ESP REGIME is applied, but for the second line for which the tax regime ES VAT is used, the HQ_ESTB_REG_NUMBER is null.
For the first line the Ebtax engine is used for tax calculation, but for the second line the third partner Taxware is applied.

As workaround, the HQ_ESTB_REG_NUMBER field may be populated with patch 19916280:R12.ZX.B.

EXPECTED BEHAVIOR
-----------------------
Transactions should have the HQ_ESTB_REG_NUMBER populated for both tax regimes in ZX_LINES table.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Receivables Manager
2. Navigation: Transactions > Transactions
3. Create a new transaction and observed the HQ_ESTB_REG_NUMBER and TAX_JURISDICTION_ID fields are populated only for the first line in ZX_LINES tables for TAX_REGIME ESP REGIME (for tax regime ES VAT they are null)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the tax reports are incomplete and cannot be provided to tax authorities.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.