EEX9.2: Monetary Amount Associated with AMEX Card Transaction in Foreign Currency Gets Recalculated (Doc ID 2726500.1)

Last updated on NOVEMBER 15, 2020

Applies to:

Symptoms

Monetary Amount associated with AMEX card transaction in foreign currency gets recalculated, while it should remain the same as it was before the split.
When the AMEX foreign currency transaction is loaded into my wallet and an expense report is created from the wallet entry, upon splitting the receipt and saving the report. When going out of the page and going back in again, the amount gets recalculated on the page. Then when saving or submitting the report, the new sum of monetary amount gets saved in the EX_SHEET_LINE table but the EX_TRANS' monetary amount remains the same. The amount difference is off by a few cents.

REPLICATION STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new hotel/lodging my wallet expense entry.
2. Create a new expense report. Add a Hotel/Lodging transaction from Wallet transaction created in step 1. Note monetary currency is the same as in EX_TRANS table.
3. Utilize the ‘Itemize Hotel Bill’ to itemize the Lodging charge added to expense report (at least add two more lines)
4. Note that the monetary amount is recalculated and doesn't match to the monetary amount in EX_TRANS table.

For the replication file, please review REPLICATION_FILE.

Changes

Cause

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