EAR 9.2: Regular Deposit Manually Entered Exchange Rate Value Not Being Used in Payment Worksheet and Currency Exchange Aid Pages (Doc ID 2895354.1)

Last updated on FEBRUARY 15, 2024

Applies to:

Symptoms

The Payment Worksheet component, at the Currency Exchange Aid page (CURR_EXCHG_AID_SEC), is using the system's defined Market Rate value as the default to convert the Payment's Amount to Base Currency of the Business Unit, instead of using the manually entered Exchange Rate defined by the Employee when creating the Regular Deposit. As a result, the value calculated in Field 'Converted Payment Amount to apply' seems incorrect.

REPLICATION STEPS:

     1.- Log into the FSCM Online Application as a Receivables User
     2.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Market Rates > Market Rates
     3.- Open the currently defined configuration between USD and CAD under Rate Type CRRNT
     4.- Add a new Effective Date row, with a value of 01/01/2022, and enter a Rate of 1.50 CAD per every 1.00 USD
     5.- Navigate to: Customers > Customer Information > Create Customer Information
     6.- Open existing Customer ID CAN01, and at the General Info tab, define Currency Code CAD, and Rate Type CRRNT
     7.- Navigate to: Accounts Receivable > Pending Items > Online Items > Online Item Group Entry
     8.- Create a new Pending Item Group with one Item under Business Unit CAN01, for Customer ID CAN01, and Amount of 25,000.00 CAD with an Accounting Date of 03/10/2022
     9.- Go to the Actions tab, and set the Pending Item Group to a Post Action of Batch Standard
     10.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
     11.- Create a new Run Control ID under Business Unit CAN01, and selecting the option of 'Pending Items'
     12.- Launch the AR Update process (AR_UPDATE AE Program) to completion
     13.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
     14.- Create a new Regular Deposit under Business Unit CAN01, for a Control Currency of USD, and manually override the defaulted 1.50 Exchange Rate to a value of 1.20 instead
     15.- At the Payments tab, define a new Payment ID, the Amount of 10,000.00 USD, an Accounting Date of 03/10/2022, ensure that the Exchange Rate is 1.20 CAD per 1.00 USD, and then add the Item ID value in the Reference Information section
     16.- Navigate to: Accounts Receivable > Payments > Apply Payments > Apply Payments Worksheet
     17.- Select the Deposit Business Unit CAN01, the Deposit ID created, as well as the Payment ID just defined, and build a new Worksheet
     18.- Confirm that at the Payment Worksheet Application page, the Item previously created has been automatically selected, and an Entry Type of PY (payment)
     19.- ISSUE #1: Check the Balance section, and see that the Selected Amount is using the Exchange Rate of the system, at 1.50
     20.- Click on the View Detail icon of the selected Item's row
     21.- At the Worksheet Application Detail View, click on the 'Currency Exchange Aid' link
     22.- ISSUE #2: The field 'Converted Payment Amount to apply' displays an amount that has used the Exchange Rate of the system once again, 1.50, instead of the manually entered Exchange Rate of the Regular Deposit (1.20)

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

Receivables Users are confused, as the manually entered Exchange Rate seems to not be defaulted at the Payment Worksheet level, having the system's Market Rate calculate unexpected Payment Amounts, and making the balancing of the Payment Worksheet difficult.

The system should be using the manually entered Exchange Rate at the Regular Deposit when using the Currency Exchange Aid feature.

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.