The below query extracts the error details along with interface attributes of Customer Account import using FBDI in Fusion Applications.
SELECT distinct err.message_name ERROR_MESSAGE
,msg.message_text MESSAGE_TEXT
,acc.*
FROM
hz_imp_errors err
,fnd_new_messages msg
,hz_imp_accounts_t acc
WHERE 1 = 1
AND err.message_name = msg.message_name
AND err.interface_table_name = ‘HZ_IMP_ACCOUNTS_T’
AND acc.error_id = err.error_id
AND err.batch_id = acc.batch_id
and err.batch_id = :batch_id
Recommended Posts