'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

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