Sorting Of Balances In Account Reconciliation Manager (ARM) Gives Incorrect Results When Multiple Currencies Are Represented In The Column (Doc ID 2170800.1)

Last updated on AUGUST 16, 2016

Applies to:

Hyperion Financial Close Management - Version 11.1.2.4.103 and later
Information in this document applies to any platform.

Symptoms

In ARM, you have several reconciliations displayed in your Reconciliation List view. Multiple currencies are represented by the various recs. You wish to sort the list by one of the balance columns (e.g., Source System Balance or Unexplained Difference), but the results are not as expected.

For example, let's say the List contains four recs/rows, and the following values appear in the column to be sorted:

588.12 USD
110,641.82 GBP
1,779.05 CAD
42,383.71 EUR

You'd like to sort these in ascending numeric order, such that the order would be as follows:

588.12 USD
1,779.05 CAD
42,383.71 EUR
110,641.82 GBP

Instead, the sort yields this order:

1,779.05 CAD
110,641.82 GBP
42,383.71 EUR
588.12 USD

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms