My Oracle Support Banner

"ORA-00932: inconsistent datatypes: expected - got NCLOB" (Doc ID 2897393.1)

Last updated on SEPTEMBER 21, 2022

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 22.2 and later
Information in this document applies to any platform.


When searching in 'Inventory History UI' screen for the records created today with the Activity Code '23 - Lock Container - After ASN Verification', WMS loads for some seconds and then returns the following error message:
"ORA-00932: inconsistent datatypes: expected - got NCLOB"

Steps to reproduce it:
1. Open 'Inventory History' screen
2. Enter the today's date value ("09/19/2022"), keeping the hour as "00:00 a.m."
3. Enter the activity code 23 - "Lock Container - After ASN Verification"
4. Click on 'Search' button. After less than 40 seconds, the error message appears.



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.