When Attempting to Make Changes to the Planning Sheet Columns via a CSV Import, the Columns Being Updated Do Not Change When They Contain Alphanumeric Characters (Doc ID 3057576.1)

Last updated on NOVEMBER 26, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When attempting to modify columns in a planning Sheet via CSV import with data that contains alphanumeric characters in a text string, the import seems to complete, but the column data is not updated. When using numbers alone in the column data the update is successful and the data updated.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log into the Unifier environment.
2. Navigate to the Company Workspace.
3. Expand the Planning Sheet Node.
4. Export -> Column Data to get the CSV template.
5. Make changes to CSV file.
6. Import the CSV file.
7. Notice that the values were not changed.

Cause

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