My Oracle Support Banner

Unexpected Manual Reconciliation Filter Behaviour (Doc ID 2540847.1)

Last updated on MAY 19, 2022

Applies to:

Oracle Fusion Cash Management Cloud Service - Version and later
Information in this document applies to any platform.


The client is experiencing an issue with the Form Filters available in the "Manual Reconciliation" screen and the manner they accept information for the Amount column.

In particular, any value that has no decimal point or a single decimal value (ie. 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9) does not allow the user to type in the entire value into the criteria field to activate the filter.

For example, where a value is "2.70", then the filter will only work if the user keys in "2.7". If the user enters the entire amount ("2.70") then the filter fails to retrieve any values. See screenshots below:

Likewise, where a value has no decimal such as 22.00, the user needs to enter "22" (with no decimals in the filter) otherwise no results are returned.

This behaviour is the same for Bank Statement Lines and System Transactions.

EXPECTED behavior is that the filter and form would be matured enough to accept the complete value (ie. 22.00 or 2.70), as well as part values (22 or 2.7).


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.