Find Oracle Fusion . Cloud Sales order Import Errors - query

Below query will return Error messages for "Import Sales Order ESS" in Oracle Management cloud.


SELECT
msg.*

FROM fusion.DOO_ORDER_HEADERS_ALL_INT orderHdr,
fusion.DOO_ORDER_LINES_ALL_INT OrderLine ,
fusion.DOO_MESSAGES_VL MSG ,
fusion.DOO_MESSAGE_REQUESTS DMR
WHERE orderHdr.source_transaction_ID = dmv.msg_entity_id1
AND orderHdr.source_transaction_ID = OrderLine.source_transaction_ID
AND orderHdr.interface_status_code IS NOT NULL
AND orderHdr.load_request_id = OrderLine.load_request_id
AND DMR.ACTIVE_FLAG = 'Y'
AND DMV.MSG_REQUEST_ID = DMR.MSG_REQUEST_ID
AND orderHdr.batch_name = 'SI2140420' ORDER BY orderHdr.creation_Date DESC

select
REQ.CREATION_DATE    ,
REQ.ACTIVE_FLAG      ,
REQ.REQ_ENTITY_TYPE  ,
REQ.REQ_ENTITY_ID1   ,
REQ.REQ_ENTITY_ID2   ,
REQ.REQ_ENTITY_ID3   ,
REQ.REQ_ENTITY_ID4   ,
REQ.REQ_ENTITY_ID5   ,
MB.MESSAGE_ID   M_ID     ,
MT.MESSAGE_ID        ,
MT.MESSAGE_TEXT      ,
MB.MESSAGE_TYPE      ,
MB.MSG_REQUEST_ID    ,
MB.MESSAGE_NAME
from    DOO_MESSAGE_REQUESTS REQ,
DOO_MESSAGES_B MB       ,
DOO_MESSAGES_TL MT 
where   MB.MSG_REQUEST_ID =REQ.MSG_REQUEST_ID
and MB.MESSAGE_ID = MT.MESSAGE_ID
and MT.LANGUAGE   = 'US'
and REQ.ACTIVE_FLAG = 'Y'
-- and REQ.REQ_ENTITY_ID1  = '20200331-29718711-U1'
order by creation_date desc