OUA Default JRN_EFF_START_DTTM Of 01-JAN-2000 Is Too Recent
(Doc ID 2230160.1)
Last updated on SEPTEMBER 14, 2022
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.6.0.0.1 and laterInformation in this document applies to any platform.
Goal
1. On OUA 2.6.0.0.1. there have been encountered instances where the initial JRN_EFF_START_DTTM of 01-JAN-2000 is too recent.
For meter reads it is needed to use ci_mr.read_dttm when joining to the dimensions, rather than ci_mr.jrn_update_dttm. The reason for this is that it may take a number of days for meter reads to reach CCB, in which time the property could have changed - e.g. gone from being occupied to vacant. I.e. it is a need to capture the dimensional at the time of the read, not when the read entered CCB. We will also have to retrospectively load missing/failed reads.
Is there any way that it be changed the default JRN_EFF_START_DTTM to be an older date - e.g. 01-JAN-1971 or even 01-JAN-1901?
Solution
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
Goal |
Solution |
References |