My Oracle Support Banner

'Debit Has An Invalid Dimension Usage Code' Messages During iSetup Load (Doc ID 1509398.1)

Last updated on DECEMBER 04, 2012

Applies to:

Oracle Profitability Manager - Version 12.0.6 and later
Oracle Enterprise Performance Foundation - Version 12.0.6 and later
Information in this document applies to any platform.
iSetup

Symptoms

In Profitability Manager (PFT) 12.0.6, when you are loading Mapping Rules from a development environment into production using iSetup, the Load request ends in an error and the following messages are output to the Load's View Log:

-----------------------------------------
An error occurred in API 'ImpExpAllocBrAM'
View Object 'ImpExpAllocBusinessRulesVO_ImpExpAllocBrFormulasVO_ImpExpBrToFormulaVL_ImpExpAllocBrFormulasVO'
 Function Seq = '1'
 Object Definition Id = '22882'

-----------------------------------------
Message not found. Application: AZ, Message Name: AZW_FWK_USER_ROW_EXCEPTION. Tokens: VONAME = Imp Exp Alloc Business Rules VO_Imp Exp Alloc Br Formulas VO_Imp Exp Br To Formula VL_Imp Exp Alloc Br Formulas; KEY = Function Seq = '1051'
 Object Definition Id = '22882'
; EXCEPTION = Debit has an invalid dimension usage code specified for Company Cost Center Organization. Please select a valid value.
;
-----------------------------------------
Message not found. Application: AZ, Message Name: AZW_FWK_USER_ROW_EXCEPTION. Tokens: VONAME = Imp Exp Alloc Business Rules VO_Imp Exp Alloc Br Formulas VO_Imp Exp Br To Formula VL_Imp Exp Alloc Br Formulas; KEY = Function Seq = '1052'
 Object Definition Id = '22882'
; EXCEPTION = Credit has an invalid dimension usage code specified for Company Cost Center Organization. Please select a valid value.
;
-----------------------------------------


Note: If <Patch 14044354> "DEBIT HAS AN INVALID DIMENSION USAGE CODE DURING ISETUP LOAD') Patch" is installed, the messages change to the following:

-----------------------------------------
An error occurred in API 'ImpExpAllocBrAM'
View Object 'ImpExpAllocBusinessRulesVO_ImpExpAllocBrFormulasVO_ImpExpBrToFormulaVL_ImpExpAllocBrFormulasVO'
 Function Seq = '1'
 Object Definition Id = '22882'

-----------------------------------------
Message not found. Application: AZ, Message Name: AZW_FWK_USER_ROW_EXCEPTION. Tokens: VONAME = Imp Exp Alloc Business Rules VO_Imp Exp Alloc Br Formulas VO_Imp Exp Br To Formula VL_Imp Exp Alloc Br Formulas; KEY =  Function Seq = '1051'
 Object Definition Id = '22882'
; EXCEPTION = The formula is not properly constructed.
;
-----------------------------------------
Message not found. Application: AZ, Message Name: AZW_FWK_USER_ROW_EXCEPTION. Tokens: VONAME = Imp Exp Alloc Business Rules VO_Imp Exp Alloc Br Formulas VO_Imp Exp Br To Formula VL_Imp Exp Alloc Br Formulas; KEY =  Function Seq = '1052'
 Object Definition Id = '22882'
; EXCEPTION = The formula is not properly constructed.
;
-----------------------------------------


As a result of the errors, no Mapping Rules are imported into the Target Environment.

Steps to Reproduce:

  1. Go to the iSetup responsibility
  2. Go to Migrations > Loads
  3. Click Create
  4. Enter a Name and select an Extract to load
  5. Submit the Load request

The load ends with an error.

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