Jeitappv: Error For Foreign Currency Invoices When Exchange Rate Type Is User (Doc ID 1099553.1)

Last updated on APRIL 25, 2019

Applies to:

Symptoms

On Applications 11.5.10 :
When attempting to execute JEITAPPV module: Italian Purchases VAT Register, the following error occurs when a self invoice/eu invoice in foreign currency is entered using an exchange rate type User

-- Error
MSG-01000: No of Records retreived = 100
MSG-01000: Insert into jgzz_ar_tax_global_tmp has failed



-- Steps
The issue can be reproduced at will with the following steps.
1. enter an invoice in foreign currency using an exchange rate which type is User
2. validate invoice
3. run JEITAPPV

-- Business Impact
The issue has the following business impact:
Due to this issue, users cannot produce VAT declaration

Cause

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