JBO-25013 Too Many Objects Error During PFT 11i Rule Migration With Data Component (Doc ID 780013.1)

Last updated on AUGUST 03, 2010

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10.2 to 11.5.10.2 - Release: 11.5 to 11.5
Oracle Profitability Manager - Version: 11.5.10.2 to 11.5.10.2   [Release: 11.5 to 11.5]
Information in this document applies to any platform.
Rule Migration
Export Mapping Rules
Import Data Components and Conditions

Checked for relevance on 03-Aug-2010.

Symptoms

On 11i.FEM.D.1 Rollup #4 and 11i.PFT.A.1 Rollup#4, when attempting to migrate mapping rules with data components on dimension columns with lists of dimension members, the following error occurs:

ERROR
Importing rows from xml file, and validating rows ......
An error occurred in API 'DriveAM'
View Object 'ImpExpCondDataCmpStDtlsVO_ImpExpDataCmpStepsToDtlsVL_ImpExpCondDataCmpStDtlsVO'
TableName = 'FEM_BALANCES'
CondDataCmpObjDefId = '41123'
CriteriaSequence = '27'
StepSequence = '1'
JBO-25013: Too many objects match the primary key oracle.jbo.Key[13173 FEM_BALANCES 1 14 ].

An error occurred in API 'DriveAM'
View Object 'ImpExpCondDataCmpStDtlsVO_ImpExpDataCmpStepsToDtlsVL_ImpExpCondDataCmpStDtlsVO'
TableName = 'FEM_BALANCES'
CondDataCmpObjDefId = '41123'
CriteriaSequence = '28'
StepSequence = '1'
JBO-25013: Too many objects match the primary key oracle.jbo.Key[13173 FEM_BALANCES 1 null ].

Several rows are also missing from the target instance Data Component.

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Export rule with a Data Component containing a list of "to include" dimension members from Source instance
2. Import the rule into the Target instance
3. The import request ends with warning, but the mapping rule is successfully created with a few dimension members missing from the original Data Component

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