My Oracle Support Banner

Czech Republic: Invoice Not Appearing In CLE: VAT Register(CZ) Effective From 01.01.2013 (Doc ID 2542961.1)

Last updated on SEPTEMBER 09, 2019

Applies to:

EMEA Add-on Localizations - Version 12.1.3 and later
Information in this document applies to any platform.


Reported Issue
Invoice not appearing in CLE: VAT Register(CZ) effective from 01.01.2013.

Issue details 
Initially, the issue was raised with the EMEA VAT: Selection process for a particular trx_id was not picked up by the EMEA VAT: Selection Process.
This issue was solved where Oracle Financials for EMEA suggested the below update statement to update jg_zz_vat_trx_details table by inserting the tax_invoice_Date field with the appropriate value.
After running the update statement , that invoice is appearing in the EMEA VAT Selection Process but is not picked up by the CLE: VAT Register(CZ) effective from 01.01.2013.

Sample update suggested by Oracle Financials for EMEA
UPDATE jg_zz_vat_trx_details
tax_invoice_date = :tax_invoice_date 
trx_id = :trx_id;


Expected Behavior
Expects this invoice to appear over this report "Invoice not appearing in CLE: VAT Register(CZ) effective from 01.01.2013"


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.