Error Should Enclose OR In Brackets. Please Chance Criteria During Wave Creation. (Doc ID 2056717.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Wave Planning

When attempting to use an OR condition in the advanced criteria tab during Wave creation, the following error occurs
after they save the condition and click on Launch Online or Launch concurrent button

ERROR
-----------------------
Should enclose Or in brackets. Please change the criteria

The value field is not accepting beyond certain length and tried with alternate work around by using OR clause, but for that we are getting error message


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to the Create wave form
2. Try to define a following condition

Seq And/Or ( Object Parameter Operator Value )
==== ======= === =========================== =========== ======= =
10 ( Sales Order Order Type in Mixed
20 AND sales order Order number IN 12343 )
30 OR ( sales order Order number IN 87676 )


3. Save the changes and Click on Launch Concurrently button and receive the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Users are unable to create a Wave with an OR condition in the advanced 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