Need Query to status of sales order import using FBDI

Content

Hi All,

I am importing sales order using FBDI and i need a report which will pull import status(Imported or error),source transaction number,error message in case of error .Can anyone help me with this report.

N.B: below is my query which is used but sometimes it fetches and sometimes it not fetch any record.

 

 

SELECT  req.req_entity_id1 "SOURCE TRANSACTION ID",

        dohai.interface_status_code "STATUS",

dohai.source_transaction_system "SOURCE TRANSACTION SYSTEM",

NULL "ORDER NUMBER",

        mt.message_text "ERROR MESSAGE"

FROM    doo_message_requests req,

        doo_messages_b mb       ,

        doo_messages_tl mt      ,