Dealinc long-running

Hi everyone,
We’re facing performance issues with the dealinc process in RMS 19.0.1. A query (SQL_ID = 1x41dt6q5dzm9) is executed 111,632 times, causing this single process to run for over 2 hours.

SELECT SUM(
DECODE(:b0, 'Q', actual_turnover_units, 'A', actual_turnover_revenue)
)
FROM deal_actuals_item_loc
WHERE deal_id = :b1
AND deal_detail_id = :b2
AND reporting_date = TO_DATE(:b3, 'YYYYMMDD')

While each execution is individually fast, the sheer number of executions is what makes the process extremely slow.

The number of BB / BBR deals is not high (around 30 total), and they are all at the