Where are Sales Order Import line level errors stored in Oracle Cloud Fusion

Hi Experts,

I'm importing Sales Orders into Oracle Fusion Cloud. If one of the order lines fails validation, I'm unable to find the detailed error message for that specific line.

I checked the Interface tables, but I couldn't find the line-level error details.

My query:

select
doo.source_transaction_id,
doo.source_transaction_system,
decode(mb.message_type,'ERROR','E','S') status,
mt.message_text error_message,
null order_numberfrom DOO_MESSAGE_REQUESTS REQ,
DOO_MESSAGES_B MB ,
DOO_MESSAGES_TL MT,
doo_order_headers_all_int doowhere MB.MSG_REQUEST_ID =REQ.MSG_REQUEST_ID
and MB.MESSAGE_ID = MT.MESSAGE_ID