Offline Migration- Query formation is not proper after migrating the Custom check or Business Check DQ's
(Doc ID 2670216.1)
Last updated on MAY 10, 2021
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Offline migration removes spaces between keywords for the Business check or Custom check DQ's.
select PK_NAMES,PK_1,PK_2,PK_3,PK_4,PK_5,PK_6,PK_7,PK_8,ERROR_COLUMN from (SELECT 'TOTAL_RECORD_COUNT' PK_NAMES, STG_PARTY_ADDRESS_MAP.FIC_MIS_DATE PK_1, 'EPH' PK_2, NULL PK_3, NULL PK_4, NULL PK_5, NULL PK_6, NULL PK_7, COUNT(*) PK_8, CASE WHEN ( COUNT(*) = 0 ) THEN 1 ELSE 0 END ERROR_COLUMNFROM FSDFATM.STG_PARTY_ADDRESS_MAPWHERE STG_PARTY_ADDRESS_MAP.FIC_MIS_DATE = $MISDATEGROUP BY
Note that there is no space between MAP and WHERE in the above query
This issue can be reproduced with following steps:-
- Perform the object Migration (Follow Infra User guide Section 13.5)
- Navigate to Data Quality Rules
- Click on Data Quality Definition (View Mode)
- Check the query under the Custom Check/Business Check
Note: Please go through the attached screen shots ( DQ_MIGRATION.docx) for reference.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document