We were down this same path, with lots of change logs going way back. Finally decided to skinny down the # of fields logged and only keep the most recent 2 years. We purged the rest with the ‘Database Purge & Summarize’ process, and now run it monthly. There’s no filter on it besides the cut-off date, but it will delete a ton of old garbage. Make sure to check ‘Change Log’ and not something else by accident!
Careful if you do use the purge and summarize process for the Journal Details, it will delete GL’s on old open invoices (before the cut-off date), which then will go to the review journal because it’s one-sided. Ask Epicor, and that’s working as designed. You’ll need to add the GL’s back with the FX_Fix_Tranglc datafix. We purge this every January with a 3 year cut-off.