In this post, I will provide you the list of the Interface tables for the Suppliers import in Oracle cloud fusion and also the corresponding Supplier Interface error table.
The Supplier rejection interface table will provide you the Status of the records and the corresponding rejection reason if there are any errors during the Import Process.
Here is the list of the Supplier Interface tables in the Oracle fusion :
1. POZ_SUPPLIERS_INT
2. POZ_SUP_ADDRESSES_INT
3. POZ_SUPPLIER_SITES_INT
4. POZ_SITE_ASSIGNMENTS_INT
5. POZ_SUP_CONTACTS_INT
6. POZ_SUP_CONTACT_ADDRESSES_INT
These tables will hold the records to be imported into the Oracle fusion. Each of these tables have either "Status" or "Import_Status" column which provides the status of the records following the import process.
And say if there are any rejections or errors in the Interface records, the "Status" or the "Import_Status" column are updated with the "REJECTED" otherwise it will be updated with the "PROCESSED" status.
Following is the error/rejection table which will hold the error or the rejected reason for the interface records.
POZ_SUPPLIER_INT_REJECTIONS
How do you link these interface tables with this rejections table ? See below for the connecting these tables.
1. Suppliers Import :
SELECT psi.vendor_interface_id, psir.reject_lookup_code, psir.attribute
FROM POZ_SUPPLIERS_INT psi,
POZ_SUPPLIER_INT_REJECTIONS psir
WHERE psir.parent_id = psi.vendor_interface_id
AND psi.status = 'REJECTED'
AND psir.parent_table = 'POZ_SUPPLIERS_INT'
2. Suppliers Address Import
SELECT psai.address_interface_id, psir.reject_lookup_code, psir.attribute
FROM POZ_SUP_ADDRESSES_INT psai,
POZ_SUPPLIER_INT_REJECTIONS psir
WHERE psir.parent_id = psai.address_interface_id
AND psai.import_status = 'REJECTED'
AND psir.parent_table = 'POZ_SUP_ADDRESSES_INT'
3. Suppliers Sites Import
SELECT pssi.vendor_site_interface_id,psir.reject_lookup_code, psir.attribute
FROM POZ_SUPPLIER_SITES_INT pssi,
POZ_SUPPLIER_INT_REJECTIONS psir
WHERE psir.parent_id = pssi.vendor_site_interface_id
AND pssi.status = 'REJECTED'
AND psir.parent_table = 'POZ_SUPPLIER_SITES_INT'
4.Supplier Site Assignment Import
SELECT psai.assignment_interface_id, psir.reject_lookup_code, psir.attribute
FROM POZ_SITE_ASSIGNMENTS_INT psai,
POZ_SUPPLIER_INT_REJECTIONS psir
WHERE psir.parent_id = psai.assignment_interface_id
AND psai.status = 'REJECTED'
AND psir.parent_table = 'POZ_SITE_ASSIGNMENTS_INT'
5. Supplier Contacts Import
SELECT psci.contact_interface_id, psir.reject_lookup_code, psir.attribute
FROM POZ_SUP_CONTACTS_INT psci,
POZ_SUPPLIER_INT_REJECTIONS psir
WHERE psir.parent_id = psci.contact_interface_id
AND psci.import_status = 'REJECTED'
AND psir.parent_table = 'POZ_SUP_CONTACTS_INT'
6. Supplier Contact Address Import
SELECT pscai.contact_address_interface_id,psir.reject_lookup_code, psir.attribute
FROM POZ_SUP_CONTACT_ADDRESSES_INT pscai,
POZ_SUPPLIER_INT_REJECTIONS psir
WHERE psir.parent_id = pscai.contact_address_interface_id
AND pscai.import_status = 'REJECTED'
AND psir.parent_table = 'POZ_SUP_CONTACT_ADDRESSES_INT'
