"If a dimension value is specified, the dimension usage must be 'Value'" Error After Import of Percent Dist Mapping Rule (Doc ID 763875.1)

Last updated on JANUARY 27, 2009

Applies to:

Oracle Profitability Manager - Version: 11.5.10.2 to 11.5.10.2
Oracle Enterprise Performance Foundation - Version: 11.5.10.2 to 11.5.10.2
This problem can occur on any platform.
Import/Export Mapping Rules

Symptoms

-- Problem Statement:
On 11.5.10.2 in when attempting to migrate a Pct Dist mapping rule the following error occurs:

ERROR
Importing rows from xml file, and validating rows ......
An error occurred in API 'DriveAM'
View Object 'ImpExpAllocBrDimensionsVO_ImpExpFormulaToDimVL_ImpExpAllocBrDimensionsVO'
PostToBalancesFlag = 'N'
FunctionSeq = '1051'
ObjectDefinitionId = '24031'
AllocDimColName = 'USER_DIM5_ID'
If a dimension value is specified, the dimension usage must be "Value"

In the Debit section, one of the percent distribution dimensions is also incorrectly set to "Same as Source" instead of "Same as Pct".

Cause

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