When triggers the supplier import for Procurement Cloud, we need to check the import errors.

It’s tedious to check the standard pdf report generated by the import process.

Instead, we can create following reports and schedule it to run daily, to delivery the errors to a key user to check the detail issue.

-- Rejection for Supplier Header
select rej.REJECT_LOOKUP_CODE, sup.* from POZ_SUPPLIER_INT_REJECTIONS rej, POZ_SUPPLIERS_INT sup
where rej.request_id = :request_id
and rej.reject_lookup_code not like 'Supplier Number%already exists. Review the supplier numbering setup.%'
and rej.reject_lookup_code not like 'A record with the value%already exists. Enter a unique value.%'
and rej.PARENT_ID = sup.VENDOR_INTERFACE_ID

-- Rejection for Supplier Addresses
select rej.REJECT_LOOKUP_CODE, adr.* from POZ_SUPPLIER_INT_REJECTIONS rej, POZ_SUP_ADDRESSES_INT adr
where rej.request_id = :request_id
and rej.reject_lookup_code not like 'The value already exists. You must provide a unique value.'
and rej.PARENT_ID = adr.address_interface_id

-- Rejection for Supplier Sites
select rej.reject_lookup_code, site.* from POZ_SUPPLIER_INT_REJECTIONS rej, POZ_SUPPLIER_SITES_INT site
where rej.request_id = :request_id
and rej.PARENT_ID = site.VENDOR_SITE_INTERFACE_ID
and rej.reject_lookup_code not like 'The site name already exists in the given procurement business unit for the supplier indicated in the record.%'

-- Rejection for Site Assignments
select rej.REJECT_LOOKUP_CODE, ass.* from POZ_SUPPLIER_INT_REJECTIONS rej, POZ_SITE_ASSIGNMENTS_INT ass
where rej.request_id = :request_id
and rej.reject_lookup_code not like 'The assignment for the Client BU already exists for the given supplier, site, and procurement business unit combination indicated in the record%'
and rej.PARENT_ID = ass.ASSIGNMENT_INTERFACE_ID

-- IBY_TRANSACTION_ERRORS contains the detail error message for the Bank account import
-- Bank Account Import Errors
select * from IBY_TRANSACTION_ERRORS where creation_date > sysdate -1 and error_message not like 'The external bank account already exists. The details included in the interface table are ignored%'
and error_message not like 'The external payee already exists. The details included in the interface table are ignored%'