Inventory Period - Resubmitting Unprocessed Materials

I have a few records showing it is currently background processing and records are locked but actually they are not being processed.

From the Oracle Application Form you cannot re-submitting those records because the records are locked. Due to this error you cannot close your month-end inventory period.

Here is how you can re-submit those locked transaction via SQL-Plus

SQL> select process_flag, lock_flag, transaction_mode, error_code
from mtl_transactions_interface;


PROCESS_FLAG     LOCK_FLAG      TRANSACTION_MODE   ERROR_CODE
--------------------------------------------------------------------------------
           1                                1                                       3
           1                                1                                       3
           1                                1                                       3

SQL> update mtl_transactions_interface set process_flag = 1, lock_flag = 2, transaction_mode = 3, error_code = null where transaction_id = '&transaction_id';

3 rows updated.

SQL> commit;

Commit complete.

Records should be picked up by background process and it should process the records again.