Using following code can get the employee information in Oracle HCM, in real time, what we can do is to use this as a data feed, and bulk update the employee information using some scripting language

select pu.user_id, papf.person_id, pu.user_guid, papf.person_number, pu.username, pea.email_address
from per_all_people_f papf, per_users pu, per_email_addresses pea
where papf.person_id = pu.person_id
and pu.person_id = pea.person_id

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

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%'