My Oracle Support Banner

Task28 - DGS DQ CTL Batch - records rejected due to DQ-PK columns incorrect format (Doc ID 2743815.1)

Last updated on JUNE 23, 2021

Applies to:

Oracle Financial Services Data Governance for US Regulatory Reporting - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

DGS 80910

DGS DQ CTL batch

As part of the batch the table' fsi_dgs_dq_err_val_map' was loaded only with few records and based on the log table FSI_DGS_ERROR_LOG the records were rejected for various reasons during the insert into FSI_DGS_DQ_ACCNT_MAP.

error reported in FSI_DGS_ERROR_LOG:  "DQ mapper insertion failed Error :-ORA-00918: column ambiguously defined"

The details SQL in error log table including incorrect join as shown below

INNER JOIN STG_LOAN_CONTRACTS
ON V_ACCOUNT_NUMBER = MST.V_SRC_PK_1 AND V_GAAP_CODE = MST.V_SRC_PK_2 AND FIC_MIS_DATE = MST.V_SRC_PK_3 AND N_LOAD_RUN_ID = MST.V_SRC_PK_4 AND V_DATA_ORIGIN = MST.V_SRC_PK_5

 

INNER JOIN STG_LOAN_CONTRACTS
ON LEFT OUTER JOIN DIM_ACCOUNT
ON DIM_ACCOUNT.V_ACCOUNT_NUMBER = STG_LOAN_CONTRACTS.V_ACCOUNT_NUMBER

 

INNER JOIN STG_LOAN_CONTRACTS
ON = MST.V_SRC_PK_1 LEFT OUTER JOIN DIM_ACCOUNT
ON DIM_ACCOUNT.V_ACCOUNT_NUMBER = STG_LOAN_CONTRACTS.V_ACCOUNT_NUMBER

Changes

 NA

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
Changes
Cause
Solution
References


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