My Oracle Support Banner

Jgzzvatsp: EMEA VAT Selection Process Selects An Ap/Ar Invoice Only Once When Run For Two Regimes (Doc ID 739857.1)

Last updated on MARCH 19, 2019

Applies to:

Oracle Financials for EMEA - Version 12.0.5 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Report: EMEA VAT: Selection Process - JGZZVATSP

Program 'EMEA VAT: Selection Process' does not insert data in JG_ZZ_VAT_TRX_DETAILS for a given invoice/transaction when run it for a SECOND REGIME if the invoice/transaction has two tax lines
with two different regimes. This implies that anry report based on it, will extract only data for the first tax line of the invoice/transaction and NOT for the second tax line getting a different regime on it.

-- Steps To Reproduce:
1- Create an invoice in AP or a transaction in AR
2- e-Business Tax calculates and generates two tax lines with two different regimes.
    TWO ITEM lines => TWO TAX lines => TWO different regimes
3- Validate the invoice or complete the transaction
4- Account for the invoice or account for the transaction
5- Run the 'EMEA VAT: Selection Process' for the first regimes of the first tax line
==> The system inserts a record in table JG_ZZ_VAT_TRX_DETAILS for this tax line
6- Run the 'EMEA VAT: Selection Process' for the second regimes of the second tax line
=====> ISSUE : The system does NOT insert row in JG_ZZ_VAT_TRX_DETAILS table for the second tax line

-- Business Impact:
Any statutory report based on EMEA VAT selection process will be wrong


Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.