How to resolve Create Accounting Error for External Transaction Stuas is Invalid no Account period

Summary: Business has run the create accounting for Cash Management Sub ledger Application, however it was error out and Status shows as Invalid instead of Final. Few lines were posted to GL and status as Final with in the Transactions, rest all lines shows as Invalid and Account period field is Blank.

how to resolve this kind of issues in prod. I believe there might be data stuck in back end tables.