Data Quality Management Error: Running 'DQM Compile All Rules' Raises Unexpected Error (Doc ID 746700.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12.0.5 and later
Information in this document applies to any platform.
This problem can occur on any platform.
ARHDQCMAL module: DQM Compile All Rules

Symptoms

On 12.0.5 in Production, DQM Compile All Rules (ARHDQCMAL) fails with the following error in the log file:

+---------------------------------------------------------------------------+
Compiling Match Rule BULK MATCH: IDENTICAL PERSONS ...
Error Compiling Rule :
Unexpected error encountered when compiling PL/SQL program unit:
HZ_MATCH_RULE_51.
Error: Compilation Errors
Please contact the system administrator.

Compiling Match Rule HZ_ORG_ADV_SEARCH_RULE ... Done
Compiling Match Rule HZ_ORG_SIMPLE_SEARCH_RULE ... Done
Compiling Match Rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE ... Done
Compiling Match Rule CREDIT MANAGEMENT SEARCH ... Done
Compiling Match Rule BULK MATCH: IDENTICAL ORGANIZATIONS ... Done
Compiling Match Rule HZ_PERSON_SIMPLE_SEARCH_RULE ... Done
Compiling Match Rule BPMO BUSCA ORGANIZACION DUP ... Done
Compiling Match Rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE ... Done
Compiling Match Rule HZ_CONTACT_SIMPLE_SEARCH_RULE ...
Error Compiling Rule :
Unexpected error encountered when compiling PL/SQL program unit:
HZ_MATCH_RULE_98.
Error: Compilation Errors
Please contact the system administrator
+---------------------------------------------------------------------------+


Steps To Reproduce:

Responsibility: Trading Community Manager
Navigation: Control > Requests > Run

Select concurrent program 'DQM Compile All Rules' from the list of values
Submit.

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