When the Filter Option Is Used to Fetch Schedules Based on the "Next Schedule Date", NULL Records Are Displayed Along With the Next Schedule Date Records (Doc ID 2022783.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 14.0.1 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Store Inventory Management (SIM), when the Filter option is used to fetch schedules based on the "next schedule date", NULL records are displayed along with the next schedule date records.


Steps to Reproduce:

  1. Create a Product Schedule Group to start from 25/07/2015 till 30/07/2015, daily basis.
  2. Save and exit the Product Schedule Group menu.
  3. Come back to the Product Schedule Group menu and open the filter.
  4. In the NEXT SCHEDULE DATE field, key in 25/07/2015.
  5. Note that all the past records where next date is null ( Final date < sysdate ) are also displayed.  It is expected that only the exact matched records for the filter criterion would be displayed.

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