We have an erroneous miscelaneous transaction that is pending in the closing process.

A miscellaneous transaction was created by a user with erroneous information and is being shown in the pending transactions. Later the user created a new miscellaneous transaction with the right information (including the right serial number). That caused that the first transaction remained in the pending transactions because the serial number existed in the sub-inventory.

Now, we are trying to close the Inventory period, and the first transaction appears pending, but we cannot submit it due to the serial number error.

My question is: Is there any way to delete that transaction form the MTL_MATERIAL_TRANSACTIONS_TEMP table?

or Is there any other option to remove the transaction in order to process the closing period?