This blog describes the step by step process of Supplier Site migration in Fusion Application using File Based Data Import.
FBDI Template: SupplierSiteImportTemplate.xlsm
Interface Tables: POZ_SUPPLIER_SITES_INT
Base Table: POZ_SUPPLIER_SITES_ALL_M
Import Process: Import Supplier Sites
STEP 1: Download FBDI template from oracle website.
STEP 2: Populate the data both POZ_SUPPLIER_SITES_INT sheet of template as shown below.
STEP 3: Generate PozSupplierSitesInt.zip file in local system using “Generate CSV File” option.
STEP 4: Login to application and upload the PozSupplierSitesInt.zip file to interface table using “Load Interface File for Import” process.
STEP 5: Run “Import Supplier Sites” 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_sup_addresses_int INTE
,poz_supplier_int_rejections REJ
WHERE REJ.parent_id = INTE.address_interface_id
AND PARENT_TABLE = ‘POZ_SUP_SITES_INT’