Use following sql script to get the PO import errors.

Same sql can be created as a bi publisher report, and schedule to deliver the output to the key user daily.

SELECT
a.batch_id,
a.INTERFACE_HEADER_KEY,
a.BILLTO_BU_NAME,
a.PRC_BU_NAME,
a.REQ_BU_NAME,
a.DOCUMENT_NUM,
a.AGENT_NAME,
a.VENDOR_NAME,
a.VENDOR_SITE_CODE,
a.LOAD_REQUEST_ID,
b.COLUMN_NAME,
b.COLUMN_VALUE,
b.ERROR_MESSAGE,
b.ERROR_MESSAGE_NAME,
b.TABLE_NAME
FROM  PO_Headers_Interface a,
PO_Interface_Errors b
WHERE 1 = 1
AND a.INTERFACE_HEADER_ID = b.INTERFACE_HEADER_ID
AND b.ERROR_MESSAGE  !=  'The order number must be unique in a sold-to legal entity. '
and a.request_id = :request_id