My Oracle Support Banner

EAR: Payment Worksheet Remains Unbalanced Even After Using The Currency Exchange Aid Functionality (Doc ID 2621325.1)

Last updated on DECEMBER 30, 2019

Applies to:

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


A Payment Worksheet remains unbalanced, and hence cannot be set to Post Action Batch Standard, when the Currency Exchange Aid feature is being used should Payment Currency, and Item Currency be different.

The Field 'Converted Payment Amount to apply' calculates the Payment's Amount into the Item's Currency, and while the Field displays up to 3 decimal positions, the calculated amount gets rounded to two decimal positions. As such, when trying to update the Field 'Amount to apply to Item' at the Currency Exchange Aid page (CURR_EXCHG_AID_SEC), the system automatically sets the Field 'New Payment Amount Remaining' to an amount still different than 0.00.


    1.- Log into the FSCM Online Application as a Receivables User
    2.- Define a new Exchange Rate between the two Currency Codes to be used (Example: 1 OSS = 25.615 USD)
    3.- Create a new Pending Item Group in Business Unit US001 for an amount of 19,120.42 OSS (Foreign Currency, which is calculated as 489,769.56 USD Base Currency)
    4.- Set the Pending Item Group to Post Action Batch Standard
    5.- Launch AR Update for Pending Items in Business Unit US001
    6.- Create a new Regular Deposit for Business Unit US001, for an amount of 483,574.54 USD, and refer the Customer ID, and Item ID previously created
    7.- Build a new Payment Worksheet for this Deposit and Payment combination, and ensure the Item ID is selected
    8.- Note that the Payment Worksheet has a Remaining Balance of -6,195.02 USD
    9.- Click on the View Detail icon of the selected Item row
    10.- Click on the Currency Exchange Aid link
    11.- Copy the amount value from Field 'Converted Payment Amount to apply' (Value should be displayed as 18,878.470 OSS)
    12.- Paste that copied value into the Field 'Amount to apply to Item'
    13.- ISSUE: Notice how the Field 'New Payment Amount Remaining' is set to -0.030 USD
    14.- Click on OK button
    15.- Click on the link to return to the Payment Worksheet Application page
    16.- ISSUE: In the Balance section, confirm that the Field Remaining is still displaying a value of -0.03 USD

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

The Payment Worksheet cannot be manually corrected, as the Item rows are based on Foreign Currency OSS, while the Balance section is on Base Currency USD. The Remaining Amount of -0.03 USD would imply a value of 0.0012 OSS (three decimal positions at least), and this cannot be manually corrected. As such, the Payment Worksheet cannot be balanced, nor the amount of the Payment applied in its entirety. Writing Off is also not an option due to the extremely small amount.

The Currency Exchange Aid feature should be able to foresee such scenarios, and in such small amounts, round up the remaining to 0.00, or allow a way to enable the User to balance the Payment Worksheet so it can be further processed.

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.