You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Query to fetch Import Sales Orders Subprocess Errors

edited May 16, 2025 6:41AM in SCM Integrations

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 ,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!