My Oracle Support Banner

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:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


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.

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.

NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.




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

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