Supplier Interface error tables in Oracle Cloud Fusion.

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'