My Oracle Support Banner

The System Could Not Determine the Applicable Tax Rate for Tax XX and Tax Status XX (Doc ID 2823597.1)

Last updated on MAY 20, 2024

Applies to:

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

Symptoms

On : 12.1.3 version, Transactions Related

When running the Auto invoice program the program fails with the error message below:

ZX_TCM_TAX_RATE_PKG.get_tax_rate(+)

p_tax = XX

p_tax_status_code = XX

p_tax_regime_code = XX

p_tax_jurisdiction_code = XX --> this is the portion to get our attention

p_tax_date = XX -> and confirm the date is active

ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(+)

p_multiple_jurisdictions_flag: N

ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(+)

ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-)

ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(+)

ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-)

No rate found for tax rate code: XX

ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)

Incorrect return_status after calling ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt

ERROR
The system could not determine the applicable Tax Rate for Tax XXX and Tax Status XXX. Please contact your Tax Administrator to ensure that either a default Tax Rate Code that is effective on &DATE is specified for this Tax Status or appropriate Rate Determination Rules are defined. (TAX_DET_DATE=12-NOV-21)


STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility: Receivables Manager
2. Navigation: Menu > View > Requests > Submit a New Request... > Single Request
3. Select from LOV > Autoinvoice program
4. Provide the parameters > [B] Submit

Changes

 

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
Changes
Cause
Solution


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