ORACLE MASTERMINDS

Supplier FBDL Import Error Details

The below queries can be used to extract the import error details of Supplier import through FBDL process for the below components.

1. Supplier
2. Supplier Address
3. Supplier Sites
4. Supplier Site Assignements
5. Supplier Business Classifications

-- 1. Supplier
SELECT REJ.reject_lookup_code
      ,REJ.ATTRIBUTE error_field, REJ.VALUE error_value, INTE.*
FROM poz_suppliers_int INTE
    ,poz_supplier_int_rejections REJ
WHERE REJ.parent_id = INTE.vendor_interface_id
  AND PARENT_TABLE = 'POZ_SUPPLIERS_INT'

--2. Supplier Address
SELECT REJ.reject_lookup_code
      ,REJ.ATTRIBUTE error_field, REJ.VALUE error_value, INTE.*
FROM poz_sup_addresses_int INTE
    ,poz_supplier_int_rejections REJ
WHERE REJ.parent_id = INTE.address_interface_id
  AND PARENT_TABLE = 'POZ_SUP_ADDRESSES_INT' --   
 
--3.Supplier Sites
SELECT REJ.reject_lookup_code
      ,REJ.ATTRIBUTE error_field, REJ.VALUE error_value, INTE.*
FROM poz_supplier_sites_int INTE
    ,poz_supplier_int_rejections REJ
WHERE REJ.parent_id = INTE.vendor_site_interface_id
  AND PARENT_TABLE = 'POZ_SUPPLIER_SITES_INT' -- 

--4. Supplier Site Assignments
SELECT REJ.reject_lookup_code
      ,REJ.ATTRIBUTE error_field, REJ.VALUE error_value, INTE.*
FROM poz_site_assignments_int INTE
    ,poz_supplier_int_rejections REJ
WHERE REJ.parent_id = INTE.assignment_interface_id
  AND PARENT_TABLE = 'POZ_SITE_ASSIGNMENTS_INT' --
 
--5. Supplier Business Classifications
SELECT REJ.reject_lookup_code
      ,REJ.ATTRIBUTE error_field, REJ.VALUE error_value, INTE.*
FROM poz_sup_bus_class_int INTE
    ,poz_supplier_int_rejections REJ
WHERE REJ.parent_id = INTE.classifications_interface_id
  AND TRUNC(REJ.creation_date) LIKE SYSDATE 
  AND PARENT_TABLE = 'POZ_SUP_BUS_CLASS_INT'