My Oracle Support Banner

R12: JE: JGZZVSPB: EMEA VAT: Selection Process Is Extracting Transactions in Incorrect Period (Doc ID 2907075.1)

Last updated on MARCH 15, 2023

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
--------------------
After running "EMEA VAT: Selection Process" program, observed that transactions are extracted in incorrect period in jg_zz_vat_trx_details table.

EXPECTED BEHAVIOR
--------------------
Expect to have transactions extracted in correct period by "EMEA VAT: Selection Process" program.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to AP localization responsibility.
2. Go to View > Requests > Submit a new request.
3. Run "EMEA VAT: Selection Process".
4. Run below query and observed that PERIOD_NAME column is incorrect populated.

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.