How To Generate Initials Of 2 Characters in EDQ (Name and Address Match process) for exact Match rule (Doc ID 2911802.1)

Last updated on DECEMBER 01, 2022

Applies to:

Goal

In Name and Address Match process (Transaction Filtering), we have a rule that applies Generate Initials transformation before execute exact match. We have a case:
Input = HOaX QUbX DUeX ---> HQD
Watchlist Record = HOnX QUcdX DAfX ---> HQD
And they are matched under the mentioned rule, which are not appropriate. So we have thought of extracting first 2 characters of each words then matching them. So that they would be HOQUDU vs. HOQUDA then NO MATCH!
Our question is How to Generate Initials of 2 characters? Or are there any other methods to solve the above problem?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.