My Oracle Support Banner

ODI 12c Dimensions Mapping Fails Validation with a Null Pointer Exception (Doc ID 2280505.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.


An Oracle Data Integrator (ODI) Mapping built upon Dimensions fails validation with a Java Null Pointer Exception (JNPE), as noted by this error excerpt:

JNPE at oracle.odi.domain.mapping.component.dimension.DimensionPattern.validateSCDAttributesOnDimensionComponent (

Additionally, the click on the Mapping "Physical" tab shows the following error in the ODI Studio "Messages - Log" window:

Jul 20, 2017 8:10:59 PM oracle.odi.mapping
WARNING: Validation error found for component: <CUBE NAME>

Jul 20, 2017 8:10:59 PM oracle.odi.mapping
WARNING: Logical mapping issues found when building physical design:
Java Exception thrown:
  at oracle.odi.domain.mapping.component.dimension.DimensionPattern.validateSCDAttributesOnDimensionComponent(
  at oracle.odi.domain.mapping.component.dimension.DimensionPattern.validate(
  at oracle.odi.domain.mapping.component.ExpandableComponentDelegate.customValidation(
  at oracle.odi.domain.mapping.MapComponent.validate(
  at oracle.odi.domain.mapping.MapComponentDelegator.validate(
  at oracle.odi.domain.mapping.MapComponentOwner.internalValidate(
  at oracle.odi.domain.mapping.MapComponentOwner.validate(
  at oracle.odi.domain.mapping.Mapping.validate(
  at oracle.odi.domain.mapping.physical.MapPhysicalDesign.calculateSpec(
  at oracle.odi.domain.mapping.physical.MapPhysicalDesign.calc


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.