R12:JG: (JGZZVATSP) EMEA VAT Selection Delets Invoice Records from Previous Month when Executed for Current Month (Doc ID 2158903.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Financials Common Country - Version 12 and later
Information in this document applies to any platform.

Symptoms

There are invoices with tax lines which fall in different accounting periods - for example T-1 and T.

If EMEA VAT Selection process is executed for T-1 period, tax lines belonging to this period are correctly fetched. Subsequently, if EMEA VAT Selection process is executed for T period, tax lines belonging to T period are correctly selected, but the records previously fetched for T-1 period are deleted. This behavior can be seen by analyzing the output of table jg_zz_vat_trx_details after each process execution.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms