My Oracle Support Banner

Cash Flow Distribution CSV File Import Fails With: Code WBS, Description not defined columns in CSV file (Doc ID 2744530.1)

Last updated on JANUARY 25, 2021

Applies to:

Primavera Unifier - Version 19.12.5.0 to 19.12.12.0 [Release 19.12]
Primavera Unifier Cloud Service - Version 19.12.5.0 to 19.12.12.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

On : Unifier 19.12.5.0

When exporting Cash Flow Curve data from Unifier, if a column references WBS, it will export as CBS. When the sheet is then imported back into Unifier, the first error noted below will occur. This will happen if user preference is set to English or Portuguese.

If the users language preference is set to Portuguese, users will receive the second error below after importing the sheet. Internationalizing has entries to translate any reference of description to Portuguese translation of descrição.

This happened in 19.12.5 and also after the upgrade to 19.12.10.1

ERROR
-----------------------

  1. Código WBS, colunas definidas no arquivo CSV.
  2. Código WBS, Description colunas definidas no arquivo CSV.

English Translation: Code WBS, Description not defined columns in CSV file.

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

  1. Log in to Unifier where user language preference is English
  2. Navigate to and open a Cash Flow item
  3. Double click on a Curve
  4. Click Export and Save the CSV file locally
  5. Open the CSV file in Excel. Notice that any column that has WBS in the title shows as CBS
  6. Enter required data, attempt to import into Unifier and see error #1 in the export error file
  7. Follow same steps above but with user language preference set to Portuguese, and see error #2 in the export error file
  8. In both cases, update the Excel file so that any reference to CBS is changed to WBS, and any column that has the word descrição is changed to description. When this is done the CSV file imports as expected.

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.