1. Integration Playbooks for SCM
  2. Import Map

Import Map

Use the import map integration option to build a reusable mapping that provides details about the relationship between the input data element and the Oracle Fusion Cloud Product Lifecycle Management (PLM) Item Master attribute.

Import map integration is helpful when the input data file layout from your external data sources might not correspond to the master data for Oracle Product Hub. With the mapping that the integration builds, you can import data from the source system.

Note: To use import map functionality, you must have an Oracle Fusion Cloud Product Management license.

Key Features

  • UI-based mapping.
  • CSV, XML, or nested XML used as input source data files.
  • Map source-data elements to target data elements.
  • Preview the resultant data.
  • Generate multiple Smart Spreadsheet templates specific to input data profile. For example, computer hardware, plumbing supplies, and so on.
  • Generate supplier-specific downloadable Smart Spreadsheet templates to closely match a specific supplier's data map.

Best Practices

  • Import map template usage guidelines:
    • Before uploading the data, ensure to validate by explicitly clicking on the validate button.
  • Import map file-upload guidelines:
    • Limit the number of rows in the data file to 10,000 if you're uploading the file from Manage Item Batches > Add Items to Batch UI flow.
    • If you're going to upload more than 10,000 rows, use the Schedule Item Import scheduled process.
    • Ensure the date and date time formats match the import map setup to minimize errors during upload.
    • Note that the numeric decimal separator and grouping separator are adhered to based on the user's locale. The application user preferences aren't considered.

Constraints

For Smart Spreadsheet:

  • The maximum number of rows that you can upload is 10,000.
  • If an attribute has a value set with more than 10,000 values, the attribute isn't shown as a drop-down list of values (LOV). The values will be treated as free text and validated only at the time of item import.
  • For descriptive flexfield (DFF) attributes, valid values aren't shown as a drop-down LOV. The values will be treated as free text and validated only at the time of item import.
  • Dependent value sets don't show dependent values in the template. All values from the value set are shown in the drop-down list of the template.

Related Topics