My Oracle Support Banner

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 FEBRUARY 22, 2019

Applies to:

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


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.




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.