My Oracle Support Banner

13501512: Spanish Inter-Eu Vat Invoices Journal Report Invoices From Oct-11 Sweeped To Nov-11 (Doc ID 1421009.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Financials for EMEA - Version 12.1.1 and later
Information in this document applies to any platform.
Report:JEESRVAR.RDF - Spanish Inter-EU Invoices Journal Report


Symptoms

Spanish Inter-EU VAT Invoices Journal Report (JEESRVAR)  output shows AP transactions from OCT-11 in NOV-11 report execution.

EXPECTED BEHAVIOR
-----------------------
AP transactions from OCT-11 intended to be displayed by report are now displayed in NOV-11 report execution.
The OCT-11 period wasn't finalized' yet. It's possible to run the EMEA VAT Selection process for OCT-11 too yet and it catch data from OCT-11 period.
Creating a new fresh invoice for OCT-11 it comes in the Spanish Inter-EU VAT Invoices Journal Report for OCT-11 indeed.
Note: there are no missing invoices.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the EMEA VAT Selection process for OCT-11 - it catch invoices
2. Run the Spanish Inter-EU VAT Invoices Journal Report for OCT-11 - output is empty
3. Run the EMEA VAT Selection process for NOV-11 - it catch invoices
4. Run the Spanish Inter-EU VAT Invoices Journal Report for NOV-11 - output shows OCT-11 and NOV-11 lines
5. AP transactions from OCT-11 intended to be displayed by report (and actually displayed in previous executions) are now displayed in NOV-11 report execution.
6. Made a new invoice for OCT-11 now and retested this issue. It is shown in the OCT-11 report execution output as expected .

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


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