Supplier interface error table in oracle fusion

Supplier interface error table in oracle fusion

Hi friends, we are going to discuss about the Supplier interface error table in oracle fusion. We will share the list of important tables which helps to store the supplier interface error out records during upload. If we uploading the supplier through FBDI and it got error out and we want to find out these records we can use these Supplier interface error tables to get the details. The important thing about the Supplier interface error table is this , we can able to find out the error out reason for that supplier record so that we can take the correct action to process that supplier record from supplier interface in oracle fusion. As of you , Supplier tables are quite changes in oracle fusion as compared to oracle apps. As well the the complete structure of supplier in oracle fusion is complete different from oracle ebs. In oracle apps, we can find out the error out records from interface tables directly but in oracle fusion , we have the separate table to store the supplier interface error records in oracle fusion.

Supplier interface error table in oracle fusion

2 Important Supplier interface error table in oracle fusion

POZ_SUPPLIER_INT_REJECTIONS

POZ_SUPPLIER_INT_REJECTIONS:-

This table is very important table in supplier interface. This is the only single table which helps to store the complete error out records from all supplier interface tables in oracle fusion. 

we have 9 supplier interface tables in oracle fusion. So any supplier record got errored out in any of these tables and we want to know the reason , then we can simply find out that record with rejection reason for this POZ_SUPPLIER_INT_REJECTIONS table.

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

7.POZ_SUP_BUS_CLASS_INT

8.POZ_SUP_PROD_SERV_INT

9.POZ_SUP_ATTACHMENTS_INT

SQL Query to extract Supplier interface error records in oracle fusion

If we want to extract the Supplier Header error out records with rejection details/reasons.

select * from POZ_SUPPLIER_INT_REJECTIONS

where parent_table='POZ_SUPPLIERS_INT'

If we want to extract the Supplier Site error out records with rejection details/reasons.

select * from POZ_SUPPLIER_INT_REJECTIONS

where parent_table='POZ_SUPPLIER_SITES_INT'

If we want to extract the Supplier Addresses error out records with rejection details/reasons.

select * from POZ_SUPPLIER_INT_REJECTIONS

where parent_table='POZ_SUP_ADDRESSES_INT'

Supplier interface error table in oracle fusion

If we want to extract the Supplier Site Assignments error out records with rejection details/reasons.

select * from POZ_SUPPLIER_INT_REJECTIONS

where parent_table='POZ_SITE_ASSIGNMENTS_INT'

If we want to extract the Supplier Contacts error out records with rejection details/reasons.

select * from POZ_SUPPLIER_INT_REJECTIONS

where parent_table='POZ_SUP_CONTACTS_INT'

Supplier interface error table in oracle fusion