Load Data Warehouse is slow on DWH_X_INV_SUM_FACTS (Oracle)

book

Article ID: 129772

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

We are on Clarity version that's lower than 15.5.
When we run the Load Data Warehouse job, it's quite slow. When we check the DWH_GATHER_METRICS_V we see that much of the time taken is for table DWH_X_INV_SUM_FACTS
 

Environment

Release: CODFSS99000-15.3-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution

DWH_X_INV_SUM_FACTS slowness resolved with S159280 in 15.5.0 and higher