Slow FDMEE SQL on Oracle 19c in FDMEE 11.2.8

Hi Folks,

Quick question, has anyone seen performance issues with FDMEE 11.2.8 SQL running against Oracle 19c (19.15) database? And if so are there any tips?

We've been seeing 8 minute gaps in HFM data loads in the ‘Validate balance data’ step and a 4 minute gap in the ‘Export data to consolidation application’ step as well as another 4 minute gap where FDMEE is counting the records it loaded ?

I've isolated it to these three SQL queries, all running against the AIF_HS_BALANCES table...

SQL that seems to run when validating (runs twice - 4 minutes per run at worst)

SELECT ACCOUNT, ENTITY, ICP, UD1, UD2, UD3, UD4, YEAR as YEAR, PERIOD as PERIOD, SCENARIO AS SCENARIO, DATAVIEW AS DATAVIEW, DATAVALUE AS VALUE, SUM(AMOUNT) AS AMOUNT, JOURNALID as JOURNALID FROM AIF_HS_BALANCES WHERE LOADID = :1 GROUP BY SCENARIO, PERIOD, DATAVIEW, ACCOUNT, ENTITY, ICP, UD1, UD2, UD3, UD4, YEAR, PERIOD, SCENARIO, DATAVIEW, DATAVALUE, JOURNALID ORDER BY ENTITY, ACCOUNT