4C JG_ZZ_VAT_TRX_DETAILS Just Contain One Line Belonging To The Non-recoverable Amount Equaling Zero

(Doc ID 2093375.1)

Last updated on MAY 11, 2017

Applies to:

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


On : 12.1.3 version, EMEA VAT reporting

After running EMEA VAT Selection Process, the table JG_ZZ_VAT_TRX_DETAILS just contains one line belonging to the non-recoverable amount equaling zero for the prepayment invoice , while both the prepayment invoice and the standard invoice have recoverable tax (positive amount) and also non-recoverable tax (of 0 amount)

Expected to see both taxes for both invoices.

The issue can be reproduced at will with the following steps:
1. Create Prepayment invoice + validate, accounting
2. Create Standard Invoice + validate, accounting
3. Run EMEA VAT Selection Process

The issue has the following business impact:
Due to this issue, users have incorrect results.


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