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.

Symptoms

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:

Error

The upload process has completed with errors. Press close to return to the document and fix the
errors.
* 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.

Changes

 

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
Changes
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.