My Oracle Support Banner

Transformation Install Fails with "ORA-00932: inconsistent datatypes" after DMW 3.1.1.1 Upgrade (Doc ID 2847176.1)

Last updated on FEBRUARY 08, 2022

Applies to:

Oracle Health Sciences Data Management Workbench - Version 3.1.0 to 3.1.0 [Release 3.1.0]
Information in this document applies to any platform.

Symptoms

After upgrading DMW from 3.1.0 to 3.1.1.1 you are unable to install the Transformation in full mode, which fails with the errors below shown in the job log:

Application encountered error while processing this job.-932ORA-00932: inconsistent datatypes: expected an IN argument at position 11 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class

ORA-00932: inconsistent datatypes: expected an IN argument at position 11 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class
ORA-06512: at "APPS.CDR_EXE_JOB_ENGINE", line 742

Execution Status : SETFAILURE :: Job Status: Failure :: 02-01-2022 08:26:03
:: Error Description: Job operation failed.

Changes

 

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
Changes
Cause
Solution


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