Process of Importing Manufacturers in Oracle cloud fusion

 

Process of Importing Manufacturers in Oracle cloud

The purpose of this document is to explain the step by step process of Importing Manufacturers in Oracle cloud. As compared to other data elements, Manufacturers cannot be imported by usual File-based Data import (FBDI) functionality or through Import Batches (specific to PDH). In earlier releases Manufacturers were imported through Oracle Sales Cloud Process using “Manage File Import Mappings” and “Manage File Import Activities” task from Setup and Maintenance. However, starting from 21A release, the process has changed and now Import Management workarea is used for bulk import of Manufacturers. Import Management improves definition, error handling, and performance for importing flat files (.CSV). For example, Import Management has drag and drop mapping capabilities and validates the first ten records in your data file before you import to ensure the data meets the import constraints of the various attributes. Following are the steps to bulk import Manufacturers in Oracle Cloud:

Step: 1 Go to Navigator and click on Import Management under Tools. Here search for Organizations under Import Objects tab. Click on download button to download the import template.

Step: 2 The downloaded template which is a Comma Separated Values(.CSV) file has to be populated with the Manufacturer’s data that needs to be imported. Below is the reference mapping for the required attributes. The Spreadsheet will contain many other fields which can be removed as it is needed for the Manufacturer import.

Save the .CSV file once all the data is populated as shown below in sample screen shot:

Step: 3 Now to import the data, click on “Create Import Activity” and create a new import. Select object as “Organization” and upload the saved spreadsheet from the previous step

Click on Next and select “Automatic Mapping”. Validate the data and then click on submit when ready.

Step: 4 After submitting the process, check the status under Import Queue tab. Click All Imports and search for the import activity that you created earlier. Check the Status column for the import activity. The import is successful if the status displays as Completed. You can drill down on the import activity to go to the Import Status page which provides the status details of the import activity

Step: 5 After the process is complete, navigate to Product Information Management work area and go to “Manage Trading Partner” task to validate the imported Manufacturers. Click on Edit Trading Partners and search for the imported Manufacturers

Points to Remember:

 • Don't submit duplicate import jobs for the same import object as they create duplicate object records.

• Don't import more than 100,000 records in a single import operation or perform more than five concurrent import activities