File Effective and Publish Dates Should Not Contain Time Element

(Doc ID 2337807.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Retail Macro Space Management - Version 14.1 and later
Information in this document applies to any platform.


When setting the effective date for a file in Store Manager dialog, the effective and publish dates include the current time.
These dates are truncated and should not include the time element as it affects some of the reports.

Steps to Reproduce:

  1.  Open Select Floor-Plan dialog (in Planner or ISSC).
  2.  Set effective date for a floor-plan
  3.  Validate the FIL_EFFECTIVE_DATE & FIL_PUBLISH_DATE fields in database.




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