• Aishwarya Pawar
    Supplier Import Tips4.7
    Topic posted January 26, 2018 by Aishwarya PawarGold Medal: 3,500+ Points, tagged How-To, Import, Tip in Procurement > Supplier Management public
    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.

  • Aishwarya Pawar
    Use ERP Integration Service to automate Supplier Import5.0
    Topic posted December 20, 2018 by Aishwarya PawarGold Medal: 3,500+ Points, tagged How-To, Import, Web Services in Procurement > Supplier Management public
    Use ERP Integration Service to automate Supplier Import
    (How-To) use the ERP Integration Web Service to import suppliers into Oracle Procurement Cloud

    Supplier Import feature allows you to bulk load suppliers from external systems into Oracle Procurement Cloud. This involves capturing the import data in a CSV format, uploading the data file to the UCM server, loading the data into interface tables and then moving it to the supply base post successful validation. The loading and importing of data is accomplished by scheduling 2 ESS processes:

    1. Load Interface File for Import process that loads the data into the interface table
    2. The import process that validates the data in the interface tables and moves it to the supplier base (E.g. Import Suppliers, Import Supplier Addresses etc.).

    ERP Cloud provides an integration web service that helps automate the steps to upload data file (CSV format) to the UCM server, load the data into interface tables and subsequently import it into Oracle Procurement Cloud. This eliminates the need to execute these steps manually.

    Here are the instructions to import supplier data using the ERP Integration Web Service:

    1. Use the FBDI templates available on Oracle Help Center to capture the import data and generate the CSV file (made available as a zip file). TIP: Using these templates ensures import data is loaded into the interface in the correct format. The latest import templates are available here.
    2. Convert the zip file generated above to BASE64 encoding. NOTE: You will later need to insert that in the request payload below.
    3. Construct the ERP Integration Service End Point URL (WSDL URL). Note: Replace HOST_NAME.DOMAIN_NAME using the appropriate values from your pod instance in this URL: https://<hostname>.<domainname>/publicFinancialCommonErpIntegration/ErpIntegrationService.
    4. Create the payload for the operation: importBulkData available as part of the service. In general, this operation uploads the file specified in the payload to the UCM server and submits ESS jobs to load and import the uploaded files to the appropriate application. NOTE: Sample request payload included below.
    5. Ensure the payload is correctly populated as follows:
      1. Insert the ZIP file contents in BASE64 encoding within the <erp:Content> tag.
      2. Specify the exact file name of the ZIP file in the <erp: FileName> tag.
      3. Include the correct import process in the <erp: JobName> tag. E.g. include /oracle/apps/ess/prc/poz/supplierImport,ImportSuppliers if suppliers are being imported or /oracle/apps/ess/prc/poz/supplierImport,ImportSupplierAddresses if supplier addresses are being imported.
      4. List the import parameters in the order specified within the <epr:ParameterList> tag: Import Options (valid values: NEW,ALL,REJECTED), Report Exceptions Only (valid values: N,Y), Batch ID (as specified in CSV data file. Do not include a value if not specified in data file.)
    6. Invoke the ERP Integration Service.
    7. The response of the operation: importBulkData contains the process ID of the job that will load the import data into the interface tables. The process ID of the job that actually imports the data from the interface table into the application is not included, but is available to view from the Import Suppliers UI once the process is scheduled. NOTE: Sample response payload included below:


    Refer to the following for more details on what this integration service offers:

    1. ERP Integration Services: Automate ERP Inbound Bulk Import Integration
    2. Using External Data Integration Services for Oracle ERP Cloud (Doc ID 2102800.1)

    NOTE: Attached content above in a PDF document.

  • Aishwarya Pawar
    Where can I find FBDI Import templates for my current...5.0
    Topic posted October 26, 2018 by Aishwarya PawarGold Medal: 3,500+ Points, tagged How-To, Import in Procurement > Supplier Management public
    Where can I find FBDI Import templates for my current quarterly update?
    Step by Step instructions to find FBDI Import templates on Oracle Help Center

    File-Based Data Import Templates are used to import supplier data from external sources into Oracle Fusion Procurement Cloud. The templates are routinely enhanced to incorporate new functionality and may differ from one quarterly update to another. These templates are available on the Oracle Help Center and here are the step by step instructions to locate them for a given update. It is recommended that you use templates that correspond to your current update.

    1. Access the Oracle Help Center and navigate to Cloud Documentation.
    2. Click on the Applications link that appears on the left.
    3. Click on the Procurement link available under Application Services > Supplier Chain Management
    4. Select the quarterly update and then click on the Integrate link that appears on the left.
    5. Click on the Get started with file-based data import link. NOTE: You can review the SOAP and REST Services from this page as well.
    6. Expand the File-Based Data Imports section.
    7. All the import templates available for the update chosen are listed.