Customer Site Usage Import Error Query – FBDI Oracle Fusion

The below query extracts the error details along with interface attributes of Customer Site Usages import using FBDI in Fusion Applications.

SELECT distinct err.message_name ERROR_MESSAGE
,msg.message_text MESSAGE_TEXT
,site_use.*
FROM
hz_imp_errors err
,fnd_new_messages msg
,HZ_IMP_ACCTSITEUSES_T site_use
WHERE 1 = 1
AND err.message_name = msg.message_name
AND err.interface_table_name = ‘HZ_IMP_ACCTSITEUSES_T’
AND site_use.error_id = err.error_id
AND err.batch_id = site_use.batch_id
and err.batch_id = :batch_id