Supplier Management

Get Involved. Join the Conversation.

Topic

    Wendy Ware
    How to Mass Update Supplier Type on Existing SuppliersAnswered
    Topic posted July 16, 2019 by Wendy WareBronze Crown: 15,000+ Points, tagged How-To, Payables, Setup, Supplier Profile Management 
    98 Views, 5 Comments
    Title:
    How to Mass Update Supplier Type on Existing Suppliers
    Summary:
    we want to update the supplier type on 1000+ suppliers
    Content:

    We are seeking to mass update the Supplier Type attribute of 1000+ existing suppliers.  Can anyone point me in the right direction?

    Thanks, Wendy

    Version:
    Rel 13 Ver 19B

    Best Comment

    Aishwarya Pawar

    Hi Wendy,

    Great question. Yes, you want to make sure you select a template that matches your current release. We have another post to walk you through the steps.

    https://cloudcustomerconnect.oracle.com/posts/da9d60b885

    Also, you are correct about using the SupplierImport template.

    Hope that helps!

    Aishwarya

     

    Comment

     

    • Aishwarya Pawar

      Hi Wendy,

      Supplier Import is what you would want to use to make this mass update. Here is another post that could help:

      https://cloudcustomerconnect.oracle.com/posts/abbe7769e1

      Thanks,

      Aishwaya

    • Karthikeyan Sukumar

      Hi Wendy- You can use the Supplier FBDI to update the supplier type for 1000+ suppliers.

      1.Extract the Supplier data using the standard reports

      2.Upload the data into Supplier FBDI and change the value in the supplier type which you need

      3.Upload the FBI template into Oracle 

       

      Thanks!

      Karthik

    • Wendy Ware

      Thank you, Aishwaya and Karthik, for your prompt replies.

      Is it as easy as using this one FDBI template "SupplierImportTemplate.xlsm?"  (attached)

      How can I be sure this is the current template? 

      Any guidance appreciated.  Wendy

       

       

      • Aishwarya Pawar

        Hi Wendy,

        Great question. Yes, you want to make sure you select a template that matches your current release. We have another post to walk you through the steps.

        https://cloudcustomerconnect.oracle.com/posts/da9d60b885

        Also, you are correct about using the SupplierImport template.

        Hope that helps!

        Aishwarya

         

      • Karthikeyan Sukumar

        Wendy-Yes this correct template

        Thanks!

        Karthik