My Oracle Support Banner

File Effective and Publish Dates Should Not Contain Time Element (Doc ID 2337807.1)

Last updated on FEBRUARY 28, 2019

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.


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.