Is there a patch for 21663638 - FUSION APPS FUNCTIONALITY FAILURE DUE TO TYPE MISMATCH IN ENQUEUE/DEQUEUE MESSAGE for JDBC 12.1.0.2?

(Doc ID 2336823.1)

Last updated on DECEMBER 07, 2017

Applies to:

JDBC - Version 12.1.0.2.0 to 12.1.0.2.0 [Release 12.1]
Information in this document applies to any platform.

Goal

Unpublished Bug 21663638 - FUSION APPS FUNCTIONALITY FAILURE DUE TO TYPE MISMATCH IN ENQUEUE/DEQUEUE MESSAGE relates to Fusion Applications.
Fusion Middleware Release Notes for Oracle Fusion Middleware Infrastructure 12.1.3 states:

-----------

When you use Oracle Fusion Middleware with Oracle Database 12.2 or higher, you may encounter the following error:

ORA-00932: inconsistent datatypes: expected SYS.AQ$_JMS_MESSAGE gotSYS.AQ$_JMS_MESSAGE
The error occurs because during enqueue and dequeue of AQ$_JMS_MESSAGE type, the version number sent to the database server may be inconsistent. This happens when TOID (the type's unique identifier) for AQ$_JMS_MESSAGE type in type$ is a user-defined TOID and not a fixed SYSTEM defined TOID.

To work around this error, install the following patch, which replaces the ojdbc6.jar file used by Oracle Fusion Middleware:

https://updates.oracle.com/download/21663638.html
For Oracle Fusion Middleware 12.1.3, select Release 12.1.0.2.0.

-----------

 

If not using FMW, is there a patch for Database JDBC 12.1.0.2?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms