My Oracle Support Banner

Counter Reading Value_timestamp Is Creation_date Instead Of Source Creading Value (Doc ID 1277514.1)

Last updated on SEPTEMBER 24, 2021

Applies to:

Oracle Installed Base - Version 12.1.1 and later
Information in this document applies to any platform.


On : 12.1.1 version,

Find that after entering a counter reading for a Regular counter that the Date for the associated Formula counter with group by function = Count does not match the date entered for the counter reading. Instead the Date is the sysdate.

Expect the date (VALUE_TIMESTAMP) of the formula counter to match the date of the source counter.

The issue can be reproduced at will with the following steps:
1. Create a regular counter C1, Type = Regular, Reading Type = Change and Direction = Fluctuating
2. Create a formula counter C2 with group by function = Count, Source counter = C1
3. Enter reading for C1 with time stamp earlier than sysdate
4. View readings for C2 - The reading shows count correctly but the value of the timestamp is sysdate

The issue has the following business impact:
Due to this issue, service contract billing will have incorrect date for number of counts scenario.


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.