Customer Site Import Error Query – FBDI Oracle Fusion

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

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