2400284 - J1B_NFE012 Error - Nota Fiscal inconsistent in some J_1BNF tables

A Nota Fiscal document has been saved through any known scenario.
The issue being that one or most of the NFe related tables (J_1BNFDOC, J_1BNFLIN, J_1BNFSTX, J_1BNFFTX...) have missing entries.
For instance, one of the issues that may happen is when trying to access the NFe in J1B3N the error message appears:

No entry exists in the Actual Status table for document number

Message No. J1B_NFE012

• SAP Localization Brazil - Nota Fiscal Eletronica
• SAP ERP Release Independent

J1B_NFE012, Database inconsistency, problems, tabelas sem dados, NFe incompleta, incomplete document, empy tables, J_1BNFE_ACTIVE, J_1BNFDOC, MIGO, MIGO_GR, MIRO, Material Document, Database Inconsistency, NFe, NF-e , KBA , inconsistency , database , problems , tabelas sem dados , nfe incompleta , incomplete document , empty tables , FI-LOC-NFE-BR-OUT , Outbound , XX-CSC-BR , Brazil , XX-CSC-BR-NFE , Use FI-LOC-NFE-BR-OUT , FI-LOC-NFE-BR-IN , GRC NF-e Inbound Automation , Problem