My Oracle Support Banner

R12: ZX: Unable To Select Offset Tax Rate In Tax Lines Summary Window Of The Invoice Workbench, List Of Values Raises Error FRM-41830 (Doc ID 2577433.1)

Last updated on AUGUST 27, 2019

Applies to:

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

Symptoms

Unable To Select Offset Tax Rate In Tax Lines Summary Window Of The Invoice Workbench, List Of Values Raises Error FRM-41830.

Unable to calculate tax on Invoice.

Offset tax not calculated.

When try to select a Rate Name in the Invoice Workbench "Tax Lines Summary" window, the form raise the following error:

FRM-41830 : List of values contains no entries

Customer setup shows their Tax Status "Allow Tax Rate Override" option is Not enabled.  Column ZX_STATUS_B.allow_rate_override_flag = 'N'.

eBTax Setup Diagnostic shows the following data:

 

Tax Regime
TAX_REGIME_CODE EFFECTIVE_FROM EFFECTIVE_TO TAX_CURRENCY_CODE
QATAR_VAT 01-May-2017   QAR

 

Tax
TAX_REGIME_CODE TAX EFFECTIVE_FROM EFFECTIVE_TO TAX_TYPE_CODE ALLOW_MANUAL_ENTRY_FLAG ALLOW_TAX_OVERRIDE_FLAG
QATAR_VAT QATAR_VAT_OFFSET 01-May-2017   VAT N N

 

Tax Status (Table ZX_STATUS_B)
TAX_REGIME_CODE TAX TAX_STATUS_CODE EFFECTIVE_FROM EFFECTIVE_TO ALLOW_RATE_OVERRIDE_FLAG
QATAR_VAT QATAR_VAT_OFFSET QATAR_OFFSET 01-May-2017   N

 

 

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
References


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