My Oracle Support Banner

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

Last updated on SEPTEMBER 16, 2019

Applies to:

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


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

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

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 XXXXX)
30 OR ( sales order Order number IN YYYYY)

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

The issue has the following business impact:
Users are unable to create a Wave with an OR condition in the advanced criteria




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.