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.

Symptoms

On : 12.1.3 version, EMEA VAT reporting

ACTUAL BEHAVIOR
---------------
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 BEHAVIOR
-----------------------
Expected to see both taxes for both invoices.

STEPS
-----------------------
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

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

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