Supplier Interface rejection tables in Oracle Fusion

Supplier Interface rejection tables in Oracle Fusion

Hi friends, we are going to discuss about the Supplier Interface rejection tables in Oracle Fusion. We will share the compete list of Supplier Interface Tables as well the Supplier Interface Rejection tables too which helps to rejected records details with the rejection reason. If we are uploading the supplier details using supplier interface tables in oracle fusion then some time some supplier records got rejected due to some data related issue. Then supplier rejection tables helps to store these rejected supplier records with the detail explanation of rejection reasons too. Using these rejection tables we can find out the rejected reasons and work on these supplier rejected records and then reprocess these records again. In oracle fusion, we have the only the single rejection table which helps to store the complete supplier interface tables rejected records. Please find below the complete detail about Supplier Interface rejection tables in Oracle Fusion.

Top 9 Supplier Interface Tables in Oracle Fusion

Here below is some of the most important supplier interface tables which helps to upload the supplier interface tables in 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

7.POZ_SUP_BUS_CLASS_INT

8.POZ_SUP_PROD_SERV_INT

9.POZ_SUP_ATTACHMENTS_INT

1 Important Supplier Interface rejection table

1. POZ_SUPPLIER_INT_REJECTIONS

Detail SQL Queries about Supplier Interface rejection tables in Oracle Fusion

Here below , we are sharing some of the important sql queries , which helps to extract the supplier interface rejected records using supplier interface in oracle fusion.

Supplier Interface rejection tables 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'

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'