Load supplier data

Load the supplier data from the excel template into the supplier inbound​ staging tables.

Before you begin

Role required: admin

Procedure

1. Navigate to All > Load Data.

   The Load Data page appears.

2. In Import set table, select Existing table.

3. From the Import set table list, select one of the following inbound tables depending on the type of supplier data you want to import:

   • Supplier location inbound [sn_fcms_intg_supplier_location_inbound]
   • Supplier contact inbound [sn_fcms_intg_supplier_contact_inbound​]
   • Supplier payment inbound [sn_fcms_intg_supplier_payment_inbound_stage]
   • In Source of the Import, choose File.

4. Browse to the excel template that was created in Add supplier inbound data in an Excel file.

5. Enter the Sheet number of the excel template that needs to be loaded into the staging table.

6. Enter the Header row of the excel template that needs to be loaded into the staging table.

7. Click Submit.

Result

The supplier data from the Excel file is processed successfully. That is, the relevant supplier data is extracted from the Excel file and stored in the SLO inbound staging tables.

What to do next

Run the transform map to import supplier data from the SLO inbound staging tables into the SLO primary tables.

• Run transform to update supplier primary data
  Use transform map and run transform to map the supplier fields from the import set into primary data target tables in Supplier Lifecycle Operations.
• Monitor the integration status of the SLO inbound data import
  Monitor the status of the integration after a transform runs and completes successfully.

Parent Topic:Supplier Lifecycle Operations integration framework

Related topics

Add supplier inbound data in an Excel file