Select Stock Order Query Displaying All Rows For Certain Filter Columns

(Doc ID 2139914.1)

Last updated on MAY 23, 2016

Applies to:

Oracle Retail Warehouse Management System - Version 14.0 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Warehouse Management System (RWMS) 14.0.X version, when attempting to run query in select stock order, displays all stock orders when filtered by certain fields.

Steps to Reproduce:
1. Login to RWMS and navigate to Distribution Planning.
2. Select stock order.
3. Build query.
4. In the column field, select one of the following

  1. BILL_COMPANY_NAME
  2. BILL_COUNTY
  3. BILL_LAST_NAME
  4. BILL_PHONE
  5. BILL_PHONETIC_FIRST
  6. BILL_PHONETIC_LAST
  7. BILL_PREFERRED_NAME
  8. SHIP_COUNTY
  9. SHIP_LAST_NAME
  10. SHIP_PHONE
  11. SHIP_PHONETIC_LAST
  12. SHIP_PREFERRED_NAME

5. Enter the data for the column.
6. System would display all orders without any filtering.

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