We have a requirement to display FBDI Order Import validation/BIZ_ERROR messages in a custom BI Pub

Summary:

Need to identify the Fusion tables/views that store Order Import validation errors and BIZ_ERROR messages displayed in the Import Sales Orders ESS job log, so that the same messages can be reported in a custom BI Publisher report.

Content (please ensure you mask any confidential information):

We are developing a custom BI Publisher report for Order Import exceptions.

When the Import Sales Orders ESS job fails, validation errors are displayed in the ESS log as BIZ_ERROR messages. We would like to retrieve the same error messages through SQL and display them in a custom BI Publisher report along with the Source Order Number and Source Line Number.