SQL Query to extract the Supplier Interface Rejected records with Rejection reasons

SQL Query to extract the Supplier Interface Rejected records with Rejection reason

Hi friends, we are going to discuss about the SQL Query to extract the Supplier Interface Rejected records with Rejection reason. This is one of the most important sql query while working with supplier upload using supplier interface in oracle fusion. Oracle fusion has provided various methods to upload/create the suppliers in bulk in application. We have the FBDI Option , Rest API option to create the suppliers in oracle fusion. When we upload the suppliers using supplier interface some of the records got rejected due to various data related reasons. We need to find out these rejected records and the rejection reason too , so that we can work on these rejected records and can able to re process again. In this post , we will try to share the some complete details about supplier interface and the supplier interface rejection table too which helps to store the supplier rejected records with rejection reasons. Please find below the complete detail about the SQL Query to extract the Supplier Interface Rejected records with Rejection reason.

SQL Query to extract the Supplier Interface Rejected records with Rejection reason.

5 Important Table about Supplier Interface 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

Important Table to store the Supplier Interface Rejected records in Oracle Fusion

POZ_SUPPLIER_INT_REJECTIONS

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

Detail SQL Query to extract the Supplier Interface Rejected records with Rejection reason

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'

order by creation_date desc

select * from POZ_SUPPLIER_INT_REJECTIONS

where parent_table='POZ_SITE_ASSIGNMENTS_INT'

Order by creation_date desc

select * from POZ_SUPPLIER_INT_REJECTIONS

where parent_table='POZ_SUP_CONTACTS_INT'

Order by creation_date desc

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'

order by creation_date desc

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'

order by creation_date desc

SQL Query to extract the Supplier Interface Rejected records with Rejection reason.