Query By Example Does Not Work Properly In The Quantity Limits Screen
(Doc ID 2238305.1)
Last updated on MARCH 05, 2019
Applies to:Oracle Retail Allocation - Version 18.104.22.168 to 14.0.4 [Release 14.0]
Information in this document applies to any platform.
Using Query By Example (QBE) works differently in the Quantity Limits screen vs the Results. QBE for Stores does not work properly in Quantity Limits Screen.
Steps to Recreate
1. Create an allocation with many stores. (All stores or at least stores such that there are numbers such as 11, 111, 112, 113 to see the redundancy)
2. Go to Quantity Limits tab.
3. Add the Query By Example section.
4. Enter 141 in the Location field.
5. Hit the Enter key on the keyboard
6. Note that both stores beginning in 141 are displayed not just 141. (Both 141 and 1411)
7. Enter 141% in the Location field.
8. Hit the Enter key on the keyboard
9. Note that both stores beginning in 141 are displayed not just 141. (Both 141 and 1411)
10. Now go to the Results section and enter 141 in the QBE field.
11. Note that only Store 141 displays.
12. Enter 141% in the QBE field.
13. Note that both 141 and 1411 display in the field.
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