My Oracle Support Banner

VAT Reporting For Israel Template - Transaction Date Is Populated With 0 For AR Export Invoices (Doc ID 2799671.1)

Last updated on MAY 18, 2022

Applies to:

Oracle Fusion Tax Cloud Service - Version and later
Information in this document applies to any platform.


Qn1:On : version, Receivables


VAT Reporting for Israel template - transaction date is populated with 0 for AR Export Invoices


Running the VAT Reporting for Israel, the AR transactions are captured in the output file for the Reporting Code S & Y.

But for Y transactions, the transaction date is not appearing in the report it is only filed with Zeros.

How to resolve this?


If Line 1 - Export date is 6/28/21 and Line 2 - Export date is 7/28/21, the data is duplicated.

Assume if users enters the wrong date other than invoice date, there is no validation here. Is it a default behavior?

When users enter the same date for both lines 1 & 2, there is no duplication in report. For both dates the VAT amount is zero. For foreign customer zero tax is applied.

User's expectation is to have in the output for JeIlVat835Report(39) only ONE line for the invoice 12345, although they do have 2 lines for the invoice with different INVOICE_DATE (20210629 and 20210728).


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

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