Query to get HDL Error Count Details Report

 Below query can be used to identify load details and related with the count. This query is used to get error details along with the count.

SELECT B.DATA_FILE_NAME,  

                A.MSG_TEXT, 

               COUNT(*) COUNT

FROM hrc_dl_message_lines A ,

               hrc_dl_data_set_bus_objs B,

               hrc_dl_data_sets C

WHERE B.data_set_bus_obj_id = A.data_set_bus_obj_id

 AND    C.data_set_id = B.data_set_id

 AND C.UCM_CONTENT_ID IN (:P_CONTENTID)

 and A.msg_text like nvl(:errorText, '%')

GROUP BY B.DATA_FILE_NAME,A.MSG_TEXT