This blog describes the step by step process of Supplier migration in Fusion Application using File Based Data Import.
FBDI Template: SupplierImportTemplate.xlsm
Interface Tables: POZ_SUPPLIERS_INT
Base Table: POZ_SUPPLIERS
Import Process: Import Suppliers
STEP 1: Download Supplier FBDI template from oracle website.
STEP 2: Populate the data both POZ_SUPPLIERS_INT sheet of template as shown below.
STEP 3: Generate PozSuppliersInt.zip file in local system using “Generate CSV File” option.
STEP 4: Login to application and upload the PozSuppliersInt.zip file to interface table using “Load Interface File for Import” process.
STEP 5: Run “Import Suppliers” process to import the interfaced data.
STEP 6: Get the error details using below SQL Query
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’
