My Oracle Support Banner

Attribute Sorting While Uploading From Excel Sheet Not Sorted (Doc ID 1606860.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Upload data to PIM via Import from Excel sheet.
Use the majority of Multi Row Attributes. PIM system should pick the data the way data is present in Excel sheets.
PIM system takes the data based on some random ordering rather than using the same ordering as given in the spreadsheet, and this cause issues for the business.

EXPECTED BEHAVIOR
Expect PIM system to receive the data the way the data is present in the Excel Sheets.

Change Order Update page does not allow row sorting. So no workaround.

STEPS
The issue can be reproduced at will with the following steps:
1. Upload data to PIM via Import from excel.  Find that the data is not uploaded in the order it is present in the Excel Sheet.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.