My Oracle Support Banner

SCD Fails with Error ORA-04063 View STG_BORROWINGS_V Has Errors (Doc ID 2570163.1)

Last updated on DECEMBER 29, 2020

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.7 and later
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When running SCD with map_ref_num = 190, the following error occurred.

Error

[INFO][BACKEND][OFSAA][SCDCPP] ClsUObjectMap : Merge Query for SCD processing is : 
MERGE INTO DIM_ACCOUNT USING (SELECT DECODE(S.SCD_ROW_TYPE_ID,1,NULL,M.ROW_ID) ROW_ID,M.FIC_MIS_DATE,
M.V_ACCOUNT_NUMBER, M.V_ORIGINAL_ACCOUNT_NUMBER, M.V_PRODUCT_PROCESSOR_NAME ,M.SCD_ROW_TYPE_ID
FROM (SELECT DIM_ACCOUNT.ROWID ROW_ID,STG_BORROWINGS_V.FIC_MIS_DATE, STG_BORROWINGS_V.V_ACCOUNT_NUMBER,
STG_BORROWINGS_V.V_ORIGINAL_ACCOUNT_NUMBER,STG_BORROWINGS_V.V_PRODUCT_PROCESSOR_NAME,
CASE WHEN (DIM_ACCOUNT.ROWID IS NULL) THEN 1
WHEN (COALESCE(DIM_ACCOUNT.V_ORIGINAL_ACCOUNT_NUMBER,'*') != COALESCE(STG_BORROWINGS_V.V_ORIGINAL_ACCOUNT_NUMBER,'*')
OR COALESCE(DIM_ACCOUNT.V_PRODUCT_PROCESSOR_NAME,'*') != COALESCE(STG_BORROWINGS_V.V_PRODUCT_PROCESSOR_NAME,'*') )
THEN 3 END AS SCD_ROW_TYPE_ID
FROM STG_BORROWINGS_V LEFT JOIN DIM_ACCOUNT
ON (DIM_ACCOUNT.V_ACCOUNT_NUMBER = STG_BORROWINGS_V.V_ACCOUNT_NUMBER
AND DIM_ACCOUNT.F_LATEST_RECORD_INDICATOR = 'Y')
WHERE STG_BORROWINGS_V.FIC_MIS_DATE = TO_DATE('20180330','YYYYMMDD') )M
JOIN (SELECT 1 AS SCD_ROW_TYPE_ID FROM DUAL UNION ALL SELECT 2 AS SCD_ROW_TYPE_ID FROM DUAL UNION ALL SELECT 3
AS SCD_ROW_TYPE_ID FROM DUAL) S
ON(S.SCD_ROW_TYPE_ID=M.SCD_ROW_TYPE_ID or
(M.SCD_ROW_TYPE_ID=2 AND S.SCD_ROW_TYPE_ID=1)))B
ON(DIM_ACCOUNT.ROWID = B.ROW_ID)
WHEN MATCHED THEN
UPDATE SET DIM_ACCOUNT.F_LATEST_RECORD_INDICATOR= DECODE(B.SCD_ROW_TYPE_ID,2,'N',DIM_ACCOUNT.F_LATEST_RECORD_INDICATOR),
DIM_ACCOUNT.V_ORIGINAL_ACCOUNT_NUMBER=DECODE(B.SCD_ROW_TYPE_ID,3,
B.V_ORIGINAL_ACCOUNT_NUMBER,DIM_ACCOUNT.V_ORIGINAL_ACCOUNT_NUMBER),
DIM_ACCOUNT.V_PRODUCT_PROCESSOR_NAME=DECODE(B.SCD_ROW_TYPE_ID,3,B.V_PRODUCT_PROCESSOR_NAME,DIM_ACCOUNT.V_PRODUCT_PROCESSOR_NAME)
WHEN NOT MATCHED THEN
INSERT (DIM_ACCOUNT.FIC_MIS_DATE, V_ACCOUNT_NUMBER , DIM_ACCOUNT.V_ORIGINAL_ACCOUNT_NUMBER,
DIM_ACCOUNT.V_PRODUCT_PROCESSOR_NAME, DIM_ACCOUNT.F_LATEST_RECORD_INDICATOR, N_ACCT_SKEY)
VALUES ( B.FIC_MIS_DATE, B.V_ACCOUNT_NUMBER, B.V_ORIGINAL_ACCOUNT_NUMBER, B.V_PRODUCT_PROCESSOR_NAME, 'Y', SEQ_DIM_ACCOUNT_SCD.NEXTVAL)
Error Msg :-> ORA-04063: view "<SCHEMAOWNER>.STG_BORROWINGS_V" has errors



Changes

 

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


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