'Enter a Valid Dimension.. CAL_PERIOD is invalid' Web ADI Error Running Dimension Load

(Doc ID 2296040.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Enterprise Performance Foundation - Version 12.1.3 and later
Information in this document applies to any platform.


In Oracle Enterprise Performance Foundation (FEM) 12.1.3, when using the Web ADI "Create from Spreadsheet" option to load Calendar Period dimension members, you get the following error after populating the spreadsheet and selecting to upload:


The upload process has completed with errors. Press close to return to the document and fix the
* Upload validation aborted
* No rows uploaded
* 13 rows were invalid
* Enter a valid Dimension.. CAL_PERIOD is invalid. Enter a valid value for the Mapping
column Dimension.

There is also a Microsoft Visual Basic error:

Run-time error '1004':

Method 'Undo' of object '_application' failed.

As a result of this issue, you cannot add new dimension members using the Spreadsheet Upload option.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms