Supplier Management

Get Involved. Join the Conversation.


    Aishwarya Pawar
    Supplier Import Tips
    Topic posted January 26, 2018 by Aishwarya PawarGold Medal: 3,500+ Points, tagged How-To, Import, Tip 
    Supplier Import Tips
    Tips for importing supplier records using FBDI templates from external sources into Oracle Supplier Model Cloud

    Supplier import functionality allows you to mass insert or update supplier records into the supply base. Import records are first loaded into interface tables and then added to the supply base post successful validation. 

    Here are some tips to consider that could help ensure your supplier import processes run successfully:

    Populating FBDI templates

    1. Use #NULL wherever applicable to update an attribute value to blank. E.g. use #NULL to remove Acme Corp. as the Alternate Name.
      Refer to Comments added for every import column header in the FBDI import templates to find useful details such as attribute description, interface table column name, actions supported, UI navigation that can help you identify acceptable values. Also, refer to the Instructions and CSV Generation worksheet for details on how  CSV files should be generated and used to import records.
    2. Use the Batch ID attribute (displayed as a column name in FBDI templates) and the corresponding parameter while submitting an import process, especially if you are importing a large number of import records. This will allow you to process import records in a single import file using multiple processes. Also please note that when no value is provided for Batch ID parameter, only import records that do not have a Batch ID specified will be processed.
    3. You can import contact addresses for an existing contact without importing the contact i.e. it is perfectly acceptable to leave the POZ_SUP_CONTACTS worksheet empty and only populate the POZ_SUPP_CONTACT_ADDRESSES_INT worksheet in the Supplier Contacts Import template.
      OTBI subject area: Supplier Import - Supplier Real Time and related seeded reports can be leveraged to populate supplier import templates starting Release 11. The reports are in a format that resemble the templates and could be used to generate import data that is suitable to be copied over to the templates . For more details refer to the Release 11 training: Supplier Reporting Enhancements.

    Scheduling import processes

    1. While scheduling an import process to import new records, be sure to select the import option of "New". This ensures that the current import process does not attempt to validate existing interface table records that have already been processed and rejected previously.
    2. Ensure that your parent entity exists in the supply base before importing the child entities. E.g. ensure the supplier site exists before importing its site assignments.

    After successful imports

    Empty the interface table of the supplier entity you have successfully imported by running the Purge Supplier Interface Records process immediately after the import. This ensures that interface tables are empty for your subsequent import and the new import process does not attempt to process older records which are no longer relevant. NOTE: This process is available along with the other import processes.