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.

Supplier Site FBDI

Supplier Site Import FBDI

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’

Recommended Posts

Start typing and press Enter to search