My Oracle Support Banner

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 8.0.7.1.0 and later
Information in this document applies to any platform.

Goal

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:-

  1. Perform the object Migration (Follow Infra User guide Section 13.5)
  2. Navigate to Data Quality Rules 
  3. Click on Data Quality Definition (View Mode)
  4. Check the query under the Custom Check/Business Check 

 

 Note: Please go through the attached screen shots ( DQ_MIGRATION.docx) for reference.
 

Solution

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
Goal
Solution


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