My Oracle Support Banner

'Enter a Valid Dimension.. CAL_PERIOD is invalid' Web ADI Error Running Dimension Load (Doc ID 2296040.1)

Last updated on SEPTEMBER 25, 2020

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.




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

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