Hi all,
A quick heads-up for anyone on IFS Cloud 26R1 (we're on SU3, Oracle 19c). After the update, Account Matching took minutes or showed no data, even for small accounts.
Cause: the SELECTs on GEN_LED_VOU_ROW_ACC_MATCH behind Account_Match_Handling_SVC.Do_Add_Transactions (SQL_IDs 17tnfdbgpmvtp and 5zxp5phtpx2du) sometimes pick a plan that reads every voucher row of the company via GEN_LED_VOUCHER_ROW_IX7, instead of going through the account's posting combinations via GEN_LED_VOUCHER_ROW_IX4.
Fix: our DBA pinned the good plan with a fixed SQL plan baseline (DBMS_SPM) and purged the cursors. The average call went from 3–7 minutes to about 40 s, and total time dropped about 90% on the same number of calls.
If you see multiple plan hash values for these SQL_IDs in AWR, it's worth checking. Has anyone else run into this, or raised it with IFS?
Jan