Stuck AR Transctions in interface table not going thru due to Duplicate Transaction Number

Dear AR Guru:

We have urgent production issue and hoping someone in the community will be able to assist us.

We are seeing invoices that are not loading in production. There are 5 such AR invoices stuck.

We see the following error message -

 

Duplicate invoice number 

 

Please Note - 

1. We do not see the invoice as duplicate as they do not exist in the base table.

2. All the data looks good as we were able to load the same data in our QA instance and the transactions were processed fine.

 

Due to the above, we have confirmed that the interface data is good.