SF Accounting Lines

Good Afternoon

There was a server shutdown during the SF Journal creation in Financials resulting in in-complete creation of SF Journal with only 12 lines instead of 48 lines. SF Accounting lines in both SF and Finance had the correct lines and the problem was only at the journal level.

So to resolve this, I reset the SF lines in SF and deleted the SF accounting lines in Financials but when I run the GL generator in SF, it does not pick these reset lines to Financials, what am I missing here, please?

This happened on 5/24 and these are the sqls used, please help