BI Query to fetch Import Sales Orders Subprocess Errors

Hi Everyone,

I’m working on a requirement to extract all errors that occur during the Sales Order Import process in Oracle Fusion, including those generated by any subprocesses.

I’ve written the query below, which successfully retrieves errors related to the main import process (i.e., the parent job), but it currently does not capture errors from the underlying subprocesses.

I’d appreciate any guidance or suggestions on how to enhance this query to include subprocess-level errors as well.

SELECT DISTINCT DME.entity_name ,
dohai.BATCH_NAME ,
dohai.SUB_BATCH_NAME ,
dohai.source_transaction_number ,
DME.entity_id ,
dmb.MSG_ENTITY_ID2 ,