My Oracle Support Banner

Change Currency of Copied Transaction Does Not change Exchange details in ZX Tables thus FTR shows wrong Amounts (Doc ID 2458478.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

After copying an invoice, when currency is changed at header level.
Customer modified a Foreign Invoice Currency Invoice (USD) using AR Transactions form 
He incomplete the Transaction, changes currency to SGD. This will reset Exchange rate information. 
Then he completes the Transaction . 
All the data in AR and balances in AR are correct. 

But following columns in table ZX_LINES_DET_FACTORS 
TRX_LINE_CURRENCY_CODE 
TRX_LINE_CURRENCY_CONV_RATE 
TRX_LINE_CURRENCY_CONV_DATE 
TRX_LINE_PRECISION 
TRX_LINE_CURRENCY_CONV_TYPE 

and following in ZX_LINES 
CURRENCY_CONVERSION_RATE 
TAX_CURRENCY_CONVERSION_DATE 
TAX_CURRENCY_CONVERSION_TYPE 
TAX_CURRENCY_CONVERSION_RATE 

are NOT updated with new values . 

It affects Financial Tax Register (FTR). 
Financial Tax Register shows wrong Taxable Accounted Amount and Tax Accounted Amount 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Transactions form 
2. Pick a Transaction in USD currency (Foreign )
3. Copy it.
4. Incomplete the Copied Transaction
5. Change currency to SGD Currency. (Functional currency) 
6. Save the Transaction.
7. Complete.


Major impact on Financial Tax Register Report output.

Changes

 Customer is using Third Party Tax Vendor Vertex.

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
 1. Bug Summary
 2. Fixed Files
 4. Solution Steps
References


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