My Oracle Support Banner

WMS Rule Simulation Fails With Error ORA-00932: Inconsistent Datatypes: Expected %S Got %S (Doc ID 1144663.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Warehouse Management - Version 12.1.2 and later
Information in this document applies to any platform.


Inventory Organization : Process Manufacturing & WMS enabled
Inventory Item: Dual Unit of Measure (DUOM)
Sales Order: Standard order with (Line Flow - Generic workfow).
After Launching pick release (Auto Alocate = No, Auto Pack = No)  it creates a move order.

When opening the WMS Rule Simulation form and attempting to simulate the Move Order it fails with the error message:

ORA-00932: inconsistent datatypes: expected %s got %s
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-00932.


Upgraded 12.1.1 to 12.1.2


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.