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 |