FDMEE Bug mapping ?
Hi everyone ,
I am using HFM 11.1.2.3.503 and FDMEE 11.1.2.3
I have 2 conditional mappings ICP.
No | Source | Target | Conditional
1 00000* #SQL Case WHEN ICP LIKE '00000%' AND ACCOUNT LIKE '1122101%' THEN 'E0100' END
2 00000* #SQL Case WHEN ICP LIKE '00000%' AND ACCOUNT LIKE '1122102%' THEN 'E0200' END
When after import and Validate the Inconsistent happened.
From LOGS.
No 1.
UPDATE TDATASEG_T
SET ICPX = Case WHEN ICP LIKE '00000%' AND ACCOUNT LIKE '1122101%' THEN 'E0100' END
,ICPR = 800545
,ICPF = 3
WHERE LOADID = 3188
AND PARTITIONKEY = 84
AND CATKEY = 1
AND (ICPX IS NULL OR ICPX = '')
AND (ICP LIKE '00000%')