Failed to return the card transaction back to UN-use table as normal to raise expense report

Users have raised expense reports which could not be viewed in the application but visible in Backend(DB).The expense status code is NULL for them.Hence we generally delete the report and ask user to raise new one.But in one of the cases when the expense report is deleted the transactions did not fall back to the table for the user to select the transactions in order to raise a expense report.
Please suggest what can be done in this case or the reason why the transaction did not fall back.

I could still the transaction in ap_credit_card_trxns_all table.