My Oracle Support Banner

Add New Counter Readings Error: "Counter Reading already exists for the same date timestamp (DD-MMM-YYYY)." (Doc ID 2131874.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Unit Configuration

or

On : 12.2.5 version, Unit Configuration

When attempting to add new counter readings even though no readings exist for that timestamp, the following error is encountered:

ERROR
-----------------------
"Counter Reading already exists for the same date timestamp (DD-MMM-YYYY)."

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. The below API is called from PL/SQL Code.
AHL_UC_UTILIZATION_PVT.update_counter_readings.

Cause

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.