Bank statement import process not returning transaction code error

Summary:

The process of importing bank statements was executed and ended in error, when searching for the reason for the error, the log did not show any additional details. Searched the UI but no bank statement was found, neither in the error section.

Content (required):

First of all we tried to find information in the error table- SELECT * FROM CE_STMT_IMPORT_ERRORS WHERE LOAD_REQUEST_ID = 1225052---No records returned

Subsequently we searched the interface tables to see the import status, but this column is empty.

SELECT * FROM CE_STATEMENT_HEADERS_INT WHERE LOAD_REQUEST_ID = 1225052

We need to know why the data from the interface tables was not imported to the final tables and how to solve this issue.