My Oracle Support Banner

JGZZARVR and JGZZAPVR: 'No Data Found' Because JGZZVATSP Never Catch Lines (Doc ID 843788.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Financials Common Country - Version 12.0.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.
REPORT:JGZZARVR.RDF - ECE Receivables VAT Register
REPORT:JGZZAPVR.RDF - ECE Payables VAT Register
REPORT:JGZZVATSP - EMEA VAT Selection process

Symptoms

Find that both ECE Payables VAT Register and ECE Receivables VAT Register are showing 'no data
found'.

EXPECTED BEHAVIOR
Expects to see data on those two ECE reports outputs.
Note that the Run the EMEA VAT Selection process, the output report shows 'Record successfully
inserted = 0'

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Define a VAT Reporting entity with 'Tax Invoice Date' selected in the VAT Date region
2. Define Tax rates with Tax Reporting Type Code: 'EMEA_VAT_REPORTING_TYPE' and reporting code = 'VAT'
3. Enter an AP invoice with field: 'Internal Recording date' filed in for March 2009 (for example)
4. Approve, account and post the invoice in GL
5. Run the EMEA VAT Selection process with following parameters:

Reporting LEvel: Legal Entity
LEdger: Ledger ....
Balancing Segment: ...
Tax Registration Number: ....
Period Name: March 2009 (for example)
Source: ALL
Accounting Status: Both Accounted and Unaccounted
Entity Identifier: ....
Debug Flag: Yes

The output report shows 'Record successfully inserted = 0' somewhere at the end of the report
(see attachment).

When running the ECE Payables VAT Register, the outcome shows 'No data found'.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.