My Oracle Support Banner

Correction On Field Validation Behaviour For A Currency Field (Doc ID 2638507.1)

Last updated on APRIL 13, 2021

Applies to:

Oracle CRM On Demand - Version 031CS to 031CS [Release 31]
Information in this document applies to any platform.


There is set up a Field Validation for the currency field "Amount" in the Transaction object (CO7) that is working ok, except the moment when there are decimals for the "Amount" value.

For example, if entered the value $555.34 in the "Amount" value the field validation is triggered incorrectly.

The field validation should warn if the Transaction Tyype is" Debit", the "Amount" should be a negative value.
It does that ok.
The field validation formula used was taken from Oracle documentation and it is:
<= IIF(FieldValue('{Type}')=LookupValue("OCC_DYN_LOV:CustomObject7/Type/0-R9NH", "Debit"), 0, [{Indexed Currency 0}])

However, the issue is when the Transaction type is "Credit" and the "Amount" is a positive value with decimals like $234.12 for example, it is incorrectly triggered and it shows the warning when it should not do that !!!


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.