HDL Issue Summary

Query to get Summary Detail on Load Errors based on UCM Content Id

HRC_DL_DATA_SETS - This table stores information about data sets that are created when uploading or processing HDL files. 

select UCM_CONTENT_ID ,

               DATA_SET_ID ,

               DATA_SET_NAME ,

               IMPORTED_STATUS ,

               LOADED_STATUS ,

               IMPORT_LINES_SUCCESS_COUNT ,

               IMPORT_LINES_ERROR_COUNT,

               IMPORT_LINES_TOTAL_COUNT,

               IMPORT_SUCCESS_COUNT,

               IMPORT_ERROR_COUNT ,

               LOADED_COUNT ,

               ERROR_COUNT ,

               REQUEST_ID 

 from    HRC_DL_DATA_SETS

 where  UCM_CONTENT_ID = :P_CONTENTID