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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.