DQM API HZ_PARTY_SEARCH.find_parties Ignores Special Characters eg. comma(,) space (Doc ID 2063861.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Data Quality Management

ACTUAL BEHAVIOR
-----------------------
DQM API Hz_Party_Search.find_parties not working as expected.

Using 'EXACT STRING' transformation for Party Name, but It still returns the match ignoring special characters (comma(,) space).

Example: Passing the below party name
              JACKIE VISUAL INNOVATIONS, INC.
              DQM API returns the below party name in the first match:
              JACKIE VISUAL INNOVATIONS INC

EXPECTED BEHAVIOR
-----------------------------
DQM API Hz_Party_Search.find_parties only returns match as
          JACKIE VISUAL INNOVATIONS, INC.

'JACKIE VISUAL INNOVATIONS INC' should not return as a match when using Exact Strings transformation to search 'JACKIE VISUAL INNOVATIONS, INC.'


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