Unable To Use Custom Formula Field In Agreement Rules

(Doc ID 1993638.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Fusion Data Quality Matching Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to use a Formula Field in Agreement Rules, the merge is not successful.


The Industry value of the two accounts is not the same and the Owners are different, so the Accounts cannot be automatically merged.

The issue can be reproduced at will with the following steps:
(1) Create two accounts:

BCL DQ 060215 #1 (London, GB)
BCL DQ 060215 #2 (Berlin, DE)

Note: The Industry value is the same, but the ‘Owner’ values are different. Owner is the newTerritoryOwner formula field. The Accounts should therefore be blocked from being merged.

(2)Enter the two Accounts into a merge request

Note: Instead of being ‘rejected’, the Duplicate Resolution Request has a status of ‘New’ meaning the Agreement rule has failed.

Note: After removing the formula field from the rule and then modifying the Industry of one of the Accounts, the agreement rule is successful in rejecting the merge request.


 Agreement Rules configuration.


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