My Oracle Support Banner

Import Fails with Invalid Table Name & Mapping Rule Must Have at Least One Debit or Credit (Doc ID 444515.1)

Last updated on FEBRUARY 18, 2009

Applies to:

Oracle Profitability Manager - Version: 11.5.10
Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.


In Profitability Manager, when importing or migrating a Mapping Rule, the import fails and the following errors are in the log file:

Importing rows from xml file, and validating rows ......
An error occurred in API 'DriveAM'
View Object 'ImpExpAllocBrFormulasVO_ImpExpBrToFormulaVL_ImpExpAllocBrFormulasVO'
FunctionSeq = '1'
ObjectDefinitionId = '10520'
&FUNCTION has an invalid table name. Please enter a new name.

An error occurred in API 'ImpExpAllocBrAM'
View Object 'ImpExpAllocBusinessRuleVO'
ObjectDefinitionId = '10520'
Mapping rule must have at least one debit or credit. Both debit and credit cannot be disabled.
Please enable either debit or credit.

Loader request completed.

Steps To Reproduce:

1. Migrate a Mapping Rule from the source instance

2. Import the Mapping Rule


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.