OBIA Error When Executing A Fusion Source Scenario in the Load Plan Using ODI (Doc ID 2261613.1)

Last updated on MAY 26, 2023

Applies to:

Symptoms

For Fusion 11 source with Fusion 10 adaptor (OBIA) instead of 11 adaptor:

When executing a scenario in the load plan, receive ORA-20942: java.lang.RuntimeException

Error:
------
ODI-1217: Session SDE_FUSION_10_ADAPTOR_SDE_FUSION_SUPPLIERACCOUNTDIMENSION
(5500) fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target
ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: java.lang.RuntimeException:
java.lang.IllegalArgumentException: Driver class name must not be empty
at
oracle.odi.core.datasource.provider.AbstractDataSourceProvider.configure(Abstr
actDataSourceProvider.java:106)
at
oracle.odi.core.DataSourceManager$LoginTimeoutDataSourceProviderProxy.configur
e(DataSourceManager.java:303)
at
oracle.odi.core.DataSourceManager.createAndConfigureDataSourceProvider(DataSou
rceManager.java:229)
at oracle.odi.core.DataSourceManager.access$0(DataSourceManager.java:203)
at oracle.odi.core.DataSourceManager$1.create(DataSourceManager.java:77)
at
org.springframework.util.CachingMapDecorator.get(CachingMapDecorator.java:253)

at java.util.Collections$SynchronizedMap.get(Collections.java:2037)
at oracle.o => ORA-20942:
ORA-06512: at line 57

The following steps for extracting the data to UCM from the Fusion source in the form of csv files has been followed:

Oracle® Business Intelligence Applications Installation Guide

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.