My Oracle Support Banner

DQ_RESULT_DETL_MASTER.V_SRC_PK_COLS data is not coming in the expected format post DQ execution (Doc ID 2730994.1)

Last updated on NOVEMBER 26, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.9 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7 version, Administration_OFSS

ACTUAL BEHAVIOR
---------------
After DQ execution, DQ_RESULT_DETL_MASTER.V_SRC_PK_COLS column doesn't get the value in expected format i.e in table.PK_column1, table.PK_column2 etc format


EXPECTED BEHAVIOR
-----------------------
After DQ execution, DQ_RESULT_DETL_MASTER.V_SRC_PK_COLS column should have the value in table.PK_column1, table.PK_column2 etc format

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to execute DQs and check the data format in DQ_RESULT_DETL_MASTER.V_SRC_PK_COLS

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use this table as reference in other OFSAA application for performing some operations.

Cause

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
Symptoms
Cause
Solution


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