Worksheet Time Window And QUERIES TABLE FROM_DT/ UNTIL_DT Out Of Sync

(Doc ID 2270246.1)

Last updated on MAY 25, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2.3 version, PTP-Gen

WS Time Window and FROM_DT/ UNTIL_DT out of sync

The worksheets' time window and values in columns QUERIES.FROM_DT and QUERIES.UNTIL_DT are out of sync if the time window is set using Relative options.
These dates FROM_DT and UNTIL_DT are used to log audit trail records when settlement and promotion status changes and need them synchronized.

expect that the worksheet time window and the queries tables columns from_dt and until_dt match

The issue can be reproduced at will with the following steps:
1. Create a worksheet with the Relative time filter (regardless if it is relative to Today or Last Sales Date). Note what are the from_dt and until_dt
2. Change the system time to a year forward
3. Open the worksheet
4. Check the table QUERIES if the from_dt and until_dt changed

The issue has the following business impact:
Due to this issue, cannot use the worksheet to log audit trail records when settlement and promotion status change


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