My Oracle Support Banner

T2T_FCT_REG_REPLINE_ACC_FRY9C_HCV Is Long Running Due To Missing Join Between FRAS And DIM_RUN (Doc ID 2741303.1)

Last updated on JANUARY 09, 2021

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.9 and later
Information in this document applies to any platform.

Symptoms

T2T_FCT_REG_REPLINE_ACC_FRY9C_HCV is long running due to missing join between FRAS and DIM_RUN

Existing join:

INNER JOIN DIM_DATES ON FCT_REG_ACCOUNT_SUMMARY.n_mis_date_skey = dim_dates.n_date_skey AND dim_dates.d_calendar_date = TO_DATE('20200630','YYYYMMDD')
INNER JOIN dim_run ON dim_run.n_run_skey = $runskey

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.