Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

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%')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center