Wave Run Using The Wave Template With Task Template Details (Selection Criteria) Using the SQL Operator <> Fails With "Exception <>"

(Doc ID 2385839.1)

Last updated on APRIL 12, 2018

Applies to:

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

Symptoms

On : NA version, Core Product Functionality

Wave run using the wave template with task template details failed with Exception <>

For this template the following selection criteria is configured using the “Insert Basic operation” :
a. SQL operator -- <>
b. Column name – From Location Barcode
c. Column value – 111-111-AAA

One Wave Template uses the aforementioned setup. This wave is for a specific Customer Order;  "Customer Order Task," the Message Text:   “Exception <>” is shown in the wave inquiry.

ERROR
-----------------------
Exception <>

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Task Creation
2. Set Selection Criteria as:
a. SQL operator -- <>
b. Column name – From Location Barcode
c. Column value – 111-111-AAA
3. Use this setup in a Wave Template
4. Get Error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use this Selection Criteria

Cause

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