My Oracle Support Banner

EEX 9.2: Line Expense Amount In Base Currency (PS_EX_SHEET_LINE.MONETARY_AMOUNT) Incorrectly Calculated For Credit Card My Wallet Items Using Receipt Split In Fluid User Interface (Doc ID 2517292.1)

Last updated on JANUARY 06, 2020

Applies to:

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

Symptoms

ISSUE:

It has been detected that when Receipt Split is being used against MasterCard CDF3 My Wallet transactions defaulted into an Expense Report both in Fluid User Interface, or Classic Home Online, the calculated Expense Amount in Base Currency are no longer correct.

This is a problem when the Transaction Currency used in the original expense is stronger than the Base Currency of the Expenses Business Unit of the Employee.

The Currency Quotation Method is also configured to be Indirect.

REPLICATION STEPS:

    1.- Upload into the FSCM 9.2 environment a MasterCard flat file containing Credit Card transactions in Foreign Currency (stronger than Base Currency)
    2.- Check in My Wallet that a sample Expense is properly loaded: For instance, one Hotel charge for 2,664.00 GBP, with Exchange Rate of 0.741025, translated to a Base Amount of 3,595.02 USD
    3.- Go to Fluid Expenses, and create a new Expense Report
    4.- Default from My Wallet the Hotel Expense of 2,664.00 GBP
    5.- Perform a Receipt Split into two rows for the below assigned amounts:
              - Expense Line 1: 2,000.00 GBP (which would translate to 2,698.96 USD)
              - Expense Line 2: 664.00 GBP (which would translate to 896.06 USD)
    6.- Confirm that all is balanced, and click on DONE
    7.- Confirm how the Base Amounts in USD no longer combine to the original value of 3,595.02 USD, but instead, sum a total of 1,974.09 USD (1,482.05 USD  + 492.04 USD)

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

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 demo environment).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.



ACTUAL RESULTS:

The values within Record Field PS_EX_SHEET_LINE.MONETARY_AMOUNT of the MasterCard CDF3 format transaction gone through Receipt Split become incorrect, bringing the Base Currency Amount to a lower figure that what it should be, resulting in underpayment to the Employee/Credit Card Vendor.

EXPECTED BEHAVIOR:

The sum of all Record Field PS_EX_SHEET_LINE.MONETARY_AMOUNT values of the combined Expense Lines resulting from the Receipt Split should equal the original Monetary Amount of the MasterCard transaction before Receipt Split took place.

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
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.