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:

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

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