My Oracle Support Banner

ODI 12c Validates Mapping with SET Component but Fails at Scenario Generation with Fatal Error "Caused by: JNPE" (Doc ID 2316024.1)

Last updated on MAY 27, 2020

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


In Oracle Data Integrator (ODI) 12c, generating a Scenario of a specific Mapping using the SET component fails even though the Mapping can be validated without errors.  The error message received is as follows:

Fatal Error when calling generation delegate for component KM XKM
SQL Set: null Caused by: JNPE

To reproduce the behavior:

  1. Open ODI Studio > Designer and navigate to the Mapping.
  2. Edit the Mapping, and on the "Logical" tab, observe the (SET component).
  3. Click on the green check mark to validate the Mapping. Observe this works without errors.
  4. Attempt to generate a Scenario from the Mapping, and observe this fails.




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.