Payroll Batch Loader Error Report

Summary

Payroll Batch Loader Error Report with Line Details

Content

Hi,

Can any one please share Payroll Batch Loader Error report if you have?

I am building a report to get all the error records with their content from Payroll batch loader. However the problem is, Batch line content is sitting as BLOB in batch header table. I need to separate the error lines from it.

My base query is like below.

SELECT PBML.message_text,

       PBL.LINE_SEQUENCE,

   PBL.BATCH_LINE_STATUS,

   PBH.BATCH_NAME,

   PBH.BATCH_CONTENT

  FROM pay_bl_message_lines_vl PBML,

       pay_batch_lines         PBL,