Mapping Rule Import with Value Based Dimension gets Error "Cannot be imported because there is an existing definition that was executed and has generated results" (Doc ID 432577.1)

Last updated on OCTOBER 20, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.9 to 11.5.10
This problem can occur on any platform.
PFT
FEM

Symptoms

When migrating a mapping rule that has a Condition with data component that already exists in the target database and is already attached to a mapping rule that has been run, the import process fails with the following error message:

Mapping Rule Import with Value Based Dimension Components:

** EXCEPTION **: Exceptions thrown during the api call.
The rule VALUE:8COMPANY_COST_CENTER_ORG_ID100158413439 with definition
(Import)VALUE:8COMPANY_COST_CENTER_ORG_ID1001584 cannot be imported because
there is an existing definition that was executed and has generated results.
The rule VALUE:8COMPANY_COST_CENTER_ORG_ID100158413439 with definition
(Import)VALUE:8COMPANY_COST_CENTER_ORG_ID1001584 cannot be imported because
there is an existing definition that was executed and has generated results.

o This mapping rule uses a local condition with Financial Element as one of Dimension component
using a Dimension value

-- Steps To Reproduce:
Create a mapping rule (RS_COMP_DEF_RULE1) in Instance #2. Create a version 1 of the rule, but do
not run it. Then migrate the rule. Migration is successful. Now, log into another environment
(Instance #1), import RS_COMP_DEF_RULE1 mapping rule into Instance #1. Run the rule now that it
is newly imported.

Log out of Instance #1, and log back into the original environment (Instance #2). In Instance #2,
create a version 2 (v2 to test migrate) of the mapping rule. Run a migration on version 2 and
import the mapping rule into Instance #1. Log in to Instance #1, import the rule and now you get
an error message

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